Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Screen flicker on output PDF
Sami Shamma 
             
3 years ago
Greetings friends

I Generate PDF from a button on a report in report-format. When the button is clicked, the screen flickers and the report format is partly deformed until the PDF generation is complete in few seconds.

I have placed DoEvents after my code:

    DoCmd.OutputTo acOutputReport, "ManAnnualDetailR", acFormatPDF, OutputFile
    DoEvents

But the flickering is still there. Is there a solution to this? or should I document this and sell it to my users as a feature!!!
Kevin Robertson  @Reply  
          
3 years ago
Try turning off the screen writes (Important: remember to turn them back on)

    Docmd.Echo False
    DoCmd.OutputTo acOutputReport, "ManAnnualDetailR", acFormatPDF, OutputFile
    DoEvents
    Docmd.Echo True
Sami Shamma OP  @Reply  
             
3 years ago
Kevin, my hero

It worked like a charm

many thanks
Kevin Robertson  @Reply  
          
3 years ago
You're welcome.
Kevin Yip  @Reply  
     
3 years ago
I don't think DoCmd.OutputTo causes the slow screen update, because it doesn't actually opens the report.  It is DoCmd.OpenReport that  opens the report in whatever screen mode you specified.  If the report's record source is slow in retrieving the data, the screen will naturally be slow in updating -- the same thing that would happen if you open the report manually yourself in the navigation pane.  You need to speed up your record source, such as by using temporary tables (as per my suggestion a few days ago).  Or simply remove DoCmd.OpenReport.  Your users don't really need to see the report.  They only need to see the PDF, which can be opened with  DoCmd.OutputTo if you set the option after the file name to True:

     DoCmd.OutputTo acOutputReport, "MyReport", acFormatPDF, "C:\My Documents\MyReport.PDF", True
Sami Shamma OP  @Reply  
             
3 years ago
Kevin Yip my friend
you are always full of great ideas. In my user's case, the printed report is their primary interest. the PDF is only required by the few. Having said that, I will be implementing your temporary tables method to all my reports.

Have you had the chance to look at my post for opening a back-end database to manipulator the tables? The link is below.

https://599cd.com/blog/display-article.asp?ID=1953&CommentID=76694#StartOfComments

I would love your input on that.

Many thanks

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/30/2026 7:06:55 AM. PLT: 0s