Setting todays date.

[Michael B]

Hi,

Can someone please help. I am using Access 97 and am considering inflicting
serious damage to my pc to allieviate my frustration...

I`m trying to create a macro that will update a field (called, DATE
COMPLETED) on a table (called, POST) when a button (called COMPLETED) is
clicked on a form (called ACTION POST ITEMS) with todays date.

I think I use the SETVALUE action but don`t know what the rest of it looks
like?

Item: ???
Expression: Date()

Can anyone help? Please don`t suggest using coding because I am a novice and
don`t even understand the basics of coding yet...


Thanks

Michael.

 

[Steve Schapel]

Michael,

The answer depends on whether the Action Post Items form is based on the
Post table, and whether the Date Completed field is represented on said
form.

If so, then you are correct, you should be able to use the SetValue
action in a macro, and the arguments would be like this...
Item: [DATE COMPLETED]
Expression: Date()

If not, then SetValue is not the way to go. Instead you would need to
use an Update Query, and an OpenQuery action in the macro to run the update.