Good morning all!
I'm having a problem with a macro. I want to macro to run a line if a condition is true. That condition is to make sure a table has records in it (basically if the table exists). The table is called CensusRpt and below is the condition I'm using:
DCount("*","CensusRpt")=0
if this is true then I want my database to quit (macroaction=QUIT)....if it's not true (there are records in the table) then I want my macro to continue.
The problem is no matter what it doesn't seem to do anything...doesn't quit and doesn't run subsequent lines, even though there are 800 records in that table. If I remove the condition then it works just fine.
thanks for taking the time to read this.
I'm having a problem with a macro. I want to macro to run a line if a condition is true. That condition is to make sure a table has records in it (basically if the table exists). The table is called CensusRpt and below is the condition I'm using:
DCount("*","CensusRpt")=0
if this is true then I want my database to quit (macroaction=QUIT)....if it's not true (there are records in the table) then I want my macro to continue.
The problem is no matter what it doesn't seem to do anything...doesn't quit and doesn't run subsequent lines, even though there are 800 records in that table. If I remove the condition then it works just fine.
thanks for taking the time to read this.