Open query but not display

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

sing the following to export a txt file - how can i stop the query from
displaying on the screen?

DoCmd.OpenQuery "qMissItem", acNormal, acReadOnly
DoCmd.TransferText acExportDelim, "", "QLtrMissItem", "C:\Data\Test.txt",
False, ""
 
Junior said:
sing the following to export a txt file - how can i stop the query from
displaying on the screen?

DoCmd.OpenQuery "qMissItem", acNormal, acReadOnly
DoCmd.TransferText acExportDelim, "", "QLtrMissItem", "C:\Data\Test.txt",
False, ""
Click to expand...

Don't open the query.

It's not clear what you want to happen here. Why do you
first open one query, then export a different table or
query?
 
sorry Marshall - i misstyped the code - it is the same qry
Solved the problem using an export specification
 
Back
Top