Access vba open report as pdf

I've got a form on which a user selects a client, start date, and end date for a report. I've tried reformatting the field to mm-dd-yyyy and various other combinations -- but when I check the field name in VB i. Is there perhaps a global setting somewhere that determines how dates are interpreted by default? Dev Center. Explore Why Office? Android ASP. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.

You may want to make a second copy of the printer and label one Bullzip Portrait and the other Bullzip Landscape. The reason that I used the Bullzip Printer was that it produces very acceptable quality pdf files that are one third the size of those produced by the Office ExportAsFixedFormat command when the Quality is set to screen and also the fact that it can be automated from VBA.

Thanks Doug, once again the right answer. There are so many properties to be set at different places eg Orientation on Report Level, on Application Level, on Hardware Level such that i forgot to try it on Printer Level.

Output - Quality Property. But finally i found an acceptable configuration. So now i got all pieces together and it works nicely. As an amazing side effect i have a huge performance boost. If i create a lower quality pdf via DoCmd. Output it takes 50s, if i do the same via a Pdf Printer it takes just 5s!!

So this has better quality and is 10x faster There should be more acExportQualityPrint setting than just the two you mentioned like the four you have in Pdf Printers screen, ebook, printer, prepress but as the DoCmd. OutPutTo Method does more than just Pdf creation i guess this was out of reach. Moreover i agree with your advice but here i just couldn't find a good solution without third party.

So it is faster 10x , has better image quality and here it get's really wierd as better quality should imply larger file size the file size is lower kb for DoCmd, kb for PdfPrinter via VB in my example report. So my final judgement is: you really have to go via Pdf Printer to create Pdf's.

It's not that easy to implement it with VB for sure but it's way superior. Best Regards. Thanks in advance!! I have the same question Bouje Bouje 67 1 1 gold badge 1 1 silver badge 5 5 bronze badges. Add a comment. Active Oldest Votes. OutputTo should be considered part of the same logical instruction: DoCmd. Improve this answer. HansUp HansUp Sign up or log in Sign up using Google. Sign up using Facebook.

Sign up using Email and Password. Post as a guest Name. DataNumen Inc. Your database can still be brought back to life. Jayme Stack is a data recovery expert in DataNumen, Inc.

For more information visit www. This is very helpful. However, I do have another issue. The report I have contains multiple records. Instead of having one report that contains all the records. Your email address will not be published. Share Now:.