Results 1 to 2 of 2
  1. #1
    joeydeck is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Sep 2012
    Posts
    26

    Question Updating field problem, Usernames

    Hello,


    I have a form which brings in a Username of the user that is logged in by setting the default value as a function '=Username()' which is created by a variable.

    This all works great but when i log in as another user to test it changes all the previous records from the first user. i have added a Save record button but this hasn't helped, any ideas?

    Thanks
    Joe

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,536
    There are several tutorials on this site that talk to tracking and logging users.

    http://www.datawright.com.au/access_...ces/access.htm

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

Similar Threads

  1. Create a database to hold usernames and passwords
    By sentinelace in forum Programming
    Replies: 1
    Last Post: 10-25-2010, 07:45 AM
  2. problem with the updating form
    By ngeng4 in forum Forms
    Replies: 32
    Last Post: 03-09-2010, 01:58 AM
  3. Problem updating from within a query.
    By Frank Nye in forum Queries
    Replies: 5
    Last Post: 10-14-2009, 10:33 AM
  4. new problem: Updating Combo box
    By ali-gagi in forum Forms
    Replies: 4
    Last Post: 07-06-2009, 07:29 PM
  5. Replies: 0
    Last Post: 12-20-2007, 12:32 AM

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