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
6 2789 NeoPa 32,571
Recognized Expert Moderator MVP
You have posted your question in the Access Articles section rather than the Access Forum section.
I have moved it across for you.
MODERATOR.
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
NeoPa 32,571
Recognized Expert Moderator MVP
James,
Please include the MetaData for all relevant datasets. Here is an example of how to post table MetaData : Table Name=tblStudent - Field; Type; IndexInfo
-
StudentID; AutoNumber; PK
-
Family; String; FK
-
Name; String
-
University; String; FK
-
Mark; Numeric
-
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.
NeoPa 32,571
Recognized Expert Moderator MVP
Thank you, my mistake.
James
That was quick :)
NeoPa 32,571
Recognized Expert Moderator MVP
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.
We have solved this problem in office, but now have another one.... :-(
Thank you for the help.
James
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Good Man |
last post by:
Hi there
I'm in the planning stages of creating a database, and I have two options
here. Which makes more sense, and/or provides better performance for
queries - a single table with hundreds of thousands of rows, or many
tables with less rows?
GOAL:
Recording information about buildings, storey by storey. Basically I
will be recording six bits of information about each storey in each
|
by: chuck |
last post by:
Hello,
I have to create a complex form to handle company product returns.
Right now, I have some form fields to describe the product being returned,
productID, productDES,ProductQTY.
Thats fine. I have a button that will dynamically create those
fields with javascript, with an 'add more' button. It creates a line
with consecutive names like
productID, productDES...productID...productID...
similar to this...
|
by: narayana |
last post by:
how to know about how many tables i created in that database.if the
database is connected to many users.
i want the query in this way that i want creater,number of
tables,time,updates .
the last two columns not required i need the number of tables i created
in that table
|
by: Ewin |
last post by:
I'm a beginner user of MS Access, and I am having a problem building a
database with a complex form that enters to several tables.
I did not use subforms because I am attempting to emulate the hard copy
of the form that was given to me by my supervisor. I don't know if that
makes my problem impossible or not...
|
by: Dirk Olbertz |
last post by:
Hi there,
I'm currently about to redesign a database which you could compare with a
database for managing a library. Now this solution will not only manage one
library, but 100 to 500 of them. Currently, eg. all the data about the
inventory (books) is held in one table for all the libraries.
Is it useful to spread this to one table for each library, by eg. giving it
an id as a postfix?
| |
by: Emin |
last post by:
Dear experts,
If I have a number of related groups of data (e.g., stock prices for
different stocks) is it better to put them into many tables (e.g., one
table per stock) or into one big table (e.g., a single table where one
column is the stock id other columns are the price and other data)?
The single table approach with a clustered primary key including the
stock id and other information that is different for each stock seems...
|
by: mcasaurabhsumit |
last post by:
hello friend,
how many tables a dataset can store at a time? can u tell me.
|
by: koehlerc14 |
last post by:
So here is the deal,
I am attempting to make what is the most complex form i have made yet. It really is not much, but as an amatuer it is a little overwhelming. Here's a few critical background point.s
I have 2 Master Databses - I will be linking in only 1 table from each - tblMaster
Each record contains demographic data and about 40 "variable" fields which consist of a name for each variable, and its data
Variable Field 20-29 -...
|
by: zoro25 |
last post by:
Hi,
Maybe my question is dumb, but I'm not sure what is the best approach. I need to build a report and the data is stored in many tables and queries (8 or 9) and I'm wondering if I should build a query to get all my data in one query and build my report based on that query or if I should build my report directly using the data in all the tables or queries.
Thank you
Marie
|
by: TheServant |
last post by:
Hi everybody,
I posted a similar question about 6~12 months ago with no definate answer, so I will give it another go, as the choice has popped up again in my programming life:
If the number of entries is the same is it more efficient (better) to have a single table with many columns, or many tables with few columns? The obvious answer is a single table, because there is less closing and opening tables, but the reason why I ask is what about...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |