Rabu, 01 April 2015

Re: [MS_AccessPros] Re: Yes/No Checkbox on Continuos Form/Subform

 

Good afternoon everyone!  I think part of my problem is that I have a limited amount of time to work on this project before I have to work on something else.  Sorry for the delayed response but it's been hectic lately.
 
I've read and re-read the emails from Bill and Graham but I either don't understand or I didn't explain my problem correctly.  I have an option group with Yes and No radio buttons.  The option group is unbound but is linked via 'after update' to a text field to record "Yes" or "No" (eventually this will not visible on my form) and which is bound to my table.  When yes is checked in the option group, "yes" is recorded in text field and table for ControlEffectiveID '1'.  When the second entry is checked no in the option group, "no" is recorded in the text field and table for ControlEffectiveID '2'.  This appears to do what I want.  However, on the form the option group button for entry #1 originally checked Yes changes to No when entry #2 is checked No.  If an entry #3 is made on that form, the entry #1 and #2 also change to match #3.  It does not appear to change what is recorded in the text box and, therefore, the table for those previous entries.
 
Does this change your suggestions or have I only confused myself even more?
 
Thanks!
Jessica



On Wednesday, March 25, 2015 6:00 PM, "'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:


 
Hi Jessica
An option group can contain a number of different types of child controls – option (radio) buttons, or toggle buttons, or checkboxes.  In any of these cases they will be mutually exclusive, so you can just choose whatever suits your PHB's preference.
Instead of binding your yes/no field to your single checkbox, you bind it to your option group.  The option group contains two child controls – one for Yes (OptionValue=-1) and one for No (OptionValue=0).
I think that it's not possible for a yes/no field to be Null, so the default value will be No (false) unless you set the DefaultValue  of the field to True in the table.
Best wishes,
Graham [Access MVP since 1996]
 
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 26 March 2015 08:52
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Yes/No Checkbox on Continuos Form/Subform
 
 
Thanks Bill,  I have an option box with the two radio buttons for Yes and No.  How do I use an option box without the check boxes?
 
Sorry, I have a lot to learn about Access.
 
Jessica 
 
 
 
 
Jessica
 
Don't you just love pointy-hair bosses? Use an option group with no check boxes. You could fake check boxes but it would require a lot of coding for no good reason.
 
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
 


---In MS_Access_Professionals@yahoogroups.com, <hobackjessica@yahoo.com> wrote :
Good Afternoon all!
 
I'm trying to add yes/no checkboxes to a form.  The checkboxes are actually on a subform which is continuous allowing the user to enter multiple selections on one form.  I have no problem with just one checkbox for Yes, however, the bosses want Yes and No checkboxes so the user will have to check one or the other. 
 
I tried to use an option group which works as far as storing data, however, if the user checks Yes on the first entry and then checks No on the second entry the first checkbox will switch to No.  This doesn't appear to change the data being stored from the user's entries, just the checkbox appearance on the form.  I'm afraid this will cause a lot of confusion.
 
What am I doing wrong?
 
Jessica
 


__._,_.___
Posted by: Jessica Hoback <hobackjessica@yahoo.com>
Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (6)

.

__,_._,___
Diposting oleh di

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)