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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
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…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

717 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