Linking Access Reports

#1 (**permalink**) 28-Jul-2006, 08:32 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12856-linking-access-reports.html

thanks,
David

*

#2 (**permalink**) 28-Jul-2006, 08:32 AM

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/ex...ributors2.html for contact
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12856
info.

wrote in message
news:1152537066.748178.148030@35g2000cwc.googlegro ups.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12856
> 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
>