Microsoft Access Help [Archive] - SpeedGuide.net Broadband Community

View Full Version : Microsoft Access Help


Mecoli
07-15-02, 12:56 PM
I have it set up to use sort of like a time clock. When you open the form it has a pop-up box asking for a pin #. Then it opens the form and you select your name and hit the time-stamp button to record the date and time for that punch. It stores all of that information in a table I have to store all the punches.

After the first time you can use the same pin # to pull the records back up for additional punches for that day.

My question is, how can I set it up so that it automatically selects the name depending on what the pin # is?

Thanks,
Mike

General_Jack_As
07-15-02, 05:18 PM
Are you using ADO, DAO, or a Data Enviroment? What version of VB are you using and what Service Pak do you have?

Mecoli
07-15-02, 05:28 PM
Actually I got it now, but i appriciate the response...
Thanks.