Linking Access Reports

[david.isaacks]

Can you link Access Reports similar to Access Tables? I woul djust like
to have a Access file with only a form and the linked reports.

thanks,
David

 

['69 Camaro]

Hi, David.

Can you link Access Reports similar to Access Tables?

No. You can only link to data sources, such as tables in other Access
database files or databases, such as SQL Server, or link to files in other
file formats, such as text, spreadsheets, et cetera.

But you could write a VBA procedure that opens the other database and
displays the relevant reports, one at a time. Or you can copy the reports
from the other database into the current database and set the data source as
either a remote query or a query based upon a linked table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.