OK… after some investigation I have resolved an issue that was occurring in my Access application.
I have developed an SLA creation tool which is used by 80+ users. The end result/product is an SLA/contract (in the form of an Access report) that gets pushed out to SharePoint in pdf.
With the addition of MS Office 2010, some of my users, who have upgraded, were experiencing extra pages being printed out in the SLAs. Having run into this issue numerous times, I knew that it had to be a margins issue. The report(s) in question have left and right side margins setting of .25”.
When I investigated the issue, these users’ margins were .33”, so I changed them to .25” and saved, however Access 2010 would not let me save the print margins as such. This was supremely frustrating, until I realized that the print set up “default” printer doesn’t necessarily connect to an actual user's default printer. Often times the default setting is a generic printer setting which will not allow one of the side margins (I think left) to be anything less than .33”.
That said, once I change the “default” printer to an actual listed printer from the printer options, the report pushed out just fine.
Great, fantastic, now I know how to get my report to print right. The problem is: now I actually have to go into each report and change the printer setup print options and make sure they aren’t set to “default” and I must choose the appropriate printer. I never had to do this in MS Access 2007. This is incredibly problematic for me, being that I have 80+ users who run a split version of my MS Access app on a variety of Machines all over my organization (meaning differnt buildings/locations and such). Plus I am using an ACCDE file for each of the end users so they can’t actually open my Access file and and make any changes to the design of the report, mainly the printer settings themselves.
So, my question is: Is there a way that the user can go in and set up the print options, from outside of this specific MS Access.accde file, to ensure that all reports within said file will be connected to the appropriate printer, moreover print settings. Honestly, every printer I have chosen, to date, works just fine EXCEPT that stupid MS Office generic default.
Meaning can I somehow set up the reports printer, outside of the specific report's design?
Does anyone have any ideas?
I have developed an SLA creation tool which is used by 80+ users. The end result/product is an SLA/contract (in the form of an Access report) that gets pushed out to SharePoint in pdf.
With the addition of MS Office 2010, some of my users, who have upgraded, were experiencing extra pages being printed out in the SLAs. Having run into this issue numerous times, I knew that it had to be a margins issue. The report(s) in question have left and right side margins setting of .25”.
When I investigated the issue, these users’ margins were .33”, so I changed them to .25” and saved, however Access 2010 would not let me save the print margins as such. This was supremely frustrating, until I realized that the print set up “default” printer doesn’t necessarily connect to an actual user's default printer. Often times the default setting is a generic printer setting which will not allow one of the side margins (I think left) to be anything less than .33”.
That said, once I change the “default” printer to an actual listed printer from the printer options, the report pushed out just fine.
Great, fantastic, now I know how to get my report to print right. The problem is: now I actually have to go into each report and change the printer setup print options and make sure they aren’t set to “default” and I must choose the appropriate printer. I never had to do this in MS Access 2007. This is incredibly problematic for me, being that I have 80+ users who run a split version of my MS Access app on a variety of Machines all over my organization (meaning differnt buildings/locations and such). Plus I am using an ACCDE file for each of the end users so they can’t actually open my Access file and and make any changes to the design of the report, mainly the printer settings themselves.
So, my question is: Is there a way that the user can go in and set up the print options, from outside of this specific MS Access.accde file, to ensure that all reports within said file will be connected to the appropriate printer, moreover print settings. Honestly, every printer I have chosen, to date, works just fine EXCEPT that stupid MS Office generic default.
Meaning can I somehow set up the reports printer, outside of the specific report's design?
Does anyone have any ideas?