Condition for No Data

J

Jani

I have a macro which appends a temp table to a SQL table and then deletes
data in the temp table but only if the Close field is a 'Y.' Sometimes there
is no 'Y' in the Close field in the temp table. How do I write a condition so
that a message pops up stating that no records were appended? Thanks! Jani
 
S

Steve Schapel

Jani,

Try like this for your Condition for a MsgBox action:

DCount("*","NameOfTempTable","[Close]='Y'")=0
 

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

DCount 2
ISAM Delete data from Excel file 2
How do I stop a condition in a macro in an Access database? 1
running a macro past a condition 8
DLookup Two Fields 5
Macro conditions to open a query 2
Append query works in DB view not in macro 2
VBA - retrieve data on last create named range from previous inserted named range 0

Top