Putting in the date after field is input

m40wen

New member
Local time
Today, 08:07
Joined
Jan 23, 2006
Messages
9
Sorry guys, I thought this would be simpler than it was!

Basically I just want to update my "Resolution date" field with the date or time now (which I know how to do) but AFTER I input data in my "Resolution" field ie I want a field to automatically record what time I am entering the text in my "Resolution" field?

How do I do this, and can I do it without writing a macro? I thought it was along the lines of After Update, but now I am confused!

Thanks again - I am learning just slowly!
 
in the event properties of the fields that you update, goto the afterupdate properties, and then you would need to write a small amount of code.

Basically you would need to say

Me.datefield = Date
Me.timefield = Time

hope this helps
 
Hi mate,

Thanks for the response but I still dont really understand. Is there not a simple way of on the afterupdate property of the "Resolution" field to go to the "Resolution Date" field and put in "=Now()"? Is the code necessary - not being funny just trying to see how Access works.

Any pointers are gratefully received!

Regards

Mike
 
Ok, I was trying to put the following in my "Resolution" field to update the "Date resolved" field in Afterupdate

Select issuefrm.date resolved = Now()

But this doesnt work. Am I missing something?
 
in the afterupdate for Resolution, click the ... and choose code builder. In the code builder insert this:

[date resolved]=now()

i believe that will get you where you want
 
jarheadjim said:
in the afterupdate for Resolution, click the ... and choose code builder. In the code builder insert this:

[date resolved]=now()

i believe that will get you where you want


Thank you so much!

I fudged it and it was as easy as this:-


Private Sub Resolution_AfterUpdate()

Me.Date_Resolved = Now()

Me.Time_resolved = Now()

End Sub

And then changed the fields to medium time and date as appropriate.
 

Users who are viewing this thread

Back
Top Bottom