Results 1 to 2 of 2
  1. #1
    cwatts521 is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    1

    How can a record ID be flagged with the user who entered it?

    We have a large system in use that involves multiple users downloading documents into the database to be reviewed and accessed for daily workflow.
    How or can the downloads that are being loaded to the database be flagged with the user initials that are loading the documents automatically?

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    Yes. User the GetUserName routine in the code bank and set this as an expression in a query to append to the data table (which should have an EnteredBy and DateEntered field). You would do this in the append query which moves the data from the external source appending it to the main table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 06-09-2011, 03:41 PM
  2. User entered filename for ExportXML?
    By nhabegger in forum Import/Export Data
    Replies: 1
    Last Post: 10-08-2010, 08:54 PM
  3. Replies: 1
    Last Post: 09-19-2009, 09:37 AM
  4. Replies: 5
    Last Post: 08-05-2009, 12:13 PM
  5. Replies: 0
    Last Post: 11-10-2008, 12:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums