Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old January 25th, 2008, 12:56 PM
Registered User
 
Join Date: Jan 2008
Location: Indianapolis, IN, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access: Checkbox input to build query

I need to build a query based on Option Group/Check Box input from the user. They need to be able to query by any of four different fields in the table. I've never been able to figure out how to make multiple selections from in an Option Group so my guess I must use multiple checkboxes disguised as option groups.

Any ideas? Anyone...anyone:(

Thanks Steve.

Reply With Quote
  #2 (permalink)  
Old January 25th, 2008, 02:36 PM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Can you post more information? You can check values in the check boxes and use Select Case statements to process the query string. What are the columns, and how do you want query the data? (Before and after).


mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #3 (permalink)  
Old January 27th, 2008, 11:32 PM
Registered User
 
Join Date: Jan 2008
Location: Indianapolis, IN, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What I'm attempting to do is create an easy method for my users to create one time queries. From tblPers my users will want to query on one or more fields. The fields will be cboRank, grpStatus. cboRank has 28 possibilities. Can't envision a user would need to check more than 5 from this group. grpStatus six entries with probably not more than three checks per query. My plan is to have the user click a command button that opens a form with multiple Option Groups or groups of check boxes with all of the selections for building they query.

Thanks for the assist.

Steve.

Reply With Quote
  #4 (permalink)  
Old January 28th, 2008, 08:22 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I would use a multi select list box for this and allow the user to click on one or more, or no, criteria from each list box. Or at least a list box and some check boxes. Then package the query from there. Do you need help on passing the string?

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote
  #5 (permalink)  
Old January 28th, 2008, 09:49 AM
Registered User
 
Join Date: Jan 2008
Location: Indianapolis, IN, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't have access to the Library, but the multi-select list box gives me a new direction. Thanks

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
pass-through query with input parmeter jimmy Access 4 February 8th, 2018 10:21 AM
Oracle connection-passing input to query!! thottufj Pro Visual Basic 2005 1 October 18th, 2007 03:21 PM
SQL query from input form skywalk22 SQL Server ASP 7 October 21st, 2004 09:24 AM
passing input to a query mirage Access 3 October 23rd, 2003 08:43 AM
Checkbox input won't email scottiegirl PHP How-To 3 August 6th, 2003 07:40 AM



All times are GMT -4. The time now is 05:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.