Open query but not display

[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, ""

 

[Marshall Barton]

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, ""

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?

 

[Junior]

sorry Marshall - i misstyped the code - it is the same qry
Solved the problem using an export specification