Report Opens only as title bar

[Uncle Ned]

Hi All,


There is probably a very simple solution to this, but after a couple of hours of experimenting and google search, I can't find it.


When I open my DB in design mode, i.e. pressing the "Shift" key, I have no problems. The form opens ok and the report opens correctly from the CMD button - see picture 1.


However, when I run the DB as I want the user to do, then the report opens only as the title bar - see picture 2


It's basic code to open the report

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

 

[June7]

Looks like you have db set to hide application frame. I've never done this.

What happens if you open report with acViewPreview?

 

[Uncle Ned]

Looks like you have db set to hide application frame. I've never done this.

What happens if you open report with acViewPreview?

When I change it to acViewPreview the report doesn't pop up, but opens in the main access frame in a frame only manner as well

 

[arnelgp]

how about Maximizing the report on it's Open event.

 

[June7]

Maybe report's Popup property needs to be set to Yes.

 

[Uncle Ned]

Maybe report's Popup property needs to be set to Yes.

The Pop-Up property is set at yes

 

[theDBguy]

Hi. Just curious... Do you have any code in the Open/Load/Print/Format event of the report?

 

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[Uncle Ned]

Hi. Just curious... Do you have any code in the Open/Load/Print/Format event of the report?

Yes, I have the following code On Load for the report


Me.AutoResize = False


It makes no difference though.


I have just noticed that if the main Access Window is minimised then the report only opens as the title banner, if main Access Window is open or maximised then the report opens correctly

 

[Uncle Ned]

If you want to provide db for analysis, follow instructions at bottom of my post.

I've localised all the tables (they are normally on SharePoint) and had to removed most of the data to get under the 2Mb limit. There's nothing confidentail here, so knock yourself out.


Thanks

 

[deletedT]

I've localised all the tables (they are normally on SharePoint) and had to removed most of the data to get under the 2Mb limit. There's nothing confidentail here, so knock yourself out.


Thanks

I liked buttons in your forms.
Did you design them yourself?

 

[arnelgp]

here you may try.

 

[Uncle Ned]

I liked buttons in your forms.
Did you design them yourself?

Yes I did, thanks

 

[Uncle Ned]

here you may try.

I gave it a try, and although it resolved one problem, your solution created another.


Because the report was open, and hidden, when the form was loaded, it did not update with the data generated in the form and therefore had blank lists or errors in the text boxes.

 

[arnelgp]

that is small issue.

before making the report visible, requery it:

    Reports("rptQCWeeklyReport").Requery
    Reports("rptQCWeeklyReport").Visible = True

 

[Uncle Ned]

that is small issue.

before making the report visible, requery it:

    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