Change printer based on user

[matttclark]

Hello,

have a multi user Access 2003 DB that we are planning to run on citrix. have set up test manager reports to go to a pdf file using pdfcreator (sourceforge version). the issue is that the citirx admins will not let us map a specific drive back to each users local pc, BUT we can use unc's to point to shared network folders. mangers are at 3 locations, home, west and south and each has permission to a network drive that is lcoal to their location.

using pdf creator i created multiple printers and associated profiles with each printer. with this we have set up printers named pdfhome, pdfwest and pdfsouth. the primary difference is that each printer points to a UNC directory accessible to the managers at that location only, in additon all set default file naming.

how can i call the specific printer based on the user? Can use either network name or the access login name (UL security).

following is the code section i am using in printing

Dim prtDefault As Printer
Set prtDefault = Application.Printer
 
'want to change printer here based on user
Set Application.Printer = Application.Printers!PDFHome
 
DoCmd.OpenReport "Mgr Monthly", acViewNormal, "", "", acNormal
Set Application.Printer = prtDefault

thanks in advance!