docmd.transfertext acExportFixed



At the end of processing I export out a fixed length record using a query.
There are nine different queries that I run.
Sometimes the text file is created and sometimes not. It appears the problem
is that one query isn't finished before the next one starts. I have tried
putting a for loop with a count to slow things down but that also is hit or

Below is the code that I am using.
What I can do to make the program slow down enough to let each query run and
successfully export the text file?

Thanks in advance for any help.
DoCmd.TransferText acExportFixed, "Max&ErmasDownload", _
"qryDownload4", "J:\Max&Ermas\Weekly\MaxErma4.txt"

DoCmd.TransferText acExportFixed, "Max&ErmasDownload", _
"qryDownload5", "J:\Max&Ermas\Weekly\MaxErma5.txt"


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