Access 97 Network Printers

  • Thread starter Thread starter Iain
  • Start date Start date
I

Iain

I'm doing a project at work which requires job-sheets to be printed to
department printers.

How do I use access to automatically change to the printer associated to the
department?
 
Any reason that setting the report to "default" printer
would nnot work?
Click to expand...

The database is for reporting faults, rectification of a fault can be
assigned to one of several departments.

So the report (job sheet) needs to print out on a printer allocated to the
department that will carry out the work.
 
If you open the report in design view, than open the page
setup from the file menu (windows menu bar), click on the
page tab and make sure that the default printer is
checked. This would make the report print to the
individual user's default printer (assumed to be in their
department).
Would this solve your problem?
Hope this helps.
Fons
 
You can either save the current printer with the report,and thus you will
NOT have to change the printer.

Thus, you can save the printer you want to be associated with the report.
That is a code free option. (any reason why you are doing that?).

I also have a very short routine that will let you set/change the printer in
code.

Check out:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
 
Iain said:
The database is for reporting faults, rectification of a fault can be
assigned to one of several departments.

So the report (job sheet) needs to print out on a printer allocated to the
department that will carry out the work.
Click to expand...
 
Iain:

The best way to do this, is to create a table in your db, that contains say
the department ID, department name and the network name of the send to
printer. Then set your report to use the default printer.

Last what you have to do, is open your recordset of "faults" included in the
report, grouping by department and including in the query the department
printer name. Loop through that, resetting your default pirnter to the
target printer on each unique group and filtering the report for that group
using the department id and then outputting the report. Might sound like a
lot of work but its not too bad.

If you need an easy way to set the default printer, then you might want to
take a look at our "On the Fly Printing" code in the developer area of our
web.

HTH
 
Create a series of blank reports. One for each printer.
Add the job-sheets report as a sub-report on each printer-report.

Print the container reports as required, and the job-sheets
will magically go to the associated printers.

or, turn screen updates off, open the report in design mode,
change the printer, save the report, turn screen updates back
on, print the report. (This only works in MDB's, not MDE's,
so we haven't done it that way since Access Version 2.0)


or output the reports as snapshots. Use automation to control
the snapshot viewer to print to the required printer.

or, change the default printer to each department in turn.
(Worked ok in NT and Win98. We never got it to work with Windows
2000 except by using Word Automation).


(david)
 
Back
Top