Save/Print to PDF when a Report is closed.

  • Thread starter Thread starter Beth
  • Start date Start date
B

Beth

I have a message box prompting the user if they want to Save the report
before closing. If they click the 'Yes' button, I want to open the
Print Dialog box and select the PDFWriter option. I started with the
DoMenuItem, but I'm having a hard time finding good documentation on
the Methods/Enumerations to get this going.

At minimum, I need to display the Print dialog box and they can pick
the PDFWriter option.

Thank you in advance for any advice.
Beth
 
Beth,

I have used a print command in VBA and from what I recall you can specify a
printer. I just don't remmember the syntax, it has been 6 or 8 months and I
just don't remmember. Check VBA help.

Hope that helps!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Printing PPT to PDF without losing quality 1
How can we convert OST to PDF file format? 1
PDF generation and Outlook automation error 12
Print hyperlink when saving to PDF. 1
Problems generating reports from a modal dialog 3
symbols export to PDF problem 5
Access Report Output to PDF (Acrobat) 8
Converting access report to pdf format 2

Back
Top