I'm doing a little database for work, and i want, when the database starts up, to take the logon ID of the user (say, 1037897) and check it against the list of IDs in tbl_staff and if its not there, bring up a form asking the user to input their name and surname and enter their hours for the week.
I can do most of it, but i need to know the code for taking a system variable (such as logonID in XP), so i can make it auto-appear in the form that pops up in the top, i assume it's just a query i can run after to check for the presence of it then.
Can anyone help?
I can do most of it, but i need to know the code for taking a system variable (such as logonID in XP), so i can make it auto-appear in the form that pops up in the top, i assume it's just a query i can run after to check for the presence of it then.
Can anyone help?
