|
| 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 |
|
#11
March 10th, 2010, 03:30 AM
posted to microsoft.public.access
|
|||
|
|||
Use of check boxes in a database
Duane,
Hmmm, not admitting anything... grin *But* that bug does not apply if you take form/subform out of the picture so that might explain why I have never run into it. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Duane Hookom" wrote in message ... Gina, first admit that you don't need =IIf() in the control source ;-) and then check out http://www.rogersaccesslibrary.com/f...825 2795bz19f. -- Duane Hookom MS Access MVP "Gina Whipp" wrote in message ... Bob, Hmmm, I have not had such a problem, got any links, I'd like to read up on those... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Quintal" wrote in message ... "Gina Whipp" wrote in : Subject: Use of check boxes in a database From: "Gina Whipp" Newsgroups: microsoft.public.access bowing head to the master ;-) You are correct... tip toeing back out the door.... John is correct, however, so are you. There have been problems reported with using the IIF([checkboxname],...) in a control on a subform which causes the database to refuse to close. Q -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John W. Vinson" wrote in message ... On Tue, 9 Mar 2010 00:41:05 -0500, "Gina Whipp" wrote: Oops.... =IIF([checkboxname], "Yes", "No") should be =IIF([checkboxname] = -1, "Yes", "No") g Gotcha! Nope. If it's equal to -1 it's TRUE and the IIF will work. IIF only cares if its first argument evaluates to a TRUE (nonzero) or FALSE (zero or null) expression. -- John W. Vinson [MVP] -- Bob Quintal PA is y I've altered my email address. 
|
|
#12
March 10th, 2010, 04:39 AM
posted to microsoft.public.access
|
|||
|
|||
|
Use of check boxes in a database
The bug is obscure and possibly existed only in a particular version prior
to service packs. It did nail me about 10 years ago. -- Duane Hookom MS Access MVP "Gina Whipp" wrote in message ... Duane, Hmmm, not admitting anything... grin *But* that bug does not apply if you take form/subform out of the picture so that might explain why I have never run into it. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Duane Hookom" wrote in message ... Gina, first admit that you don't need =IIf() in the control source ;-) and then check out http://www.rogersaccesslibrary.com/f...825 2795bz19f. -- Duane Hookom MS Access MVP "Gina Whipp" wrote in message ... Bob, Hmmm, I have not had such a problem, got any links, I'd like to read up on those... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Bob Quintal" wrote in message ... "Gina Whipp" wrote in : Subject: Use of check boxes in a database From: "Gina Whipp" Newsgroups: microsoft.public.access bowing head to the master ;-) You are correct... tip toeing back out the door.... John is correct, however, so are you. There have been problems reported with using the IIF([checkboxname],...) in a control on a subform which causes the database to refuse to close. Q -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John W. Vinson" wrote in message ... On Tue, 9 Mar 2010 00:41:05 -0500, "Gina Whipp" wrote: Oops.... =IIF([checkboxname], "Yes", "No") should be =IIF([checkboxname] = -1, "Yes", "No") g Gotcha! Nope. If it's equal to -1 it's TRUE and the IIF will work. IIF only cares if its first argument evaluates to a TRUE (nonzero) or FALSE (zero or null) expression. -- John W. Vinson [MVP] -- Bob Quintal PA is y I've altered my email address.
|
|
#13
March 13th, 2010, 05:35 PM
posted to microsoft.public.access
|
|||
|
|||
|
Use of check boxes in a database
"forest8" wrote in message ... Hi I'm hoping for some help in this. I have included the use of checkboxes in my database. So basically, if it's checked, it means yes. If not, it means no. The people who are using this database would like me to include the word yes or no adjacent to the checkboxes. I believe this is redundant but they're insistent on the inclusion. What do you think is the best way to deal with this question? Thank you in advance for your help.
|
|
#14
March 17th, 2010, 01:08 PM
posted to microsoft.public.access
|
|||
|
|||
|
Use of check boxes in a database
gg,n,;::!!
"forest8" a écrit dans le message de groupe de discussion : ... Hi I'm hoping for some help in this. I have included the use of checkboxes in my database. So basically, if it's checked, it means yes. If not, it means no. The people who are using this database would like me to include the word yes or no adjacent to the checkboxes. I believe this is redundant but they're insistent on the inclusion. What do you think is the best way to deal with this question? Thank you in advance for your help.
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
