troubleshooting Question
Access 2010 ACCDE - Odd issue with Print Preview and runtime
asked on
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!
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!
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.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.