Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    43

    Exclamation Unanswered: User id field + date of update

    For security reasons I need to create two fields in a form with the following info; one field with the user id of the person who updates a record and the other one with the date of update.

    How do I get access to automatically fill in this info when a record is saved ?

    Many thanks in advance for your help !!

    Chiron

  2. #2
    Join Date
    Nov 2003
    Posts
    267
    If you are using bound form, add the two text boxes to you form (that are linked to the field in question) where this information will be captured when data in any of the other text boxes changes (use on change event in each of the text boxes). If you can't display this info on your form, then make them invisible and follow the same logic.

    If you are using ADO or DAO then jest include that information in you recordset update

    S-

  3. #3
    Join Date
    Nov 2003
    Posts
    43
    Thanx Sbaxter !! Any idea what code I should use to capture the username /userid ?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    CurrentUser() Reports either the user logged into the DB or "Admin" as the default ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •