Solved

Converting Access Query to XML and sending to Web Server

Posted on 2011-10-01
2
190 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
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.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

730 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