One Click Date Stamping

[Guest]

I have to track numerous actions through many stages. I'd like to simplify
the process with a one-click date stamping. I want to allow my users to see
where an action is and what date it arrived all on one form. I thought that
using a check box that would activate a Now date stamp in another field (for
datas queries later) would be the way to go. Unfortunately, I do not know
how to do this. Can anyone help me?

 

[Guest]

Create your check box and date field. Here, showing my vast powers of
imagination, I've called them 'checkbox' and 'datefield'. Create an event
procedure (click on the ...) in the properties of the checkbox next to 'after
update'.

Include the following, but change the field names to suit. And voila....!

Private Sub CheckBox_AfterUpdate()
Me!DateField = Now

End Sub
--

 

[Guest]

Sorry, but I need this as well, just not experienced enough to really
understand. I have my feilds created already ("completed" is your
"checkbox". "date completed" is your "datefeild". I'm having trouble with
how to create (add) an event procedure. Where do I do that?

Thanks - Bill

 

[George Nicholson]

I'm having trouble with

how to create (add) an event procedure. Where do I do that?

Here's a blow-by-blow:
-In design view of the the form, select your control
-View>Properties
-On the Event tab of the Properties dialog for the control, select "After
Update"
-Select [Event Procedure] from the property's combo box
-Now, click the elipse (the "...") to the right of the combo box arrow.
You'll be taken to the "shell" of an event procedure in the VB editor where
you can fill in the remaining code

HTH,

 

[Guest]

OK, all I'm using are queries in the database view. Does that cause a problem?

I'm using this as a spreadsheet to track maintenance. A check box if a work
order is written (then I can query "written"), a check box if it's complete
(then I can query "completed"), etc. When I check "complete" I want to time
stamp it with the date in the next column...

THANKS for helping the rookie, LOL!

I'm having trouble with
how to create (add) an event procedure. Where do I do that?

Here's a blow-by-blow:
-In design view of the the form, select your control
-View>Properties
-On the Event tab of the Properties dialog for the control, select "After
Update"
-Select [Event Procedure] from the property's combo box
-Now, click the elipse (the "...") to the right of the combo box arrow.
You'll be taken to the "shell" of an event procedure in the VB editor where
you can fill in the remaining code

HTH,
--
George Nicholson

Remove 'Junk' from return address.

Sorry, but I need this as well, just not experienced enough to really
understand. I have my feilds created already ("completed" is your
"checkbox". "date completed" is your "datefeild". I'm having trouble
with
how to create (add) an event procedure. Where do I do that?

Thanks - Bill

 

[George Nicholson]

Queries and tables do not have event procedures. Forms do. (So do Reports,
but those are generally different kind of events and aren't
user-interactive, which is what you want).

If you want to use an event procedure, create a form based on your query.

HTH,
--
George Nicholson

Remove 'Junk' from return address.

OK, all I'm using are queries in the database view. Does that cause a
problem?

I'm using this as a spreadsheet to track maintenance. A check box if a
work
order is written (then I can query "written"), a check box if it's
complete
(then I can query "completed"), etc. When I check "complete" I want to
time
stamp it with the date in the next column...

THANKS for helping the rookie, LOL!

I'm having trouble with
how to create (add) an event procedure. Where do I do that?

Here's a blow-by-blow:
-In design view of the the form, select your control
-View>Properties
-On the Event tab of the Properties dialog for the control, select "After
Update"
-Select [Event Procedure] from the property's combo box
-Now, click the elipse (the "...") to the right of the combo box arrow.
You'll be taken to the "shell" of an event procedure in the VB editor
where
you can fill in the remaining code

HTH,
--
George Nicholson

Remove 'Junk' from return address.

Sorry, but I need this as well, just not experienced enough to really
understand. I have my feilds created already ("completed" is your
"checkbox". "date completed" is your "datefeild". I'm having trouble
with
how to create (add) an event procedure. Where do I do that?

Thanks - Bill

:

Create your check box and date field. Here, showing my vast powers of
imagination, I've called them 'checkbox' and 'datefield'. Create an
event
procedure (click on the ...) in the properties of the checkbox next to
'after
update'.

Include the following, but change the field names to suit. And
voila....!

Private Sub CheckBox_AfterUpdate()
Me!DateField = Now

End Sub
--