| | |
|
|
|
Import, Delete Append Macro |
|---|
| message from Dennis on 28 May 2004 |
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
|
| Steve Schapel replied to Dennis on 29 May 2004 |
Dennis,
Len(Dir("a:\bus.txt"))
|
| Dennis replied to Steve Schapel on 29 May 2004 |
Thanks,
Dennis
press
that
A:Drive
give a
would
|
|
Archived message: Import, Delete Append Macro (Microsoft Access Database)
