Export parameter query to xml

[ladylexus]

Hello, I'm having a problem trying to export output to an xml format.

I have a query that uses a form field as the query criteria. I want the query to execute without the prompt for the criteria.

This is the sql of the query:

SELECT FldRptsQueryPt1.*, FldRptsQueryPt1.rmsDetails.rmsNumber
FROM FldRptsQueryPt1 LEFT JOIN OffensesQuery ON FldRptsQueryPt1.rmsDetails.rmsNumber = OffensesQuery.Offenses_rmsNumber
WHERE (((FldRptsQueryPt1.rmsDetails.rmsNumber)=[Forms]![rmsDetails]![rmsNumber]));

The code I'm using to run the query is under a button on the rmsDetails form:

Application.ExportXML _
    ObjectType:=acExportQuery, _
    DataSource:="FldRptsQuery", _
    DataTarget:="C:\FldRptsQuery.xml"

From the query window the query works when the form rmsDetails is open.

When I use the button on the form I get the prompt to supply the rmsNumber and then the data is exported. I would like to get rid of the prompt for the rmsNnumber.

I'm new to access so I don't know if I'm using the right approach for this situation.

Thanks you.

[ladylexus]

Hello, I'm having a problem trying to export output to an xml format.

I have a query that uses a form field as the query criteria. I want the query to execute without the prompt for the criteria.

This is the sql of the query:
SELECT FldRptsQueryPt1.*, FldRptsQueryPt1.rmsDetails.rmsNumber
FROM FldRptsQueryPt1 LEFT JOIN OffensesQuery ON FldRptsQueryPt1.rmsDetails.rmsNumber = OffensesQuery.Offenses_rmsNumber
WHERE (((FldRptsQueryPt1.rmsDetails.rmsNumber)=[Forms]![rmsDetails]![rmsNumber]));

The code I'm using to run the query is under a button on the rmsDetails form:
Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="FldRptsQuery", _
DataTarget:="C:\FldRptsQuery.xml"


From the query window the query works when the form rmsDetails is open.

When I use the button on the form I get the prompt to supply the rmsNumber and then the data is exported. I would like to get rid of the prompt for the rmsNnumber.

I'm new to access so I don't know if I'm using the right approach for this situation.

Thanks you.

I found a solution. I'm posting here in case some one else may run into the same situation.

I removed the criteria from the query and used the filter criteria option on the exportxml method. My new export statement is:

Application.ExportXML _
ObjectType:=acExportQuery, _
DataSource:="FldRptsQuery", _
DataTarget:="C:\FldRptsQuery.xml", _
WhereCondition:="FldRptsQueryPt1.rmsDetails.rmsNum ber = '" & Forms!rmsDetails![rmsNumber] & "'"


My app now exports to an xml format without requesting input form the user.

Notice the "WhereCondition:=", in a lot the samples I ran across I saw "FilterCriteria" which does not work for me with Access 2003. My app does not deal with thousands of records so the filter option works for me. If you have to read lots of records this may not work for you.

Again I'm new to Access but the above method does work.

[flyingfish15]

Hi,

I have the exact function you used for exporting a query using a parameter however I am getting an error of "Run - time error '31532'
Microsoft Access was unable to export the data".

Do you have any idea why is this happening?

[twinnyfo]

flyishfish15,

Do you have the same version of MS Access as ladylexus? This could be an initial starting point for your issue.

[flyingfish15]

Hi twinnyfo my version of Access is MS Access 2013..Does this have any compatibility issue with MS Office 2013?

[twinnyfo]

flyingfish,

Your version of Acces (2013) should be fully compatible with MS Office 2013. However, if you are using code from a previous verison of Access it "could" affect your exports. I have only run into problems during exports like this--but it is rare.

At the same time, I have had lines of code work for years, and then all of a sudden, they will generate an error. Access is also not very informative when an error is generated. I wish I had better advice, but the OP did did find resolution.

Now, if we could only solve your issue....