By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,700 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,700 IT Pros & Developers. It's quick & easy.

How to create script from Access 2000 report

P: 2
I wanted to find out if there was anyway that I could create a script that would tell me which printer in our print servers is not being used by anyone. I currently have a report from MS access 2000 with all the server names and Ip address and printQ. Please let me know how I can do this, I know there's a way but I'm not sure how to begin with this.
Mar 22 '10 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 234
Since Access doesn't use scripts, it makes me wonder what you're asking. Could you clarify precisely what you're trying to do?
Mar 22 '10 #2

P: 2
Sorry well I have a access report with all the printers on out network. I wanted to know how I could create a script that I could use to check on every single printer on the network we would like to know which printer is not being used on our network there's a total of 8 print servers.. Any help would great.
Mar 23 '10 #3

Expert 100+
P: 234
I was able to find this MS tutorial on checking printer status. I'm not sure what language the code is written in - not VB. Maybe C#? This may give you a good place to start, though.;en-us;160129

And here's another one that uses VB code to call the API for the printer:
Mar 23 '10 #4

Expert Mod 15k+
P: 31,769
I suggest you look at Windows Scripting Host facilities. There are libraries available for VBA as well as being able to use it with VB Script etc using WScript.Exe or CScript.Exe from a command prompt.
Mar 24 '10 #5

Post your reply

Sign in to post your reply or Sign up for a free account.