dynamic query using checkboxes

yessir

yessir

Saved By Grace
Local time
Today, 00:56
Joined
May 29, 2003
Messages
349
i have a form with a billion check boxes,

i need to run a query with a button based upon the boxes checked...

i tried modifying other ones that use combo boxes but it doesn't work

could someone code the button for like Yes and No search of a table from checkboxs?
 

Attachments

Just as a matter of interest why do you have a checkbox for yes and a checkbox for no, why not just use one and if it's ticked it's yes and if it's unticked it's no? or was that just an example?
 
example

i get that, this is just an example
i have like 50 on the form i want to use,
this is just so that ppl replying don't have as much to work with,

ie, less work for you may mean you'll help!

:D
 
Sure no probs I've used checkboxes with QBF before so I'll have a look for you this evening if that's not too late for your time schedule.

On seconds thoughts I do have something I can send you to loo at (one I made earlier:D ) I'll delete the confidential stuff first and post back.
 
Last edited:
Access 2000 Version

Leaving all check boxes blank will return all records. I have sent the results to a report that I drew up very quickly so sorry for it being messy.

Any problems let me know
Hay
 

Attachments

thanks

thankyou,

i am using XP so i hope it works

just wondering, did you just add a button and set the stuff ur self, cause every tin=me i add a button the wizard opens
 
sorry

again, how did you set up the query, just in the command button code?
 
1 more

how come there are the hidden text boxes,

may be simple, just trying to understand

kinda new
..;)
 
Ok I've had a look at your database. You haven't copied the module over from my program to yours that's where your problem lies. Copy this over and see how you get on with that.
 
You must log in or register to reply here.

Similar threads

A
Solved Access Checkboxes choosing their own alignment
Replies
16
Views
706
Uncle Gizmo
Uncle Gizmo
T
Display text in calculated query field based on multiple checkboxes
Replies
4
Views
438
timbits35
T
F
Solved Mask with sub-mask filtered by 2 combined drop-down boxes and a checkbox, opening two different reports depending on the checkbox
Replies
6
Views
440
Faoineag
F
W
Solved From with One-To-Many Relationship table
Replies
19
Views
559
wmix
W
F
Solved Form with subform filtered by two cascading combo boxes and a checkbox
2
Replies
26
Views
629
Faoineag
F

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom