MS Access 2003 save xml string as PDF

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
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Larry Bristersr. DeveloperAuthor Commented:
LSMConsulting
Access 2003 Reports can render the XSLT formatting?
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Larry Bristersr. DeveloperAuthor Commented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
Larry Bristersr. DeveloperAuthor Commented:
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
 
Larry Bristersr. DeveloperAuthor Commented:
Yeah...had to go this route
0
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.

All Courses

From novice to tech pro — start learning today.