P
PaulP
I'm using Access 2007 with Windows XP. When I specify the Export Spec within
the code I get an error "The text file spec 'Create-Pallet-Labels' does not
exist." I can run the code without the spec. I see the spec in the list of
saved exports.
Do I need some type of qualification so that the spec can be found within
the form?
The code is assigned to a button on a form.
Code:
Private Sub Pallet_Label_Button_Click()
On Error GoTo Err_Pallet_Label_Button_Click
DoCmd.TransferText acExportDelim, "Create-Pallet-Labels",
"Pallet-Label-Extract", _
"C:\Pallet-Labels.CSV", False
Exit_Pallet_Label_Button_Click:
Exit Sub
Err_Pallet_Label_Button_Click:
MsgBox Err.Description
Resume Exit_Pallet_Label_Button_Click
End Sub
the code I get an error "The text file spec 'Create-Pallet-Labels' does not
exist." I can run the code without the spec. I see the spec in the list of
saved exports.
Do I need some type of qualification so that the spec can be found within
the form?
The code is assigned to a button on a form.
Code:
Private Sub Pallet_Label_Button_Click()
On Error GoTo Err_Pallet_Label_Button_Click
DoCmd.TransferText acExportDelim, "Create-Pallet-Labels",
"Pallet-Label-Extract", _
"C:\Pallet-Labels.CSV", False
Exit_Pallet_Label_Button_Click:
Exit Sub
Err_Pallet_Label_Button_Click:
MsgBox Err.Description
Resume Exit_Pallet_Label_Button_Click
End Sub