Using an Id Login

[Alansa56]

Sir , I have created a Timesheet database, and I would like the induvidual to
login with their Employee Id no. Once thats done, a timesheet form with their
Name and Id No in chosen controls will be retrieved .Then he/she can enter
the Job No. and time which will be accumulated to the maximum of ten hours.
The forms are done , so is the Employees query of the employees table with
fields of Employee name , Employee Id. I was trying to use the If ...then ...
else proprties, but I cannot come up with the correct syntax. I have it
working with induvidusal macros , but I cannot create 100 of them .
Please can you help?

 

[bhipwell via AccessMonster.com]

I think I understand your question. Basically you want your employee ID to
act as a password to open a form to complete specific to that individual. I
am assuming you have the employee ID in the table. If so, create a "login"
form in which the employee will enter their ID.

Using the simple access wizard, have the button to "sign on" link the
criteria of the ID your employee just ented against your table, thus pulling
up their data.

Make sure you have a way out of the code in case sometime types in an ID that
doesn't exist. When just doing the above, and someone types in a wrong ID,
the next form will open blank. You can use a simple "If null" statement on
the opening form with the ID field on it since it will be empty if the wrong
ID is typed in.

Hope this helps.

B