Print / View Report in One Database from Another

[Guest]

I am very stuck with something I am trying to do and am hoping someone might
be able to help me?!

I have a suite of 10 different (similar) Access databases and there are 3
reports in each that my customers have to view / print off each week. Rather
than having to enter 10 different databases to do this weekly I want to put a
database together that will allow the users to print / view all market
reports from the one database without having to rebuild the entire back end
again.

Ideally I would have a form with buttons to print off the reports from the
other databases...

I have managed to write code to get a button to open another database, but I
cannot get it to recognise the report - Any ideas or suggestions appreciated!

Many Thanks

 

[SA]

Louise:

Really how you need to do this is described below:

1.) only leave the data in 10 back end databases; attach the tables from
those databases to your new front end and migrate all the reports and
queries into the front end database. You then only have one db with reports
but can update the data in the backends at any time.

2.) Alternately you could create VBA code to open one of the back end
databases from the new front end and print the report, close the database
and open the second one. The problem with this approach is that its very
overhead intensive. But you could do this like so:

Dim objAccess as Object
Set objAccess = CreateObject ("Access.Application")
objAccess.OpenCurrentDatabase
objAccess.Docmd.OpenReport "YourTargetReport"
obAccess.CloseCurrentDatabase

repeat for the next report / database