Go Back   Access World Forums > Microsoft Access Discussion > Reports

Thread Tools Rate Thread Display Modes
Old 08-12-2019, 12:36 PM   #1
"Access- Imagineer that!"
GohDiamond's Avatar
Join Date: Nov 2006
Location: Hartford, CT
Posts: 548
Thanks: 17
Thanked 48 Times in 46 Posts
GohDiamond is on a distinguished road
Network Printer - Locked Print


I'm working with several network printers.

I'm trying to get access to Printer Properties to set up the Locked Print option as some reports are to be sent to SPECIFIC Printers, not the user's default printer. I'm trying to set this programmatically using VBA.

The Locked Print function maintains privacy when printing confidential documents on the machine over a shared network.

I can set the other options like paper size, tray, color or B/W, etc. But I can't find the Property or command to switch {Job Type} to Locked Print with UserID and Password(4-8Digit Pin)

Thanking you in advance for any help...

GohDiamond is offline   Reply With Quote
Old 08-19-2019, 02:35 AM   #2
Uncle Gizmo
Nifty Access Guy
Uncle Gizmo's Avatar
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 10,307
Thanks: 534
Thanked 937 Times in 888 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Network Printer - Locked Print

I notice it's been a few days and you have yet to receive a reply!

I spent a few minutes searching the forum to see if there's any information, can't find anything! However I thought it worth mentioning because it will bump the post up the list and possibly somebody else will have a look!
|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is offline   Reply With Quote
Old 08-19-2019, 03:38 AM   #3
Super Moderator
Join Date: Feb 2013
Location: UK
Posts: 11,328
Thanks: 40
Thanked 3,667 Times in 3,536 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Network Printer - Locked Print

the locked option isn't a standard printer option - I presume the term you are looking for is 'access controlled printer'.

this link advises you need to modify the driver for epsom printers


So I'm guessing you will need code to update the driver - almost certainly means messing with the windows registry which your IT may or may not allow. Alternatively your IT dept may be able to provide the solution.

Presumably users are able to print excel/word files to these printers as well, so it may already be done, just send the file to print, go to the printer and key in your code. That's how it works at clients of mine who use printer access control.

A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 08-19-2019, 06:25 AM   #4
Longboard on the internet
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,032
Thanks: 20
Thanked 381 Times in 374 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: Network Printer - Locked Print

I developed a system (long ago, in a job far, far away) that handled these type of issue in a very different way.

Users would not have direct access to any report / printing.

Instead, they would have their front end enter a record in a print queue that identified who was requesting what to be printed, along with any criteria required for that report or print job.

There would be a separate server dedicated to handling these types of requests. Internally it would either know which printer to send a specific print job to OR calculate which printer was required by the requesting user and the current day/time.

Not sure if you need that level of security or not, but it did work very well.

Mark_ is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Find printer in network hafco Modules & VBA 0 03-09-2018 12:54 AM
Network Printer Status kadara Modules & VBA 3 04-19-2012 11:45 PM
Print to network printer esskaykay Reports 3 01-02-2008 09:46 AM
I want to print a report and programmatically set the printer name and 'Print to File accesser2003 General 1 07-16-2007 11:44 PM
Network Printer Question AndyShuter General 2 11-02-2003 02:43 AM

All times are GMT -8. The time now is 02:50 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World