Solved

MS Access 2003 save xml string as PDF

Posted on 2013-02-07
7
551 Views
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

THIS DATA
?xml-stylesheet type='text/xsl' href='S:\Assignment Control System\Live Tables\Front end\FullApp.xslt'?>
<root>
    <RefSite>Full App</RefSite>
    <FirstName>Donna</FirstName>
    <LastName>Smith</LastName>
    <Address>1234 Main Street</Address>
    <City>AnyTown</City>
    <StateProv>FL</StateProv>
    <Zip>33067</Zip>
    <Email>dsmith@meandyou.com</Email>
    <ConfirmEmail>dsmith@meandyou.com</ConfirmEmail>
    <SSN>123456789</SSN>
    <BirthDate>08/05/1951</BirthDate>
</root>

Open in new window



Renders in a browser like this
Screenprint
0
Comment
Question by:lrbrister
  • 4
  • 3
7 Comments
 
LVL 84
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.
0
 

Author Comment

by:lrbrister
ID: 38865427
LSMConsulting
Access 2003 Reports can render the XSLT formatting?
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 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
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:lrbrister
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
0
 
LVL 84
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.
0
 

Author Comment

by:lrbrister
ID: 38869222
LSMConsulting
I need to keep this question.

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

Author Closing Comment

by:lrbrister
ID: 38884709
Yeah...had to go this route
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now