Choosing a printer

[DeonO]

Is it possible to call the printing dialog box without the MS Common Dialogue ActiveX control? I tried to use this ActiveX control, but get an error message that I do not have the required licence to use the control. Can someone help?
Thanks

 

[vbaInet]

Look through the constants in DoCmd.RunCommand, you should find it there.

 

[DeonO]

Thanks vbaInet,

I am using the "docmd.printout" method to print, but I need a routine to bring up the list of printers so that the user may choose to which printer he/she wants to print to.
Regards

 

[vbaInet]

I actually did say DoCmd.RunCommand, not DoCmd.PrintOut

RunCommand has several constants and one of them will bring up the print dialog. Just search through the constants for the word Print.

 

[DeonO]

I do apologise - I used the acCmdPrint and it brought up the list of printers. Much appreciated.

 

[vbaInet]

Well done DeanO!