Import, Delete Append Macro

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

I have a database where I import, delete and append
records into a table. It seems to work except when I press
the button that activates the macro and the import disk is
not in the A:Drive. I then delete all of the records that
I have been working my life away on.

What I would like to do is have access look at the A:Drive
first to see if the import file (Bus.txt) is there and
then, only if the file is there, perform the duties it
should. How can I do that? And if it is code please give a
sample to look at a file in the A: Drive and where I would
put it in relation to the macro?

Thanks,

Dennis
 
Dennis,

Put this in the Condition column of your macro design...
Len(Dir("a:\bus.txt"))
 
Back
Top