Open a report from another database

[Guest]

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

 

[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

 

[ccurtis]

Hello,

Did not know if i should start a new thread or not but I am having an issue with the backend report printing mentioned in this thread.

I am using the module from the mdb mentioned in this thread and can get the report to show / print however, the problem is that this report has unbound fields that used to be filled by the form it was printed through by using drop downs and text boxes that were manually filled in as the report is for printing out case labels for our products and the data changes job to job.

I need to find out how to fill in these unbound fields now that i can get it to print (thanks to your mdb)

I am still somewhat of a beginner to intermediate access programmer and should be able to follow along fairly well.

The end goal of this is to get the reports out of the main db as this report must be changed for printing out to specific printers every time the main mdb gets updated to the latest release which is often.

If i wasn't clear on anything please let me know and i will do my best to clear it up and thank you for taking your time to help in advanced.