To get the date and time you can use the Now function. You could create a table with three fields such as in/out, person and a date time field with a default value of now().
Put a button on your form using the Access wizard and choose record operations, create a new record, and insert the time with a command. When the person pushes the button the form will open allowing them to choose whether they are coming or going, their initials so you will know who they are and a time/date stamp. Is this what you want? If you just want to fill in the form with a date stamp then you could use field = now for the button action. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of davr1966 Sent: Sunday, November 19, 2006 07:23 AM To: [email protected] Subject: [Access VBA Central] Creating a button that generates the current date and time I would like to automate a "Time In - Time Out" fuction on a attendance program. How can I create a button that when clicked inserts the current date and time in a field? [Non-text portions of this message have been removed]
