Im creating a maco in Access that executes a batch file which executes a script that generates several txt files that are then imported into the database by the next action in the macro. How can I pause between the creation of the txt files and the transfer of said files for a minute so that the txt files will actually be there when the next part of the macro tries to import them?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to make macros pause between actions 1
- Thread starter HalfBased
- Start date
-
1
- #2
If you are trying to do this in VBA then try forum705. This forum is specifically for VB5 and 6. Otherwise use the 'Find a Forum' search link at the top of the page to choose the most appropriate of the (many) Access forums.
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Status
Similar threads
- Locked
- Question
