Printing a report from another database.

[Guest]

I currently have a database that is my "automated" coding to open another
database, run several codes to import tables, run queries and make a
finalized report. Well within my "automated" database, I want to completely
make it automated and also print out the report that is made in the other
database. How would I go about doing this? My current code is

DoCmd.OpenReport "L:\ and the rest of the path"

I was figuring by just adding the full pathname it would print out that
report from the specific database I entered, but I get the error message
stating "could not find report" etc. Could anyone please help me, is this
even possible?

 

[Alex Dybenko]

Hi,
you have to start new access instance, open otehr database there and then
prinet a report. i believe that you can find a sample code at
www.mvps.org/access