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
1,006 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
2 Comments
 
LVL 7

Accepted Solution

by:
Ray earned 500 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 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