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.

Steve Schapel


Your Condition needs to be like this:

DCount("*","Import Errors","[Row]<>3")=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