damselfish
New member
- Local time
- Today, 17:35
- Joined
- Oct 29, 2024
- Messages
- 8
I run an online business, and I have a form from which I export selected items into a csv file to upload in my listing software.
The form works fine, the export is created, but I cannot find the export spec for it anywhere. I am looking for the export that is being run by this line of code:
DoCmd.RunSavedImportExport "Export-MyExport". (actual name of the export replaced by MyExport throughout this post)
Here's the whole sub that this line is found in:
Private Sub bExportMy_Click()
DoCmd.RunSQL "delete * from tblTempMyExport"
DoCmd.OpenQuery "CopyOfAdd_qryExportMyInfo"
Dim FileName As String
FileName = CurrentProject.path & "\MyExport.csv"
DoCmd.RunSavedImportExport "Export-MyExport"
MsgBox "File saved!", vbInformation
End Sub
I have checked two ways:
1) directly in MSysIMEXSpecs
2) the sort of back-door way where you start an export, click Advanced and then Specs to get the list of fields in the spec.
There is no spec called MyExport. I can't figure out what I'm missing here.
All help appreciated!
The form works fine, the export is created, but I cannot find the export spec for it anywhere. I am looking for the export that is being run by this line of code:
DoCmd.RunSavedImportExport "Export-MyExport". (actual name of the export replaced by MyExport throughout this post)
Here's the whole sub that this line is found in:
Private Sub bExportMy_Click()
DoCmd.RunSQL "delete * from tblTempMyExport"
DoCmd.OpenQuery "CopyOfAdd_qryExportMyInfo"
Dim FileName As String
FileName = CurrentProject.path & "\MyExport.csv"
DoCmd.RunSavedImportExport "Export-MyExport"
MsgBox "File saved!", vbInformation
End Sub
I have checked two ways:
1) directly in MSysIMEXSpecs
2) the sort of back-door way where you start an export, click Advanced and then Specs to get the list of fields in the spec.
There is no spec called MyExport. I can't figure out what I'm missing here.
All help appreciated!