Jumat, 17 Juni 2016

[MS_AccessPros] Re: Need to use mutually exclusive checkboxes with data source

 

Thanks Bill,  I think I see what is you saying.  I will try it later today.
Thanks again.
Rod



---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Rod - Access has separate radio buttons as well as option groups. Option groups allow multiple radio buttons for one ControlSource. Each button will need a unique integer. You have to "translate" that integer for a value if you are using a field other than a Yes/No. If you have a Yes/No set one control to -1 and one to 0.

If you have something like a list of colors: Red Blue Yellow you could use a table with two fields: The color and an autonumber.
1, Red
2, Blue
3, Yellow


Then add a field to your main table and set the data type as Long. Set your option group buttons to 1, 2, 3.

Do you see where I'm going with this?

Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com



---In MS_Access_Professionals@yahoogroups.com, <desertscroller@...> wrote :

There is radio buttons but a data source does not appear to be used for labeling.


---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

I haven't done it, but does Access have radio buttons?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, June 17, 2016 11:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Need to use mutually exclusive checkboxes with data source

 




I am trying to make a set of checkboxes that have data source.  The problem is allowing only one checkbox to be selected.  The use of option group did not seem to be a good approach since the labels can not be associated with a query.

This application is a survey that uses random questions and most of the answers will be single responses.  For the multiple responses the checkbox work great.

Is there another approach to mutually exclusive responses using a data source?

Windows 8.1 & 10 using Access 2010 and 2013

Rod







 

__._,_.___

Posted by: desertscroller@cox.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.


.

__,_._,___

Tidak ada komentar:

Posting Komentar