Access 2007 Macro Conditions

D

David Weiss

I am trying to set up a macro in Access 2007 to look at a table "UPDATE"; if
field "Date" equals today and field "Update Status" equals "Yes" the macro
should run the action RunSavedImportExport. It seems that the conditions will
only apply to a form or report. I am looking for any help or suggestions.

Thank you.
 
S

Steve Schapel

David,

"look at a table" doesn't really make sense, unless you specify which record
in the table.

If you mean to go ahead with the macro if *any* records in the table meet
your criteria, then enter the macro Condition like this:
DCount("*","UPDATE","[Date]=Date() And [Update Status]='Yes'")>0

By the way, as an aside, 'date' is a Reserved Word (i.e. has a special
meaning) in Access, and should not be used as the name of a field or
control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access 2007 macro not working in access 2010/2013/2016 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Setting Conditions in Macros in Access 2003 4
Access 2007 Macro Condition 1
Conditions Not Working 3
Type Mismatch in Macro with empty string/null value 7
RunSavedImportExport 3
Echo On = No crashing macro in Access 2007 5

Top