Hello everyone. I am brand new to Access and am in need of some help.
I have a database with three main tables--customers, project, and then
a joined table called project_customers. In the customers table there
are these fields--customer_id, firstname, lastname, address, city,
state, zip, sex, age. The projects table has project_id,
project_number, project_name. The joined table is joined with the
primary key from both tables. I would like to create a form where a
user can select different things and click on a button and it would
pull all the records based on the selection that they made for
example--if I selected female, age 30, city of chicago--when I click on
a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do
apologize you will have to explain in lamens term or step by step.
Thanks. 2 1277
On 31 Jul 2006 11:46:25 -0700, jj*****@gmail.com wrote:
This is one area where Access (and you, as the smart developer taking
advantage of it :-)) can really shine.
If you have a parent/child form with a parent form showing the
customers, and a subform showing the selected projects for that
customer, all you need is the built-in Query By Form to do what you
want.
-Tom.
>Hello everyone. I am brand new to Access and am in need of some help. I have a database with three main tables--customers, project, and then a joined table called project_customers. In the customers table there are these fields--customer_id, firstname, lastname, address, city, state, zip, sex, age. The projects table has project_id, project_number, project_name. The joined table is joined with the primary key from both tables. I would like to create a form where a user can select different things and click on a button and it would pull all the records based on the selection that they made for example--if I selected female, age 30, city of chicago--when I click on a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do apologize you will have to explain in lamens term or step by step. Thanks.
I think I may have already done that. I used the Autoform button at
the top of the toolbar. When I click off design view it gives me all
the records with all the fields. Now how do I set up a separate form
where a person has to make the different selections and just only those
records show? Thanks.
Tom van Stiphout wrote:
On 31 Jul 2006 11:46:25 -0700, jj*****@gmail.com wrote:
This is one area where Access (and you, as the smart developer taking
advantage of it :-)) can really shine.
If you have a parent/child form with a parent form showing the
customers, and a subform showing the selected projects for that
customer, all you need is the built-in Query By Form to do what you
want.
-Tom.
Hello everyone. I am brand new to Access and am in need of some help.
I have a database with three main tables--customers, project, and then
a joined table called project_customers. In the customers table there
are these fields--customer_id, firstname, lastname, address, city,
state, zip, sex, age. The projects table has project_id,
project_number, project_name. The joined table is joined with the
primary key from both tables. I would like to create a form where a
user can select different things and click on a button and it would
pull all the records based on the selection that they made for
example--if I selected female, age 30, city of chicago--when I click on
a button it would just give me all women at age30 with city of chicago.
Can anyone help me with this. Once again I'm new to Access so I do
apologize you will have to explain in lamens term or step by step.
Thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Randell D. |
last post by:
HELP!
I am determined to stick with this... I'm getting there... for those who
haven't read my earlier posts, I'm createing what should be a simple
function that I can call to check that...
|
by: Tonya |
last post by:
Hi,
Does anyone have any example of how i can manage forms in
my application??
I want to be able to reference my form instances that are
currently open from other forms.
why cant i open...
|
by: Gregory A Greenman |
last post by:
I'm trying to write a program in vb.net to automate filling out a
series of forms on a website. There are three forms I need to
fill out in sequence. The first one is urlencoded. My program is...
|
by: Pat Patterson |
last post by:
I'm having serious issues with a page I'm developing. I just need some
simple help, and was hoping someone might be able to help me out in
here.
I have a form, that consists of 3 pages of...
|
by: Lyn |
last post by:
Hi,
I am working on a genealogy form. The only table (so far) lists everybody
in the family, one record per person. Each record has an autonum ID.
The parent form (frmMainForm) displays the...
|
by: Dave Guenthner |
last post by:
I have a csharp form1.cs created with VS. I have added a menu bar
with one option called help. I then created another form in VS called
help.cs. How can I launch the help form from the main form...
|
by: Kathy Burke |
last post by:
HI. in asp.net app, I have an xmlDocument that I transform to the client
html. Using xsl I create a few textboxes to capture user input. Each of
these are related to <data> elements in the xmlDoc....
|
by: Lee Newson |
last post by:
Hi,
I have just written my first application using VB.NET. The app works fine
when i am running it within .NET for debugging purposes, however when i try
to run the app from the .exe file that...
|
by: mohit.akl |
last post by:
Hey guys & gals
I am havng trouble modifying the control box. I want to make the
maximise button invisible and have minimisise button instead of it.
Like this _ X (not like _ o X )
How...
|
by: MikeB |
last post by:
Hi, I'd appreciate some help, please. I'm writing a VS2005 VB project
for school and one of the requirements is that every screen should have
a "Help" button.
I could do it by writing a clumsy...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |