Hi, I have been tasked to create a visitors database for our facility. I have a main form which shows contractors / visitors etc who are currently clocked in (in a subform), and those which are clocked out (another subform). Originally, I was going to do this by a dbl click event procedure, however, the big cheeses over here want to do this via a Visitor Profile form, and they want the "Clock In" and "Clock out" to be by a button.
So... double click a name from one of the subforms to bring up the visitors profile in one of 2 forms (both forms are identical, except one states "Visitor clocked in", and the other states "Visitor clocked out"). I need to have a button on each form, which changes the "Status" from "Clocked Out" to "Clocked In" (or from "Clocked in" to "Clocked out").
I can do this at home on Office 2007 by running a macro from a command button. We run Access 2003 here at work, and I haven't managed to get my head around the macros on this version yet.
Just to clarify, I am after advice on the "buttons" which changes the visitor status.
Thanks in advance.
So... double click a name from one of the subforms to bring up the visitors profile in one of 2 forms (both forms are identical, except one states "Visitor clocked in", and the other states "Visitor clocked out"). I need to have a button on each form, which changes the "Status" from "Clocked Out" to "Clocked In" (or from "Clocked in" to "Clocked out").
I can do this at home on Office 2007 by running a macro from a command button. We run Access 2003 here at work, and I haven't managed to get my head around the macros on this version yet.
Just to clarify, I am after advice on the "buttons" which changes the visitor status.
Thanks in advance.