in macro how to determine a table is empty or number of records=0

C

choigary

The DeleteRecord command returns an error if there is on record in the
underlying table. Therefore I would like to include a condition to stop the
macro.
 
K

Ken Snell \(MVP\)

DCount("*","TableName")>0

Above expression will be true if the table has at least one record. Use this
in a Condition to run the DeleteRecord action.
 
C

choigary

Thanks a lot. Much appreciated for your help.


Ken Snell (MVP) said:
DCount("*","TableName")>0

Above expression will be true if the table has at least one record. Use this
in a Condition to run the DeleteRecord action.
Click to expand...
 
Top