A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Want current time to be entered w/double click



 
 
Thread Tools Display Modes
  #1  
Old May 25th, 2005, 04:18 AM
hiteckchick21
external usenet poster
 
Posts: n/a
Default 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  
Old May 25th, 2005, 04:56 AM
fredg
external usenet poster
 
Posts: n/a
Default

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  
Old May 25th, 2005, 08:46 AM
hiteckchick21
external usenet poster
 
Posts: n/a
Default

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  
Old May 25th, 2005, 04:40 PM
fredg
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 10:19 AM
Importing Contacts from Work to Home Computer in Outlook Debbie Contacts 3 March 16th, 2005 10:14 PM
GPO Office 2003 Tony Setup, Installing & Configuration 1 May 12th, 2004 10:42 AM


All times are GMT +1. The time now is 03:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.