Capture User's Actual Name in Field

  • Thread starter Thread starter jjones
  • Start date Start date
J

jjones

I am using Access ’97 on a shared network environment. On one of my forms I
have a combo box (based on an Employee table) where users can select their
name. I’d like to enhance this by having their name auto-populate that combo
box when they update one of my other toggle buttons. I think I can nest this
code into an event procedure in the toggle button, but I have two problems—1)
I’m not sure how to write this code., and 2) I want to capture their actual
name, not our network’s unrecognizable workstation ID number. I could always
go back to my Employee table and add another field to store each person’s
workstation ID number if that will help (i.e. if there is some code that will
essentially lookup the workstation ID number in my table and return the name).

I’ve seen all the posts referencing the site below, but this isn’t exactly
what I need.
http://www.mvps.org/access/api/api0008.htm
 
Oh, one other thing I thought of—this code should probably have some kind of
“If†or “Case Else†component just in case the workstation ID doesn’t match
anything in the table. New users could begin using this database before I
have a chance to get them into the table, or existing users could get a new
PC/workstation ID. In such case I would like to default back to simply
allowing the user to manually enter their name into the combo box…would also
be nice to pop a message box that says something like “You are not listed as
an authorized user of this database. Please see administrator.†Just trying
to plan ahead and avoid any code meltdowns…
 
Back
Top