Current Time Date Stamp

  • Thread starter Thread starter MarthaR
  • Start date Start date
M

MarthaR

I am trying to add the current time to a field when the
user clicks on the toggle button next to the field. I am
getting a time of 12:00:00 AM each time I click the
button. How do I get a return of the current time? I am
using the function =Time$() as the default.
 
Toggle button or command button? Either way put the
following in the OnClick Event code of the button as the
default value is only in effect when you first create the
record...

Me!YourDateFieldName = Time

Change my name to your field name.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
I am getting an error 424 missing object? Any ideas?

I entered the field in as:

Form_FRM: Data_Entry!Time_Out = Time

Suggestions?
 
It would be very helpful if you supplied some more details
of exactly what you are doing.

This syntax "Form_FRM: Data_Entry!Time_Out = Time" wouldn't
work anywhere I know and doesn't really correspond to my
suggestion. Are you familiar with VBA code at all or do you
know how to get to a code window behind your button? We need
to get you into the code module behind your button and if
you don't know how we can coach you. It is very difficult to
ascertain someone's skill level until they give us a little
clue. Three requests from you.

Skill level synopsis...

Where did you put your "Form_FRM: Data_Entry!Time_Out =
Time" line?

Did you try what I suggested or were you confused by the
suggestion? Confused is A-OK. Just let me know so I know to
go in more detail.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
In the property box of your command button for Time Out go
to the events section and click in the line for the OnClick
Event. You will get a little builder box on the right hand
side. Click on that and then choose Code from the next
dialog box. In the code window type the following and you
should be done...

Me![Time Out] = Time

I am kind of surprised that your default value of 'Time$()'
is working as I can find no documentation of Time with the $
attached.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Thank you Gary. It worked like a charm!
-----Original Message-----
In the property box of your command button for Time Out go
to the events section and click in the line for the OnClick
Event. You will get a little builder box on the right hand
side. Click on that and then choose Code from the next
dialog box. In the code window type the following and you
should be done...

Me![Time Out] = Time

I am kind of surprised that your default value of 'Time$()'
is working as I can find no documentation of Time with the $
attached.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
I haven't work much in VBA. Just some very simple
procedures. I have worked in Access for five years and I
know my way around tables, forms, queries, reports and
simple macros. I did not understand your previous
instructions.

Here is what I am trying to do. I have a simple Access
database that is capturing the time spent on creating
drawings in AutoCAD. My fields are: Date, Project, User,
Time In, Time Out, Total Time, Document Name. I have
=Time$() as the default for Time In. I am now looking for
a process that will allow the user to automatically enter
the time in Time Out by clicking a button when they are
finished witht he drawing. The name of the form is
FRM:Data Entry.

Any suggestions?

difficult
to know
to create
the wrote
in when
the
Click to expand...
field.
I time? I
am
Click to expand...


.
Click to expand...
 
Super!

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
Thank you Gary. It worked like a charm!
-----Original Message-----
In the property box of your command button for Time Out go
to the events section and click in the line for the OnClick
Event. You will get a little builder box on the right hand
side. Click on that and then choose Code from the next
dialog box. In the code window type the following and you
should be done...

Me![Time Out] = Time

I am kind of surprised that your default value of 'Time$()'
is working as I can find no documentation of Time with the $
attached.
--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
I haven't work much in VBA. Just some very simple
procedures. I have worked in Access for five years and I
know my way around tables, forms, queries, reports and
simple macros. I did not understand your previous
instructions.

Here is what I am trying to do. I have a simple Access
database that is capturing the time spent on creating
drawings in AutoCAD. My fields are: Date, Project, User,
Time In, Time Out, Total Time, Document Name. I have
=Time$() as the default for Time In. I am now looking for
a process that will allow the user to automatically enter
the time in Time Out by clicking a button when they are
finished witht he drawing. The name of the form is
FRM:Data Entry.

Any suggestions?


-----Original Message-----
It would be very helpful if you supplied some more details
of exactly what you are doing.

This syntax "Form_FRM: Data_Entry!Time_Out = Time"
wouldn't
work anywhere I know and doesn't really correspond to my
suggestion. Are you familiar with VBA code at all or do
you
know how to get to a code window behind your button? We
need
to get you into the code module behind your button and if
you don't know how we can coach you. It is very difficult
to
ascertain someone's skill level until they give us a
little
clue. Three requests from you.

Skill level synopsis...

Where did you put your "Form_FRM: Data_Entry!Time_Out =
Time" line?

Did you try what I suggested or were you confused by the
suggestion? Confused is A-OK. Just let me know so I know
to
go in more detail.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
I am getting an error 424 missing object? Any ideas?

I entered the field in as:

Form_FRM: Data_Entry!Time_Out = Time

Suggestions?

-----Original Message-----
Toggle button or command button? Either way put the
following in the OnClick Event code of the button as
the
default value is only in effect when you first create
the
record...

Me!YourDateFieldName = Time

Change my name to your field name.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
in
message [email protected]...
I am trying to add the current time to a field when
the
user clicks on the toggle button next to the
Click to expand...
field.
I
am
getting a time of 12:00:00 AM each time I click the
button. How do I get a return of the current time? I
am
using the function =Time$() as the default.


.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top