If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using multiple checkboxes
Hi
My problem is this; i got Query (qryETime) that is getting date and name from form (frmETime) date is date range and name is combo, that all work fine. Once ran it will display annual leave, sick leave, comptime used, comptime worked...etc. basicaly all the exceptions. What I would like to do is have checkboxes on frmETime for annual, sick,... once person selects it it will display only the selected time. They would be free to select multiple checkboxes or just one. In query i can insert 0 and query will give me let's say all Annual Leave greated then zero. how do you do it from form ???? Thank you. |
#2
|
|||
|
|||
Further information needed on your table structure. Do you have separate fields
in one table for each type of leave? Or do you have one field to store the amount and another to identify the type? Assuming that you have multiple fields and that the fields always contain some value and that your checkbox has a name like chkAnnual you might try Field: Annual Criteria: IIF(Forms!frmETime!chkAnnual=True,99999999,0) You would need to stair step the criteria for each type of leave, so SickLeave would look like Field: Sick Criteria: Blank NextCriteriaLine: IIF(Forms!frmETime!chkSick=True,99999999,0) If you have a more normalized data structure then post back with the structure and perhaps we can work out a solution. DrEvil wrote: Hi My problem is this; i got Query (qryETime) that is getting date and name from form (frmETime) date is date range and name is combo, that all work fine. Once ran it will display annual leave, sick leave, comptime used, comptime worked...etc. basicaly all the exceptions. What I would like to do is have checkboxes on frmETime for annual, sick,... once person selects it it will display only the selected time. They would be free to select multiple checkboxes or just one. In query i can insert 0 and query will give me let's say all Annual Leave greated then zero. how do you do it from form ???? Thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking checkboxes to multiple worksheets | vegasdude123 | General Discussion | 5 | August 19th, 2004 09:58 PM |
Multiple Many-To-Many Tables | Tom | Database Design | 7 | May 15th, 2004 03:47 AM |
Opening multiple workbooks in multiple windows | Dave Peterson | Worksheet Functions | 0 | February 22nd, 2004 04:20 PM |
Multiple Conditions and Multiple Solutions | Frank Kabel | Worksheet Functions | 0 | February 4th, 2004 09:22 PM |