Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
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

Quote:
Originally Posted by arnelgp View Post
that is small issue.

before making the report visible, requery it:
Code:
    Reports("rptQCWeeklyReport").Requery
    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)
Reply

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
General
Tables
Queries
Forms
Reports
Macros
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