Access 2010 ACCDE - Odd issue with Print Preview and runtime
Posted on 2015-01-02
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!