Macro Conditions

[Emma Hope]

Hi All,

I hope you can help me. I am importing several hundred text files into my
database, each text file has it's header row in row 3, so when my import spec
runs, it creates an import error table for each file, where the field is a
date/numeric etc.

I want to be able to use a macro to delete all these import error tables
HOWEVER some text files have true import errors in them and i want to be able
to see these.

So i want to do something like this in my macro:

Condition Action
[Row]=3 DeleteObject

but it doesn't seem to work. Can anyone help me with this one, i'm looking
to see if the ONLY row refered to in an Import Errors table is 3 then the
import error table can be deleted.

I'd like to avoid using forms or VBA if at all possible & stick with macros.

Thanks for your help.
Emma

 

[Steve Schapel]

Emma,

Your Condition needs to be like this:

DCount("*","Import Errors","[Row]<>3")=0