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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use a single query result in DoCmd.TransferText

Status
Not open for further replies.

MrHeynow

Technical User
Jan 17, 2009
47
US
How do I use a single query result like “FS_20090122_121139.TXT” in lieu of "TRLR.TXT " for the file name when exporting another query?


'------------------------------------------------------------
' ExportTrlr1
'
'------------------------------------------------------------
Function ExportTrlr1()
On Error GoTo ExportTrlr1_Err

DoCmd.TransferText acExportDelim, "TrlrOut Export Specification", "TrlrOut", "\\XXXXXevo\D\Shared Team\Collections\" & "TRLR.TXT ", False, """"


ExportTrlr1_Exit:
Exit Function

ExportTrlr1_Err:
MsgBox Error$
Resume ExportTrlr1_Exit

End Function

 
Have a look at the DLookUp function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top