?
Solved

How do I get the "created by" field from my linked Sharepoint List to appear in the associated Access table?

Posted on 2014-11-24
2
Medium Priority
?
1,297 Views
Last Modified: 2014-11-25
I have a SharePoint list that asks people to supply information regarding an item with which they need help.  From there, I have created the associated Access DB to run reports on what has been completed and email back out to the people that submitted to the SharePoint.  However, when I open the table based on the SharePoint list, I am not getting the "Created By" field.  I see it in the design view as a column, but it is missing from the actual table.

Where is it?

Thanks!
0
Comment
Question by:Dominator1025
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 2000 total points
ID: 40463682
If you can see it in the design view as a column; then they are just hidden.

In Access, switch over to datasheet, then right-click a column header and select command “Unhide Field” which will give you a list of fields that are hidden – check what you want to see.
0
 

Author Closing Comment

by:Dominator1025
ID: 40464828
Perfect, thanks!
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question