control source in a field for a check box

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

Guest

I am trying to design a database for a daily dispatch log. I have figured
out how to log the ModifiedTime. Now I have four check boxes for:

Enrt On Scene Transporting Availible
Enrt Time On Scene Time etc...

I want to add next to them a field (I can do that) that will enter the time
the box was checked for each one. I can not figure out how to set the
control source or event procedure...HELP PLEASE....

Thanks Jennifer P
 
Jennifer said:
I am trying to design a database for a daily dispatch log. I have
figured out how to log the ModifiedTime. Now I have four check boxes
for:

Enrt On Scene Transporting Availible
Enrt Time On Scene Time etc...

I want to add next to them a field (I can do that) that will enter
the time the box was checked for each one. I can not figure out how
to set the control source or event procedure...HELP PLEASE....

Thanks Jennifer P
Click to expand...

Do you have fields bound to these CheckBoxes? If so you are storing
redundant data. You don't need a CheckBox to indicate "Yes" this event
happend as well as a DateTime to indicate "when" it happened. You will know
the event happened by virtue of a DateTime having been entered and you know
an event has not yet happened by virtue of the DateTime still being Null.

So...all you really need are four CommandButtons that will enter the
DateTime when pressed. The code would be...

Me![FieldName] = Now()

....for each button. If you insist on keeping the unnecessary CheckBoxes
just use the AfterUpdate event of each one.

If Me.CheckBoxName = True Then Me![FieldName] = Now()
 
Okay I got rid of the check boxes left a field for enroute time but I can not
get the command button to work when clicked. I entered the code below and I
get an error saying I have to have a macro. I designed a macro under
setvalue with the following info:

[Enroute]
=Time()

Then I get an invalid syntax message...I NEED HELP...

Rick Brandt said:
Jennifer said:
I am trying to design a database for a daily dispatch log. I have
figured out how to log the ModifiedTime. Now I have four check boxes
for:

Enrt On Scene Transporting Availible
Enrt Time On Scene Time etc...

I want to add next to them a field (I can do that) that will enter
the time the box was checked for each one. I can not figure out how
to set the control source or event procedure...HELP PLEASE....

Thanks Jennifer P
Click to expand...

Do you have fields bound to these CheckBoxes? If so you are storing
redundant data. You don't need a CheckBox to indicate "Yes" this event
happend as well as a DateTime to indicate "when" it happened. You will know
the event happened by virtue of a DateTime having been entered and you know
an event has not yet happened by virtue of the DateTime still being Null.

So...all you really need are four CommandButtons that will enter the
DateTime when pressed. The code would be...

Me![FieldName] = Now()

....for each button. If you insist on keeping the unnecessary CheckBoxes
just use the AfterUpdate event of each one.

If Me.CheckBoxName = True Then Me![FieldName] = Now()
Click to expand...
 
Jennifer said:
Okay I got rid of the check boxes left a field for enroute time but I
can not get the command button to work when clicked. I entered the
code below and I get an error saying I have to have a macro. I
designed a macro under setvalue with the following info:

[Enroute]
=Time()

Then I get an invalid syntax message...I NEED HELP...
Click to expand...

I can't help you with macros (never use em). For VBA code you need to go to
the OnClick event property for the button and enter "[Event Procedure]". It
will be one of the choices if you select from the drop-down list of choices
for the property.

After entering "[Event Procedure]" you press the build [...] button to the
right of the box and this will take you to the code window. Access will
have automatically created the two lines to define the start and end of the
code that will run when the button is pressed and your cursor will be
positioned in between those two lines. That is where you enter...

Me![Enroute] = Now()
 
Rick that worked miracles you are the best.....Jen

Rick Brandt said:
Jennifer said:
Okay I got rid of the check boxes left a field for enroute time but I
can not get the command button to work when clicked. I entered the
code below and I get an error saying I have to have a macro. I
designed a macro under setvalue with the following info:

[Enroute]
=Time()

Then I get an invalid syntax message...I NEED HELP...
Click to expand...

I can't help you with macros (never use em). For VBA code you need to go to
the OnClick event property for the button and enter "[Event Procedure]". It
will be one of the choices if you select from the drop-down list of choices
for the property.

After entering "[Event Procedure]" you press the build [...] button to the
right of the box and this will take you to the code window. Access will
have automatically created the two lines to define the start and end of the
code that will run when the button is pressed and your cursor will be
positioned in between those two lines. That is where you enter...

Me![Enroute] = Now()
Click to expand...
 
Back
Top