Printers collection in Access 2000

[xezekielx]

Hi! I have yet another problem... I used the Printers collection of the Application object to change the printer that Access will print to when I use DoCmd.OpenReport "rptFinal", acNormal (or something like that). The code works number 1 in Access 2002 but I just saw that the Printers collection doesn't exist in Access 2000 :'( What can I do? It's pretty important... Thanks in advance!

 

[lupins46]

Fortunately, someone has written the masses of code you need to do this in A2000.

http://www.mvps.org/access/reports/rpt0009.htm

 

[xezekielx]

Thanks but I have another problem. I used the provided code to change the default printer but when I use this code

DoCmd.OpenReport "rptFinal", acNormal, , strWhere

after setting the correct default printer, I get an error message saying that the object couldn't be printed. Also, just before the error message pops up, it shows the small window when it says the number of pages it is currently sending to the printer as well as the name of said printer but the printer's name that's displayed isn't the correct one, it's the default printer before I changed it with the code. I hope you understand what I mean.. Thanks!

 

[xezekielx]

bump please help!