Macro Conditions

  • Thread starter Thread starter Emma Hope
  • Start date Start date
E

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
 
Emma,

Your Condition needs to be like this:

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