Welcome to SPN

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

Sign Up Now!
  1. Guest ji, please consider donating today!
      Become a Supporter    ::   Make a Contribution   
    Monthly Recurring Target: $300 :: Achieved: $95

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
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page