Hi I am trying to use ExportXML Method in MS Access for exporting a query with a user input using forms.
I get the error:
Run - time error '31532'
Microsoft Access was unable to export the data
This is the code that I used.
Private Sub Command9_Click()
Application.ExportXML ObjectType:=acExportQuery, DataSource:="eparcelorder", _
DataTarget:="C:\XML\" + tmpWorkOrderNo.Caption + ".xml", _
WhereCondition:="dbo_eParcel.workorderno = '" & Forms!frmMainForm![tmpWorkOrderNo].[Caption] & "'"
End Sub
Is there any limitations in MS Access 2010 that prevents exporting data when it asks user input or using criteria?
Thank you in advance for your help! I've been working on this for a week and it is a very simple function :banghead:
I get the error:
Run - time error '31532'
Microsoft Access was unable to export the data
This is the code that I used.
Private Sub Command9_Click()
Application.ExportXML ObjectType:=acExportQuery, DataSource:="eparcelorder", _
DataTarget:="C:\XML\" + tmpWorkOrderNo.Caption + ".xml", _
WhereCondition:="dbo_eParcel.workorderno = '" & Forms!frmMainForm![tmpWorkOrderNo].[Caption] & "'"
End Sub
Is there any limitations in MS Access 2010 that prevents exporting data when it asks user input or using criteria?
Thank you in advance for your help! I've been working on this for a week and it is a very simple function :banghead: