Report Opens only as title bar (1 Viewer)

Uncle Ned · Oct 3, 2019

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 · Oct 3, 2019

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 · Oct 3, 2019

June7 said:
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 · Oct 3, 2019

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

June7 · Oct 3, 2019

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

Uncle Ned · Oct 3, 2019

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

The Pop-Up property is set at yes

theDBguy · Oct 3, 2019

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

June7 · Oct 3, 2019

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

Uncle Ned · Oct 4, 2019

theDBguy said:
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 · Oct 4, 2019

June7 said:
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 · Oct 4, 2019

Uncle Ned said:
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 · Oct 4, 2019

here you may try.

Uncle Ned · Oct 4, 2019

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

Yes I did, thanks

Uncle Ned · Oct 4, 2019

arnelgp said:
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 · Oct 4, 2019

that is small issue.

before making the report visible, requery it:

Code:

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

Uncle Ned · Oct 4, 2019

arnelgp said:
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

Report Opens only as title bar (1 Viewer)

Uncle Ned

Registered User.

Attachments

June7

AWF VIP

Uncle Ned

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

June7

AWF VIP

Uncle Ned

Registered User.

theDBguy

I’m here to help

June7

AWF VIP

Uncle Ned

Registered User.

Uncle Ned

Registered User.

Attachments

deletedT

Guest

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Uncle Ned

Registered User.

Uncle Ned

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Uncle Ned

Registered User.

Similar threads

Users who are viewing this thread