troubleshooting Question

Access 2010 ACCDE - Odd issue with Print Preview and runtime

Avatar of alevin16
alevin16Flag for United States of America asked on
Microsoft ApplicationsMicrosoft AccessMicrosoft SQL ServerVBA
4 Comments1 Solution895 ViewsLast Modified:
Hello All

I have what I think is an odd issue.  I have an access 2010 program where the backend is on an Azure server with SQL and the front end is an accde on each person's machine.  Many of these people only have Access 2010 runtime.

I was running into all sorts of issues with printing from print preview.  Sometimes it would print, sometimes not (Ctrl+P would not even work), sometimes you could right click (I have a custom menu that would pop up) and the menu would appear sometimes not.

So I decided to change the pop up property to each report to No.  This is working because the print preview ribbon appears.  But here is the issue:

When a user clicks on a report and presses the command button I made in the program the entire program minimizes to the toolbar.  Then if you click on the minimized program the print preview window will open up but it opens in either an extremely tiny window or a middle sized window.  Then the user maximizes the print preview window so it takes up the whole screen.  What is odder still is that as long as they do not log out of my program, from this point forward if they ever print preview a report again it does open maximized.  So it seems they only have to do the maximizing on the first time.

Does anyone know why and if there is any vba code I can put in to stop this?

Thank you all and Happy New Year!
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros