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,045 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 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