One Button Export of Query to Fixed Length Text File

[gbs01]

I have my qrySwitchDataExportToText ready to go. I can run the query, then choose File/Export/TextFile/ExportAll/ and choose my export spec called QrySwithDataExportToText and I get my text file sent to my desktop. This works great! , But I'm not having any luck adding it to my form buttons OnClick event.

Here's what I've got :
----------------------
DoCmd.TransferText acExportFixed, "QrySwitchDataExportToText Export Specification", qrySwitchDataExportToText, "C:\Test.txt"' False, ""

Thanks in advance for your help!
jalexander

 

[VBslammer]

Probably a typo, but there's an apostrophe where a comma should be:

[tt]DoCmd.TransferText acExportFixed, "QrySwitchDataExportToText Export Specification", qrySwitchDataExportToText, "C:\Test.txt"[highlight],[/highlight] False[/tt]


VBSlammer

"You just have to know which screws to turn." - Professor Bob