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

27
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
DCount("*",tblLastUpdate","[DateUpdated]#="&Date()&"#")=0

but it gives me a missing operator syntax error any help would be wonderful
Jan 13 '11 #1
4 1876
TheSmileyCoder
2,322 Expert Mod 2GB
Try
DCount("*",tblLastUpdate","[DateUpdated]=#"&Date()&"#")=0

I think you should be able to do simply:
DCount("*",tblLastUpdate","[DateUpdated]=Date()")=0
The last solution is neater and faster, and should work, though I havent done much work in macros.
Jan 14 '11 #2
kini113
27
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
TheSmileyCoder
2,322 Expert Mod 2GB
And you have tested that the expression
DCount("*",tblLastUpdate","[DateUpdated]=Date()")=0
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
kini113
27
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.