Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Access 2010 ACCDE - Odd issue with Print Preview and runtime

Avatar of alevin16
alevin16Flag for United States of America asked on
Microsoft AccessMicrosoft SQL ServerMicrosoft ApplicationsVBA
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!