Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Print report from Ms Access to a printer that did not install on the computer

Posted on 2012-03-12
2
Medium Priority
?
397 Views
Last Modified: 2012-06-21
Hi Experts,
I just got help from  Helen Feddema and Dodahd about "Automatically Print report to specific printer ".  Is possible that I can print a report from Ms Access to a specific printer that did not install on all user's computer?   For example, I have a report that I want to print to a printer ( this printer's IP Address is 10.121.225.123 and printer name is AA_ABCE_LJ4100_123).  we have over 100 users and they all will print this special report to this printer, but instead to install this printer to every user's computer, is there any way to do that so users can print the report to this printer or I have to install the printer to every computer?

Thanks
0
Comment
Question by:jodstrr2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 37711271
<<is there any way to do that so users can print the report to this printer or I have to install the printer to every computer?>>

Very short answer is no, the printer would need to be available on the users computer as a printer in order to print to it.

But maybe I'm confused a bit on this because how else would you print to a printer (forget Access for the moment) if the printer wasn't installed and available?

Jim.
0
 
LVL 58
ID: 37711528
Actually I did just think of a way that you might accomplish this, but it's probably a little more difficult then just defining the printer.

 Output the report in PDF format and save to a directory on a server.  Then use a utility like this:

http://www.lerup.com/printfile/

 To poll the directory and send the PDF's to the printer.

Jim.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question