Solved

Converting Access Query to XML and sending to Web Server

Posted on 2011-10-01
2
186 Views
Last Modified: 2012-05-12
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).

0
Comment
Question by:mickeyshelley1
2 Comments
 
LVL 7

Accepted Solution

by:
RemRemRem earned 500 total points
ID: 36898365
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
 

Author Closing Comment

by:mickeyshelley1
ID: 36913842
Thank you
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question