Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: How to reference USER info....

    I have an associate License table that lists the Licenses each associate has as checkboxes(yes/no). Another table with a record for each state lists wether license required by that state.

    Is there any way when a certain user is on, and pulls up a record for a state they are not licensed to reference the License table and MsgBox "You are not licensed in this state."

    I don't need to lock them from accessing that record, only need to remind them they are not licensed in that state.

    How do I write that? How does Access process user info? What sort of information does it take when the user opens the FE like ID for example. And I don't want users to have to enter any password when they open the FE.

    Can it just take their network login info and use that as reference?

    I'm really new to the advanced side of Access and appreciate all the help this forum has given me!


    Chris H.

  2. #2
    Join Date
    Feb 2004
    Set a variable = Environ("USERNAME"). This will give the PC logon ID.

Posting Permissions

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