471,082 Members | 884 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,082 software developers and data experts.

AutoExec Macro Help

I have 2 AutoExec macro's that run at a specified time every morning (1am) but 1 of those macros can't be run more then 1 time a day. I found a set up on a previous post that almost solves my problem, but the StopMacro condition gives me a syntax error.
Here's what i have so far...
A table named "tblLastUpdate" with a field "DateUpdated"
A query in the macro which will append that table with the date it runs on. (should this be an append or an update query?)

The Macro condition i found is

but it gives me a missing operator syntax error any help would be wonderful
Jan 13 '11 #1
4 1876
2,322 Expert Mod 2GB

I think you should be able to do simply:
The last solution is neater and faster, and should work, though I havent done much work in macros.
Jan 14 '11 #2
I don't get an error message with those condition syntax but it doesn't stop the macro from running even when the condition is met. Baffled....
Jan 14 '11 #3
2,322 Expert Mod 2GB
And you have tested that the expression
evaluates as you expect it to?

Ie. that it is false when you have data for that date in the table.
Jan 14 '11 #4
Changed it to make it a true statement and it works :) Thanks so much for your help
Jan 14 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by MLH | last post: by
6 posts views Thread by Takeadoe | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.