473,569 Members | 2,648 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to change Option Group Labels Programmtically ?

1 New Member
Hi,

I am building a inventory system using ms access. Each inventory id can be from different regions. In one form, users enter the inventory id and if there is more than one region, another form opens up to let the users choose the region. I am thinking of using an option group to display all the regions that is associated with that inventory id. Is there any way i can programmaticall y assign the number of radio buttons and their labels name and values to an option group.
I am new to access.Thanks for the help!

Wayne
Dec 20 '10 #1
1 3835
colintis
255 Contributor
The amount of radio buttons are fixed as it involves changes in design mode, so the only way is to set them invisible or disable those that are not needed. Another thing is that radio buttons' label are individuals, there's no dynamic ways to change their label names and you need to change them one-by-one (eg. label1.caption= xxx, and so on).

What best to do you should replace the radio buttons with a combobox or a list box instead. As these also support selection events, and more efficient if you are talking about flexible amount of selections.
Dec 21 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

19
2002
by: What-a-Tool | last post by:
I have a school project (ASP) in which I have to call three different ASP pages from three different and identical (except for the form "action", obviously) HTM pages. This I have no problem with. However, as a personal learning project and challenge, I decided to see if I could code my initial HTM page to call any of the three ASP pages,...
7
3282
by: Shyguy | last post by:
I have an option group with about 30 options. I would like to have the Option Labels get their text from a table. Is this possible, and if so how? Also, is it possible to embad a font into a database or does each machine need to have that font installed? Thanks for any help, ShyGuy
5
5368
by: Georges Heinesch | last post by:
Hi. I created an option group using the wizard. I included 3 option buttons. An option group (in general) can be enabled or disabled completely (includung option buttons and their respective labels) when enabling or disabling the frame around the option group. This is quite handy, since not every individual control inside the otion group...
2
3322
by: Corrine | last post by:
Is there a way to cancel a change in an option group? The option group still changes to the option clicked on when clicking on the NO button with the following code in the BeforeUpdate event of the option group. If MsgBox("Change?", vbYesNo) = vbNo Then Cancel = True End If Thanks!
7
2777
by: sparks | last post by:
When you enter an option group you can move to each option with the arrow keys and select with the space bar. Option groups don't have keydown events so has anyone come up with a way to allow keyboard entry for option groups? Just a simple way to select with 1-5 from the keypad or some such. thanks for any help or a link to what to...
1
1568
by: =?Utf-8?B?R2lsZXMgUGFwd29ydGg=?= | last post by:
have an asp.net option group list. I need to be able to style it or at least override the render event so i can put in my own styles. Short of developing an inherited control of the option group im not sure what else i can do. I suppose the best way of explaining what i want to try and do is like this: The option group list is rendered...
5
23600
by: Student1000 | last post by:
Help me out please... Ok, i have been trying to do this for months….I kinda gave up on it but am back at it again. I created a form for a table (Bills). In the form, I have three option buttons (Yes,Tbd,No). The problem is that the value of these options are numbers (1,2,3). Therefore, every time I add a record using the form I end up with...
1
2374
beacon
by: beacon | last post by:
Hi everybody, I've searched around for answers, but the closest thing I've found referenced the Northwind database and it seems to be set up a little differently than mine. I'm using DAPs (data access pages) for my user interface, but I'm not sure that the method will be much different than forms (except for some of the property names). I...
11
5270
tuxalot
by: tuxalot | last post by:
Another quick question for ya... Here's my button code, and I want to see if I can do something different so I don't have to repeat the same code for each of my 14 buttons in my option group: Private Sub grpS1_LostFocus() Dim intCount As Integer Dim lngRed As Long, lngBlack As Long lngRed = RGB(186, 20, 25)
0
7701
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8130
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7677
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7979
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6284
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1223
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
940
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.