Using PrinterCapabilities Class from litwin-getz-gunderloy

[DataMiner]

I am having problems getting my report to always print to the correct printer bin(which contains special paper), so i thought i would give the PrinterCapabilities class from Getz et al "access 2002 developers handbook" a try. It looks so hopeful, but....

when I look at form frmdevcaps for my printer, it shows bins "tray 1", "tray 2" ,"tray 3", "tray 4"

but when I look at form frmprintersettings for my report, the bin choices are things like acPRBNLower, acPRBNmanual, acPRBNmiddle, acPRBNupper. etc.
less than useful.

so, what gives? is there any way to actually tell windows, thru vb, what printer tray to print to?

this is actually not really an access problem, as in access I can save the printer settings with the report and they seem to stay saved. my problem is actually with an excel file that gets printed from access....but maybe if i can figure this out i could figure out the excel issue, where the printer settings seem to not get reliably saved.

thanks for any help.

 

[gemma-the-husky]

if its one report - just change the selected printer in page setup.

in any case, i tend to open all reports in preview first - then the user can easily right-click and select a different printer. (possibly the easiest method of changing the printer)

 

[DCrake]

Do not have the code with me but I remember doing a similar exercise for a customer of mine years ago whereby page one of the report came out of the top bin (letter headed paper) and the remainder came out of the bottom bin (continnuation sheets). So it is possible. Will see if I can resurect the code from my archives, be patient though.

 

[DataMinerHome]

i want to reiterate that this is not actually a ms access issue but an excel issue. i have figured out how to control the trays in access: from the info that frmdevcaps supplies, you use the tray ID # rather than the names. but i cannot find any way to get to the tray settings through excel vba. what i am doing is printing an excel file from access. so have posted to excel forum instead. (apolgize for lack of caps: broken pinkie finger!)