A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Check boxes to run queries



 
 
Thread Tools Display Modes
  #1  
Old May 28th, 2010, 02:25 PM posted to microsoft.public.access.forms
Natalie
external usenet poster
 
Posts: 212
Default Check boxes to run queries

Hi,

I want to use check boxes to choose criteria. I was to return a table for
the following data:

Invoice number, Customer number country, part number, qty, value etc.

There are 5 countries, I want to have a check box for each so we can choose
which ones to include, and then click GO.

How do I do this? I am new to this.

Thanks

Natalie
  #2  
Old May 28th, 2010, 03:06 PM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Check boxes to run queries

On Fri, 28 May 2010 06:25:01 -0700, Natalie
wrote:

I'm not sure I understand. Typically an invoice is for a customer, and
that customer has a billing address in some country. Why would you
want to select countries?
Maybe you only want to include invoice lineitems for work performed in
certain countries?

More info, please.

-Tom.
Microsoft Access MVP


Hi,

I want to use check boxes to choose criteria. I was to return a table for
the following data:

Invoice number, Customer number country, part number, qty, value etc.

There are 5 countries, I want to have a check box for each so we can choose
which ones to include, and then click GO.

How do I do this? I am new to this.

Thanks

Natalie

  #3  
Old May 28th, 2010, 03:17 PM posted to microsoft.public.access.forms
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Check boxes to run queries

Natalie,
Check out Option Groups in Access Help.
It allows you to group those 5 check boxes into a group, where
only one check box can be selected at a time, and gives each selection a
different numeric value. For ex. [optCountry].
The query can then determine that IF optCountry = 1 then it's "USA,"
or IF optCountry = 4 it's "Canada" etc...

BUT...
Now that will work... but it's clumsy... in that the query must
interpret
(using IFs) 5 numeric values to a textual equivalent. What happens when you
have 6 countries? 8 countries?
Each time you'll have to re-"IF" the query for the added numeric values.

I would suggest a combo box instead, (ex. cboCountry) with a Value List
of
all the countries as the RowSource. Then the query can take the combo value
directly in it's
SQL statement.
Country = Forms!SomeFormName!cboCountry
If another country is added... just add it to the combo's Value List,
and that's it...
nothing else to do.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Natalie" wrote in message
news
Hi,

I want to use check boxes to choose criteria. I was to return a table for
the following data:

Invoice number, Customer number country, part number, qty, value etc.

There are 5 countries, I want to have a check box for each so we can
choose
which ones to include, and then click GO.

How do I do this? I am new to this.

Thanks

Natalie



  #4  
Old May 28th, 2010, 03:53 PM posted to microsoft.public.access.forms
Natalie
external usenet poster
 
Posts: 212
Default Check boxes to run queries


Thanks for your reply.

This is because we are looking at the international sales for the company on
certain products, so I i want the product specialists to be able to choose
what data they include from the table.

Does this make sense?
  #5  
Old May 28th, 2010, 04:11 PM posted to microsoft.public.access.forms
Natalie
external usenet poster
 
Posts: 212
Default Check boxes to run queries

Sorry, I'm not sure I understand. I want them to be able to select multiple
countries, all or just one.
Not sure how to do the combo box.

Thanks

Natalie
  #6  
Old May 29th, 2010, 04:52 AM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Check boxes to run queries

On Fri, 28 May 2010 10:17:15 -0400, "Al Campagna"
wrote:

I'm afraid you missed the requirement of selecting multiple countries.

-Tom.
Microsoft Access MVP


Natalie,
Check out Option Groups in Access Help.
It allows you to group those 5 check boxes into a group, where
only one check box can be selected at a time, and gives each selection a
different numeric value. For ex. [optCountry].
The query can then determine that IF optCountry = 1 then it's "USA,"
or IF optCountry = 4 it's "Canada" etc...

BUT...
Now that will work... but it's clumsy... in that the query must
interpret
(using IFs) 5 numeric values to a textual equivalent. What happens when you
have 6 countries? 8 countries?
Each time you'll have to re-"IF" the query for the added numeric values.

I would suggest a combo box instead, (ex. cboCountry) with a Value List
of
all the countries as the RowSource. Then the query can take the combo value
directly in it's
SQL statement.
Country = Forms!SomeFormName!cboCountry
If another country is added... just add it to the combo's Value List,
and that's it...
nothing else to do.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.