Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 10-04-2019, 05:30 AM   #16
Uncle Ned
Newly Registered User
Join Date: Sep 2019
Location: Wicklow, Ireland
Posts: 15
Thanks: 4
Thanked 3 Times in 3 Posts
Uncle Ned is on a distinguished road
Re: Report Opens only as title bar

Originally Posted by arnelgp View Post
that is small issue.

before making the report visible, requery it:
    Reports("rptQCWeeklyReport").Visible = True

Although the Requery worked, if I close the report and then tried to open it again I got an error becuase the code was looking for a hidden report and couldn't find it. I could have change the close button to hide it again, but I was thinking that if I had multiple reports then would I need to have them all opened and hidden to overcome this problem.

I did come up with a solution myself, simply;

DoCmd.OpenReport "rptQCWeeklyReport", acViewPreview, , , acWindowNormal
DoCmd.OpenReport "rptQCWeeklyReport", acViewReport, , , acWindowNormal

However, I still view this as a work-around rather than getting to the root of the problem.

If anyone has any further suggestions as to the problem then please feel free to let me know.

Thanks to all those who have helped

Uncle Ned is offline   Reply With Quote
The Following User Says Thank You to Uncle Ned For This Useful Post:
Tera (10-04-2019)

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Title ArznK9 Modules & VBA 3 10-16-2013 06:39 AM
Open report button which opens the report selected in a combo box. wmphoto Macros 1 07-30-2012 05:47 PM
report title fanfan2 Reports 3 11-25-2009 11:47 AM
Display Title on Datasheet View's Title Bar joesmithf1 Modules & VBA 1 03-14-2007 10:57 AM
Opening a report instead opens a form (which opens a report)? NaClO2 General 4 06-15-2005 07:47 AM

All times are GMT -8. The time now is 05:45 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World