Avatar of jrmcanada2
jrmcanada2Flag for Canada

asked on 

Disable "Save Export Steps" dialog in Access 2010

I have code that creates a PDF from Access:

        DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, strFileName

However, after it creates the PDF, Access opens up the "Save Export Steps" dialog. We never use this so it is just adding an unnecessary level of complexity (and confusion) every time a user creates a PDF.

Is there a way to eliminate this dialog?

Thanks!
Microsoft Access

Avatar of undefined
Last Comment
crystal (strive4peace) - Microsoft MVP, Access
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

I do not get the dialog to Save Export Steps when  I output to PDF.  What version of Access are you using?
Avatar of jrmcanada2
jrmcanada2
Flag of Canada image

ASKER

Access 2010 with the latest updates. The About screen says Version 14.0.7166.5000 (32-bit)

I get the dialog both from the .accdb and the .accde versions.
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of jrmcanada2
jrmcanada2
Flag of Canada image

ASKER

Oops. My mistake. I didn't realize the code I found had a different way of processing PDF's to everything else (Word, Excel, etc.).

Thanks for the suggestion. When I put the STOP in and it never reached the STOP, I realized my error.
great! ~ happy to help
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo