ToniMaura said:
Is posible in Access (2000, XP...) make a report, save it
in a library database, and then call it other database
using the data stored in this database (not the data
stored in the library database). If yes, how...
Yes, it's possible. There are issues of maintaining the
dependencies between the **three** databases (front end
program, back end data, and library).
To open a report in a library database, the front end must
set a reference to the library mdb file. Then, the library
must contain a public function that opens the report (using
the OpenReport method).
To get a report in the library to use the data in the back
end mdb file, you have to tell the report where the data
resides. The library could either link to the data tables
in the back end or use the IN phrase in the report's record
source query's FROM clause, BUT these techniques will
prevent the library from being used in other applications
with different front/back ends. To make the library
general, you have to either set the links or modify the
report's record source on the fly.
