Open a report from another database

L

Louise

I am building a database that will open a report from another database to
print it.

I have a suite of 12 databases with a report in each that many colleagues
need to print each week. Ideally I need to be able to view / print these
reports at the click of one button (or one button for each rpt) in a database
- any ideas how I can do it?

Thanks
 
R

Roger Carlson

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ReportInBackEndDatabase.mdb" which illustrates how to open a
report that is stored in the Back-End database and print it to your printer.

Whether you use this sample depends on whether you want it to print on YOUR
printer or the REMOTE printer. The reason I say this is because I had this
question once where the user wanted to open a report in a remote database
and print it to the default printer of the remote workstation. The sample
will NOT do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Top