Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help Scoring Tables
Just off the top of my head, I'd imagine an easier method would be to create a separate table for each Question. For example: Table Q1: A S blue 50 red 70 yellow 65 Table Q2: A S yes 20 no 0 John- jvonbokel
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
too many checkboxes
Aha, that's simple enough. Thanks! By the way, for the record, the part I wanted to split up was inside quotes, so I had to do something like this: DoCmd.OpenReport "ReportName", acPreview, , "ChkBox1 <= [Forms]![FormName]![Field1] And " _ + "ChkBox2 <=...- jvonbokel
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
too many checkboxes
I have a form with 28 checkboxes, all of which correspond to fields in a query. I have a button which I want to have pull up a report, but only show records with matching checks. For example, if a user clicks 2 checkboxes and hits the button, I want them to see all records that have those two...- jvonbokel
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
