Solved

Converting Access Query to XML and sending to Web Server

Posted on 2011-10-01
2
192 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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 …

623 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