Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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
 
Old January 25th, 2008, 12:56 PM
Registered User
 
Join Date: Jan 2008
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.

 
Old January 25th, 2008, 02:36 PM
Friend of Wrox
 
Join Date: Mar 2004
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
 
Old January 27th, 2008, 11:32 PM
Registered User
 
Join Date: Jan 2008
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.

 
Old January 28th, 2008, 08:22 AM
Friend of Wrox
 
Join Date: Mar 2004
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
 
Old January 28th, 2008, 09:49 AM
Registered User
 
Join Date: Jan 2008
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






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





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