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
'------------------------------------------------------------
' 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