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
892 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
Comment Utility
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
Comment Utility
Perfect, thanks!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now