Help with Time Stamp fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am looking to set up two fields on my form under Time Spent. The two
fields are "Start" and "Finish". I want to put a command button on the bottom
of each of these so when the user clicks it, it populates the current time.
However, I do not want the user to be able to manual change the time in the
field.

Question one: Once I set up the fileds and command buttons, what will be the
code to make the current time populate in the field and where do I place the
code?

Question Two: How do I make the two fields so the user cannot at any time
manual change the time that populates?

I realize that can change it by continuing to click the button but I don't
want them to be able to free form the time.

Any help would be greatly appreciated!! Also, please simplify as I am at a
novice level.

Thanks much!!!
 
Doug_C said:
Hello,

I am looking to set up two fields on my form under Time Spent. The two
fields are "Start" and "Finish". I want to put a command button on
the bottom of each of these so when the user clicks it, it populates
the current time. However, I do not want the user to be able to
manual change the time in the field.

Question one: Once I set up the fileds and command buttons, what will
be the code to make the current time populate in the field and where
do I place the code?
Click to expand...

Me!TextBoxName = Now()

would be the code in the Click event of both buttons. The only difference
would be the name of the TextBox used in each statement.
Question Two: How do I make the two fields so the user cannot at any
time manual change the time that populates?
Click to expand...

Set the Locked Property of the TextBoxes to Yes.
 
I think that I am trying to do what is in Question one but I don't really
understand it. Can you please break it down and explain it to me? I'm just
and Access beginner.
 
It sounds like you may want to simply set the DefaultValue property of the
field to =Now(). This will cause the current date and time to fill in the
instant a new record is started.
 
What I'm attempting to do (which may not work) is to have one field and 2
buttons on a form. The field is to enter someones name and one button is
"time in" and the other "time out". I'm trying to get the time in/time out
to go into a table that I have set up. I'm afraid I am making this to
difficult for my brain.
 
What I'm attempting to do (which may not work) is to have one field and 2
buttons on a form. The field is to enter someones name and one button is
"time in" and the other "time out". I'm trying to get the time in/time out
to go into a table that I have set up. I'm afraid I am making this to
difficult for my brain.
Click to expand...

For entering the name I'd certainly use a Combo Box control (so the user can
select their name from a list rather than having to type it all out).

The command button should be very simple. Let's say you have a textbox on the
form named txtTimeIn bound to the time in field, and a command button named
cmdTimeIn. View the Properties of the form; select cmdTimeIn; find the "Click"
event on the Events tab, and click the ... icon by it. Choose "Code Builder".
Access will give you the Sub and End Sub lines - just edit in one more:

Private Sub cmdTimeIn_Click()
Me!txtTimeIn = Now
End Sub

Do the same for time out.
 
Thanks for your help but I can't seem to get it to work. I have everything
set up but when I click the command button nothing happens. Am I suppose to
replace the Me in the

Private Sub cmdTimeIn_Click()
Me!txtTimeIn = Now
End Sub

I have tried everything I can think of.
Joy
 
Thanks for your help but I can't seem to get it to work. I have everything
set up but when I click the command button nothing happens. Am I suppose to
replace the Me in the

Private Sub cmdTimeIn_Click()
Me!txtTimeIn = Now
End Sub

I have tried everything I can think of.
Click to expand...

Me! should be correct; it just means "this current form".

Is there in fact a Textbox control on the same form as the command button,
named txtTimeIn? Is it bound to the time in field in the Form's Recordsource
query?
 
Back
Top