GLese
Registered User.
- Local time
- Today, 11:13
- Joined
- Feb 13, 2018
- Messages
- 52
In order to make a timestamp in several of my tables, I have built a macro based on a post on the Microsoft office support page "Store the Date and time when a record is modified"
My Macro is:
SetValue
Item = [DateTimeIn]
Expression = Now()
CloseWindow
Object Type
Object Name
Save = No
This was working fine, but all of a sudden I'm getting an error in the macro window when I try to build a similar expression for a different field (Need the same macro for [DateTimePickup]).
The error I get is "The 'SetValue' macro action has an invalid value for the 'Expression' argument."
There is a little error icon next to the Expression box in the Macro screen and when I hover over it the text box says "Microsoft Access can't parse the expression: 'Now()'."
I feel a bit stuck since I had written the macro earlier for [DateTimeOut] and had no issues until I tried making a third variant.
My Macro is:
SetValue
Item = [DateTimeIn]
Expression = Now()
CloseWindow
Object Type
Object Name
Save = No
This was working fine, but all of a sudden I'm getting an error in the macro window when I try to build a similar expression for a different field (Need the same macro for [DateTimePickup]).
The error I get is "The 'SetValue' macro action has an invalid value for the 'Expression' argument."
There is a little error icon next to the Expression box in the Macro screen and when I hover over it the text box says "Microsoft Access can't parse the expression: 'Now()'."
I feel a bit stuck since I had written the macro earlier for [DateTimeOut] and had no issues until I tried making a third variant.