Need to change printer details in .accde

[suepowell]

HI, I have a system which I want to distribute as an .accde.

I need the customer to be able to set up printers for some of the reports on site, as they have different requirements in terms of which tray to use etc.

If these are set up and saved in a .accdb the settings stay, but when using an .accde the settings revert to default when the report is closed.

This is going to be a system delivered by remote means, so having access to an .accdb to set these parameters is not going to be possible.

Has anyone out there done this, or have any suggestions as to how I might achieve this in a production type rather than one off setting.

Thanks for your thoughts.

Sue

 

[boblarson]

You would probably need to save the settings in a table and then load them when the database opens. Not sure exactly how to go about the save and loading as I haven't done this for printers myself.

 

[Simon_MT]

A bit of a long shot! If this is a matter of letterhead and plain paper you could create a Report Header with the information from the letterhead so that the entire report could be printed on plain paper.

I didn't what sort of printers were going to be used so I deployed this solution.

Simon

 

[scalextric59]

use the printer object. In your case I think it would be Printer.PaperBin