Printer Default

[redbird59]

I need to hard code a specific printer as the printer for reports from an Access 97 app. Does anyone know how to do this simply?
Thanks

 

[mharroff]

I don't know if this is what you are looking for but if when you are in design view for a report go to File then select Page Setup and then select the Page tab. Here you can set a default printer for the report.

 

[redbird59]

Thanks! Unfortunately that doesn't solve my problem. We have multiple users and when a user prints from the application who doesn't have the app default printer installed by the exactly correct name their machine default printer is used. Then that machine default printer becomes the app default printer and chaos ensues. I need to ensure that only one specific printer is used as it is set up with the correctly formatted paper to print a very specific kind of report. This report needs to land in the correct geographical space too to be used correctly in the overall enterprise structure. So the solution is one of a) client/server configuration so each user has a unique set up of printer that suits them or b) hard code the printer name and ensure that every user has a printer with the correct name and that they cannot print otherwise.
Its the hard coding that I am having difficulty with. Any ideas on how to do this code-wise so that no other printer can be used?
Thanks!

 

[chrissie1]

if you have access 2002 then it will be easy. Other version will be a lot more difficult if not impossible to do this. Because there you will need an api call. And i have been trying to get it to work for weeks and never got it. "What a wonderfull world" - Louis armstrong

 

[BillPower]

I found an interesting article on the Microsoft site.

http://www.microsoft.com/AccessDev/Articles/GetzCh10.HTM

I'm trying to set a specific printer as you've requested, but haven't managed it yet. If anyone else manages to get it working, please post code. I will if I succeed.

There are drawbacks though, if you do get it working.

1. Won't work in MDE

2. Won't work in Runtime enviroment.

3. In a secure app, will have to allow user design view rights.