Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA 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 June 13th, 2005, 01:27 PM
Registered User
 
Join Date: Jun 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Check-boxes on input form

I am trying to create a form that has over 25 check-boxes that a user can select (i.e. 1, 2, 3, ..... or all 25). I know that there is some type of nested loops or IF-Then statements that need to be created for them. I am tying the selections to 5 tables because there is a large amount of data that is being compiled. I am just baffled on how to get them to work. Any help would be greatly appreciated. Thanks!!
 
Old June 13th, 2005, 03:47 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Welcome to Wrox.

When you say, "I know that there is some type of nested loops or IF-Then statements that need to be created for them."

That is only true if you have some conditional event that happens when some of them are checked or some combination of them are checked. Before we can help you answer your question, you need to tell us your requirements. For example,

"I need this report to open if the first five checkboxes are checked."

"I need this form to open if the checkboxes having to do with inventory are checked."


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 14th, 2005, 06:26 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

25 check boxes is not a large amount of data. That can all be stored in one table. What other data is being gathered? Is this just a data entry form, or is it calling reports or another form, etc.?



mmcdonal
 
Old June 14th, 2005, 07:28 AM
Registered User
 
Join Date: Jun 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

After the check boxes are selected, the user clicks on "Preview Report" and a report is generated. I have 200 systems that can have many capabilities. I have 5 tables, 2 are system users and enclave (security requirement) and the other 3 are groups of capabilities. All of the tables are tied into the systems table. What we are wanting is for the user to select the capabilities, system users, and enclave; then a report is generated to show what systems meet that criteria. The same report will appear just with different systems. Thanks again for your help!!

tina
 
Old June 14th, 2005, 11:40 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Wow, you can have lots of different ways to open these reports.

You can issue a DoCmd.OpenReport with a very long criteria argument.

You can have the report open and then check the values of all the checkboxes on the calling form and then hide/show subreports based on those checkboxes.

You can have one report open but its record source could change based on the selection of checkboxes.

You can set up multiple reports and which one opens depends on which checkboxes are true.

Etc.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division





Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Input Boxes ann86 Beginning PHP 1 April 7th, 2008 04:06 AM
Loop over check boxes sams ASP.NET 1.0 and 1.1 Professional 5 July 17th, 2007 06:26 AM
Check Boxes Allan320 Access VBA 3 June 2nd, 2006 05:45 AM
Using check boxes in datagrid ractim ADO.NET 2 September 8th, 2004 08:28 AM





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