Can a report be coded to print to multiple printers? 2

[kat25]

Hi,
I have a report that I would like for my user to be able to print the report at their work location but I also want to receive a printed copy of the report at my location. We are in different cities, different states.

My database is stored on a network server in which we both have access.


Thanks.

 

[GoDawgs]

First off does the other user have access to the same printers you do? This event will be triggered on their side, so obviously they'd have to.

I think I would go a different route with that, I think I would let them print out on their side, and then create a file of the report (either rtf or pdf) that gets dumped to a subfolder of your shared folder...I've always had trouble messing with printers through code, more headache than it's worth, that's the reason for my not answering your question at all and answering a different one. Hope that helps.

Kevin

 

[kat25]

Yes, the user and I have access to the same printer.
In regards to your statement: "create a file of the report (either rtf or pdf) ", can you tell me how I would create the report as a rtf or pdf file? On my report, I have 2 options: 1) to print the report & 2)close the report.

Thanks.

 

[GoDawgs]

Ooh, my fault, I thought you were printing the report through code. I'm not sure of a way that you could print to a file without controlling everything through code. The code for the output to an rtf file would be:

DoCmd.OutputTo acOutputReport, Me.Name, acFormatRTF, "c:\temp\TEST.rtf"

I mispoke earlier too, you wouldn't be able to create a pdf since creating pdf's is the same as printing.

Sorry I can't be of much help, hopefully someone else has something to add that I'm not thinking of.

 

[MichaelRed]

Still not a DIRECT answer, but you might consider adding so code to the report (open event?) which would do the whatever (pesudo print the report all over again). You coould, perhaps, redirect the print to your location, but I would think that getting 'all that' paper would rapidly become tiresome, so perhaps you could just set a dbvalue, stating the date-time and user name who printed the report., and set up a small app which periodically monitored the va;ue to alert you to the fact.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[kat25]

Thanks for your tips.
I'll see if I can get something working. I might do something similar to the monitoring tip. I do have a notification form build that I could direct the user to send me notification when they have completed their work and then go into the report and print my copy.

Thanks for the replies.