Docmd.Output to - Supress the Printing dialog

[simonjwlawn]

Hi folks - am using the Dodmc.OutputTo to save Access reports as PDF on my LAN. Every iteration of the loop shows the "Outputting Report to ....." dialog. Does anyone know how to supress the dialog ? It's looks messy from a user perspective. All help appreciated. Cheers Simon

 

[vbaInet]

Here's a resource:

http://access.mvps.org/access/api/api0037.htm

I've not used it but it's worth a shot.

 

[simonjwlawn]

Cheers - works ok but as the author said it actually does show the dialog albeit for a shorter period of time than is the case without it. I might try a different method of writing the report to PDF other than the docmd.output to - Thanks again

 

[vbaInet]

No problemo! Here's one last shot

http://www.mrexcel.com/forum/showthread.php?t=13057

 

[simonjwlawn]

brilliant - I will gave that a try - thanks again

 

[marfi95]

I am attempting the same basic thing, trying to get rid of the print dialog while my reports are produced as PDFs in a loop. I used the link from vbaInet (the mrexcel link) with great success using microsoft access 2007 under XP. I replaced the print dialog with a nice progress bar and it looks good. However, I had to migrate to access 2010 running under Windows 7 and it no longer works. There were no changes to the db.

Does anyone know of a way to get the code to run properly under windows 7 and access 2010. Using 32 bit Access 2010.

Thanks

 

[vbaInet]

Do you have Office 2010 on any other OS? Some of the declarations (e.g. SendMessage) may not be compatible with your version of Win 7.