Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Linking Access Reports

Discussion in 'Information Technology' started by david.isaacks@mail.va.gov, Jul 28, 2006.

  1. david.isaacks@mail.va.gov

    david.isaacks@mail.va.gov
    Expand Collapse
    Guest

    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
     
  2. Loading...


  3. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    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.


    <david.isaacks@mail.va.gov> wrote in message
    news:1152537066.748178.148030@35g2000cwc.googlegroups.com...
    > 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
    >
     

Share This Page