If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Want current time to be entered w/double click
I am trying to create a time and attendance form. The form itself has the
employees demographic information and the subform is where their entry records will be. I do not want the employees to have to physically enter the actual time I want the time to be entered in the field when they select it. ie: when the employee has to enter their beginning lunch time they just double click in the field and the current time will be generated. I was able to set the default value of the date to Now() to keep the date current but I need to do the same for the time wih out all fields generating the exact some time. HELP!!!! |
#2
|
|||
|
|||
On Tue, 24 May 2005 20:18:01 -0700, hiteckchick21 wrote:
I am trying to create a time and attendance form. The form itself has the employees demographic information and the subform is where their entry records will be. I do not want the employees to have to physically enter the actual time I want the time to be entered in the field when they select it. ie: when the employee has to enter their beginning lunch time they just double click in the field and the current time will be generated. I was able to set the default value of the date to Now() to keep the date current but I need to do the same for the time wih out all fields generating the exact some time. HELP!!!! Set the control's Format property to a valid Time format. Code the control's Double-Click event: Me![NameOfControl] = Time -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#3
|
|||
|
|||
Am I entering the Me![NameOfControl] = Time as the defualt value or the
validation rule in the design view of the table? Or do I need to figure out the "name of control" in order to make this work? "fredg" wrote: On Tue, 24 May 2005 20:18:01 -0700, hiteckchick21 wrote: I am trying to create a time and attendance form. The form itself has the employees demographic information and the subform is where their entry records will be. I do not want the employees to have to physically enter the actual time I want the time to be entered in the field when they select it. ie: when the employee has to enter their beginning lunch time they just double click in the field and the current time will be generated. I was able to set the default value of the date to Now() to keep the date current but I need to do the same for the time wih out all fields generating the exact some time. HELP!!!! Set the control's Format property to a valid Time format. Code the control's Double-Click event: Me![NameOfControl] = Time -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
#4
|
|||
|
|||
On Wed, 25 May 2005 00:46:03 -0700, hiteckchick21 wrote:
Am I entering the Me![NameOfControl] = Time as the defualt value or the validation rule in the design view of the table? Or do I need to figure out the "name of control" in order to make this work? "fredg" wrote: On Tue, 24 May 2005 20:18:01 -0700, hiteckchick21 wrote: I am trying to create a time and attendance form. The form itself has the employees demographic information and the subform is where their entry records will be. I do not want the employees to have to physically enter the actual time I want the time to be entered in the field when they select it. ie: when the employee has to enter their beginning lunch time they just double click in the field and the current time will be generated. I was able to set the default value of the date to Now() to keep the date current but I need to do the same for the time wih out all fields generating the exact some time. HELP!!!! Set the control's Format property to a valid Time format. Code the control's Double-Click event: Me![NameOfControl] = Time -- Fred Please only reply to this newsgroup. I do not reply to personal email. Neither. And NOT in the table. A Table should not be used for data entry. Table fields do not have double-click events ( or any user available events). Forms do. This is done on the Time and Attendance form you want to use for data entry. And Yes... you do need to figure out the name of the control on the form. What is the actual name of the control on the form? Let's say it's name is "BeginLunchTime" and it is bound to a field in your table. Select this control. Show it's property sheet. Click on the Event tab. On the line that says Dbl-click write: [Event Procedure] Then click on the little button with 3 dots that appears on that line. When the code window opens, the cursor will be flashing between 2 already existing lines of code. Between those lines, write: Me![BeginLunchTime] = Time Exit the code window. Open the form. Double-click on this control and the current time will be entered in it. Remember to change [BeginLunchTime] to whatever the actual name of this control is on your form. -- Fred Please only reply to this newsgroup. I do not reply to personal email. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
on dbl click.... "enter current time in shortTime format" | MarcTA | Using Forms | 1 | April 28th, 2005 05:28 PM |
Prevent overlapping times | Duncan Edment | Running & Setting Up Queries | 3 | April 27th, 2005 11:13 PM |
Seemingly (and probably) complex turnaround time | rgrantz | Running & Setting Up Queries | 1 | March 21st, 2005 09:19 AM |
Importing Contacts from Work to Home Computer in Outlook | Debbie | Contacts | 3 | March 16th, 2005 09:14 PM |
GPO Office 2003 | Tony | Setup, Installing & Configuration | 1 | May 12th, 2004 10:42 AM |