Converting Access Query to XML and sending to Web Server

I need to convert an access query named “ucrdata” to an xml file and then send it to a web server. The query’s parameter value will be the form’s record number from which the code will be called. (Command Button).

mickeyshelley1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RemRemRemConnect With a Mentor Commented:
On the button click event, include:

application.ExportXML(acExportQuery, "<query name being exported>","<filename for XML output>","<filename for schema>")

There are more options available on an ExportXML command (and that last schema one is optional if you don't need it).

Just make sure your ucrdata query has the criteria that filters it to the record value on the form. Essentially:

Forms!<formname>!<recordnumber field name>

-Rachel
0
 
mickeyshelley1Author Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.