Results 1 to 3 of 3
  1. #1
    Danny729 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2022
    Posts
    4

    Check box to return information

    I'm very new to access so please dumb down all responses!


    I have a database and form set up, but what if like to do is prove who approved of each firm. Since having a text box can allow anyone to type a name in I'm looking for an alternative method.
    One thing I'd like to implement is a check box that, when checked, a field record the network username of who checked the check box, and another field that records the date the was checked.
    Is this possible? If so, how do I do this?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    Explore the Environ() function.

    Me!USERfieldname = Environ("USERNAME")
    Me!DATEfieldname = Date()

    Place code in checkbox AfterUpdate event.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Danny729 is offline Novice
    Windows 10 Office 365
    Join Date
    Jul 2022
    Posts
    4
    I can't believe it was that easy! Thank you so much for the quick response. It worked perfectly.

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

Similar Threads

  1. Date comparison return certain information.
    By ChrisNWV in forum Access
    Replies: 2
    Last Post: 09-22-2014, 01:09 PM
  2. Replies: 5
    Last Post: 05-09-2014, 09:32 AM
  3. merging check box information into Word Docs
    By LeesKeys in forum Access
    Replies: 1
    Last Post: 10-19-2011, 03:37 PM
  4. check and return specified text
    By nosiss in forum Queries
    Replies: 7
    Last Post: 05-17-2011, 02:29 PM
  5. Check box return value
    By nbryant in forum Queries
    Replies: 1
    Last Post: 10-26-2010, 12:24 PM

Tags for this Thread

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