MS Access 2003 save xml string as PDF

Posted on 2013-02-07
Medium Priority
Last Modified: 2013-02-13
In VBA I am setting a string variable to data from a stored procedure.

Is there any way (In MS Access 2003 using VBA) that I can take that string variable and save straight to a correctly rendered PDF file using the XSLT in the string?

I want a button that produces the PDF

?xml-stylesheet type='text/xsl' href='S:\Assignment Control System\Live Tables\Front end\FullApp.xslt'?>
    <RefSite>Full App</RefSite>
    <Address>1234 Main Street</Address>

Open in new window

Renders in a browser like this
Question by:lrbrister
  • 4
  • 3
LVL 86
ID: 38865205
The browser parses the XML and presents it in a human-readable format. You'd have to do the same, in some manner.

To me the easiest way would be to build a report based on the XML data and then print that report to PDF.

Author Comment

ID: 38865427
Access 2003 Reports can render the XSLT formatting?
LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 38867506
No - save the data in Access, then build the report the way you want.

Access 2003 has very limited XML handling capabilities (saving XML data and persisting it out to a file, basically). If you want something more sophisticated you'd need to build your own process.

With that said: Can you not store the XML to disc, and then use an embedded web browser to show it, and then Print that document? I've never tried to print anything from a web browser through VBA but perhaps it's possible
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.


Author Comment

ID: 38867788
LSM Consulting
Actually, I AM storing to the users temp file at runtime and destroyong on close.

I'm using the Web Browser COntrol
You can see a similar question at This Place
LVL 86
ID: 38868470
If you're already doing that over there, then I'll post comments for the IE suggestions on that thread. If you don't get further comments here you should Delete this question.

Author Comment

ID: 38869222
I need to keep this question.

I'm looks for a way to render the xml/xslt file straight to a PDF File

Author Closing Comment

ID: 38884709
Yeah...had to go this route

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Implementing simple internal controls in the Microsoft Access application.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

619 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