DO I Need an Input Box?

[Noreene Patrick]

Okay, it's me again.

I have a form that when opened, I want it to allow the user to put in their id number that goes to the table that is the forms source. Then when they hit enter or OK, I want it to pull up a form that has only one command button on it (log in) and it time stamps that time and date into the same table to the id number just entered.

I cant figure out how to tell the input box? that when this id is entered, add it to the table and also to enter the timestamp from the command button (log in)to that same id.

I am trying to allow the employees to stamp their in and out times with as few keystrokes as possible for them. After they log in, the form should close.

Now, when they get ready to log out, I want them to go through the same process of entering their id BUT, the only button that will be available that time will be the form with command button called logout. So, Access checks the id number and determines if this person is already logged in so their only option left is log out.
(This would also timestamp to the table).

I know this is not complicated to you, but if you could just start me in the right direction I would appreciate it very much..

THanks, Noreene

 

[WayneRyan]

Noreene,

This issue is actually a little bit deeper than you think. It is
very easy to retrieve the user's Windows Login name.

Below is a link to some threads with samples. Some will have
more than you want to implement.

Be sure to see ghudson's contribution on the third thread.

http://www.access-programmers.co.uk...d=278385&sortby=lastpost&sortorder=descending

Wayne