Outlook and Access ?'s

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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.
 
Joined
Jun 17, 2002
Messages
2,556
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.
 
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
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top