1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Outlook and Access ?'s

Discussion in 'Business Applications' started by willadene, Apr 15, 2004.

Thread Status:
Not open for further replies.
  1. willadene

    willadene Thread Starter

    Joined:
    Aug 24, 2003
    Messages:
    105
    2000 Outlook was installed on the computer but for some reason when customizing Outlook Today the customize button does not work. Any suggestions.

    2000 Access

    I have two tables that I want to build into a form. I have a common key between the tables which is the combination of two identical fields from each of the two tables but for some reason, I cannot pull these 2 tables into 1 form.

    Thanks.
     
  2. Ziggy1

    Ziggy1

    Joined:
    Jun 17, 2002
    Messages:
    2,551
    For Access:

    I'm going to assume one table is a Header and the other is a detail, with this in mind you would want to build a form with a subform.

    Create a form based on the header "Type" table.

    Then in design view resize the window so you can see the DB window beside the form.

    Click on the table that contains the "Details" and drag it to the form (below the other fields). This should launch the Subform wizard, you can choose the fields that relate and if I guessed right it should do what you need.

    Post back if any problems, again the "Header/Detail" I refer to is essentially a One to many relationship.
     
  3. MustBNuts

    MustBNuts

    Joined:
    Aug 21, 2003
    Messages:
    2,016
    Another option is to first create a query involving both tables. Run the query to make sure it is pulling the pertinent info, and when you are happy with the data output, you can create a form based on that query.

    Hope this helps,

    MBN
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/220669

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice