Time Stamp

[dinellest via AccessMonster.com]

HI

I NEED TO CREATE A TIMESTAMP.

HERE IS THE SCENARIO. WHEN WE RECEIVE A CALL I NEED THE USER TO SELECT FIELD
T0 (TIME CALL RECIEVED) AND HIT TIME STAMP. THEN ONCE THEY ARE DONE THEY
WOULD SEND THE CALL TO THE DISPATCHER AND HIT TIME STAMP THIS IS CALLED T1.
THEN WHEN THE DRIVER IS NOTIFIED THE DISPATCHER PLACES THE CURSER IN THE NEXT
FIELD AND HITS TIME STAMP THIS IS CALLED T3 AND SO ON....

IN ESSENCE I AM CREATING A COPY OF A PAPER FORM WHICH THE STAFF CURRENTLY USE.
WHEN THEY ENTER THE INFORMATION THEY TAKE THE PAPER AND PLACE IT IN A TIME
STAMP MACHINE WHICH THEY LINE UP THE FIELDS WITH THE ACTION AND VOILA.

AN EXAMPLE WOULD BE

ACTION TIME
T0_TIME ZERO 2008-JAN-01 12:06:59 AM
T1_CALLRECEIVED 2008-JAN-01 12:07:42 AM

DATE/TIME FORMAT 2008-JAN-01 12:06:59 AM

HERE ARE MY FIELDS

T0_TIME ZERO DATE/TIME
T1_CALLRECEIVED DATE/TIME
T2_NOTIFIED DATE/TIME
T2_BASEPAGED DATE/TIME
T3_ENROUTE DATE/TIME
T4_ARRIVEDSCENE DATE/TIME

Thanks

Stephen

 

[Al Campagna]

dinellest,
Please don't type in all caps. In newsgroups, it's considered to be
"shouting", and makes the text difficult to read.
Also, try to avoid spaces in your field names.
Ex. T0TimeZero... etc

I'm not sure what you mean when you refer to "hit Time Stamp" Are you
using some sort of Date/Time Picker, or just a button that generates the
current Date and Time?

A simpler method would be to use the control's Double Click event to set
the current Date and Time for that control.

Private Sub T0TimeZero_DblClick(Cancel As Integer)
T0TimeZero = Now
End Sub

Private Sub T1CallReceived _DblClick(Cancel As Integer)
T1CallReceived = Now
End Sub

etc...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[dinellest via AccessMonster.com]

Hi Al

Sorry about the Cap thing I actually wrote it up in word and copies/pasted it.


I would like to use a button that generates the current date and time.

Thanks again

Stephen

dinellest,
Please don't type in all caps. In newsgroups, it's considered to be
"shouting", and makes the text difficult to read.
Also, try to avoid spaces in your field names.
Ex. T0TimeZero... etc

I'm not sure what you mean when you refer to "hit Time Stamp" Are you
using some sort of Date/Time Picker, or just a button that generates the
current Date and Time?

A simpler method would be to use the control's Double Click event to set
the current Date and Time for that control.

Private Sub T0TimeZero_DblClick(Cancel As Integer)
T0TimeZero = Now
End Sub

Private Sub T1CallReceived _DblClick(Cancel As Integer)
T1CallReceived = Now
End Sub

etc...

HI

[quoted text clipped - 34 lines]

Stephen

 

[Keith Wilby]

Hi Al

Sorry about the Cap thing I actually wrote it up in word and copies/pasted
it.


I would like to use a button that generates the current date and time.

Use the Now() function.

In the button's Click event:

MsgBox Now()

will return the system date and time in a message box.

Keith.
www.keithwilby.com

 

[dinellest via AccessMonster.com]

Thanks Keith but I need it to populate a specific field not the button.

Focus on T0_TIME ZERO DATE/TIME Hit Time Stamp
Focus On T1_CALLRECEIVED DATE/TIME Hit Time Stamp
Focus on T2_NOTIFIED DATE/TIME Hit Time Stamp

Appreciate all the help.

Stephen

 

[Keith Wilby]

Thanks Keith but I need it to populate a specific field not the button.

OK assuming you have a text box named "txtTimeStamp" bound to a field named
"TimeStamp":

Me.txtTimeStamp = Now()

Personally I would put the code in the form's Before Update event and set
txtTimeStamp's Allow Edits property to False so that you're not reliant upon
the user to record (and not change) the data.

Keith.
www.keithwilby.com