By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,958 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Building a Complex form with many tables

P: 15
Hello all,
I am a new user of Access and have run into some problems. I am building an access form that uses multiple tables. This is what I want to do in lay mans terms. I have a form with 3 sets of combo boxes. The first box I want the user to select a protocol that they wish to display.Next I have 2 combo boxes that display dates.

I have 3 tables, one with the date ranges, one with the protocols and one with all the data. I want the user to select a protocol and 2 dates. I want access to look up the protocol in that date range. Then I want to create a line graph of the data that the user selected. I have tried just using a query with all the data in one table, and have been unable to do it. Any suggestions? Thank you all.

James
Jun 11 '07 #1
Share this Question
Share on Google+
6 Replies


NeoPa
Expert Mod 15k+
P: 31,492
You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.

MODERATOR.
Jun 11 '07 #2

P: 15
You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.

MODERATOR.
Thank you, my mistake.

James
Jun 11 '07 #3

NeoPa
Expert Mod 15k+
P: 31,492
James,
Please include the MetaData for all relevant datasets. Here is an example of how to post table MetaData :
Table Name=tblStudent

Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; AutoNumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
This will help anyone willing to work with you to understand what your problem is and how to guide you in fixing it.
Jun 11 '07 #4

NeoPa
Expert Mod 15k+
P: 31,492
Thank you, my mistake.

James
That was quick :)
Jun 11 '07 #5

NeoPa
Expert Mod 15k+
P: 31,492
I was just reading your post about meta labels. I am completely new to access, and am not sure what you were talking about for the labels. Are you talking about the design view for the tables?
Meta DATA is the definition of the tables. What fields (and of which type) are contained within.
If you do a reply to my post, you can copy and paste the text I've used to help you lay it out in exactly the same way.
Access questions are generally very much easier to work with when this information is available. Obviously you need to replace my dummy fields with your real ones. Do this for each table involved in the question.
Jun 11 '07 #6

P: 15
We have solved this problem in office, but now have another one.... :-(

Thank you for the help.

James
Jun 12 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.