I have 2 Option buttons that I want to use to control a combo box. If I select Option1 then I want it to pull from one table for the drop-down choices. If I select Option2 I want it to pull from a different table. The Option buttons and combo box are all on the same form.
View RepliesHi all, a newbie with novice access skills.
I'm very good with utilizing the access tools however I can only code in vb editor minimally. What I'm looking to do is have the option buttons control two combo boxes. One to search by user name and the other to search by serial #. I've created an option group with two buttons I set the default values in the combo boxes in accordance with the option buttons However, the option buttons aren't doing what they are supposed to do. I've been told I need to tweak the code for the buttons in order to make them control the combo boxes. Does anybody know what I need to do to make this happen? Ultimately the user will be able to click either of the buttons to perform a search through a single combo box.
Thanks to everyone out there for making this possible. Your expert knowledge will help me grow into an expert myself.
Thanks to all in advance! :confused:
I'm building a workCube reservation system and I've been tasked to have it work kind of like an airplane seat reservation system. I've laid out my form with option buttons representing the location of each available space. (space1, space2, space3...space16)
My desired outcome is to be able to select a date from a calendar popup and have the options buttons react to that date if they have been reserved. (change color and indicate "reserved").I've tried to create the form based on a query which represents the "booked" table.
Tables:
Employee
(k)empID
emplyeeName
Space
(k)spaceID
space
Booked
(k)spaceID
(k)empID
(k)bookdate
Some rules a space can be booked by any ONE employee on any day.How can I get any and all of the option buttons to react if there is a reservation in place on the day indicated by the calendar?
I'm looking to have either a combo box,, or 2 options buttons (whichever is easiest) that set a date field based on what is selected in the combo box/ option buttons.
The variables are 'Payment in 30 days" " Payment upfront"
if "payment in 30 days" is selected the date field on the form will enter the date as + 30 days from todays date
if "payment upfront" is selected the field on the form will enter todays date.
This date field must be blank unless an option is selected, as this information is only entered in a later stage of the form.
I've tried a few different ways to enter this but i can't quite get it to work as i want.
how to use option buttons? I've looked around, but I cant find any site, thread, etc, etc on how to fully use them. I have 3 option buttons, there "Retired" "Current" and "Not Stocking" I want them to be tied the the list box named "lstItems" that gets its info from a qryItems.
View 14 Replies View RelatedI am doing a worksheet for college and have been asked to create option groups on a form, but I cannot work out how to do this.
The screenshot shows what I have to do but I cannot get the option group wizard to open.
When creating my form based on the design in the screenshot I dragged the Rate field onto the design view sheet but it has only one option button connected to it, I need to add another one that will be connected to the same field and am not sure how to do it. I did try adding another option button from the control bar but I am not sure if is connected to the same field with the correct yes/no properties.
I’m really stuck on how to create: Check Boxes/Option button/Option Group in VBA.
Could someone help on either all of them or some of them please?
Thanks
Richard
I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True
And this for the Lost Focus event
Me.FilterOn = False
Thanks for the help.
I have an option group with two toggle buttons. Is it possible to set up the option group such that only one toggle button is visible at any given time (i.e. the unselected option) So the group has a default value. Clicking the visible button should switch the value, hide the button (option) associated with that value and show the alternate button (option) for the alternate value?
Basically only having one visible button at any given time which toggles between the two values (but I'd like to retain it as an option group, rather than as two independent buttons, as that gives me a handy value from which to determine control sources elsewhere)
I've tried setting the visibility of the buttons from the AfterUpdate event of the option group but it doesn't work.
I know I can do this with independent buttons but was hoping there was a quick(er) and easy way to do it with an option group instead?
I want to put three buttons on a form to filter records (Filter by form), a clear form button and one that applies the filter (Apply Filter) similar to those on the toolbar. The wizard for control buttons in the toolbox isn't helpinjg much. Any ideas?
Tony
I am not even sure where to start with this small problem that will make a big difference.
I have a database that produces yearend accounts, its highly specialized to my industry.
The year end accounts have schedules these can be 1 to 3
On my form I have it set up for 3 schedules, but can be used for 1 and 2 schedules accounts.
However when it come to the reports for layout reasons 3 of the 14 reports needed are tailored to a 1, 2 or 3 schedule, and i have created reports and buttons on the form according to the number of schedules for that account.
What I want to know is this, I have a field on my form that states the number of schedule for that account, is it possible that if say the account i am working on is a 2 schedule account, that it disables the 1 and 3 buttons?
This frame controls an option group. If they are in an existing citation and want to start one for another type, this offers to write a new record in when they try to switch. Problem is, if it DOES write the new record, it seems to be saving the old record, and thus both will end up 56, for example. Access seems to be ignoring/overwriting the Me.frameCitationType.Undo (I don't want to use Me.Undo because they may have made other changes as well).
If the user does not spawn the new citation, it undoes fine. I suspect the problem may be the Filter/FilterOn?
Code:
Private Sub frameCitationType_BeforeUpdate(Cancel As Integer)
Dim chap As Integer
Dim othercit As Variant
Dim curRecord As DAO.Recordset
Dim curDefend As DAO.Recordset
If Me.NewRecord = True And IsNull(Me.CaseNumber) Then
MsgBox "Enter the Service Order and Increment first, please.", vbExclamation
[Code] .....
I need to pass a criteria to a query from my option group control to my query.
It contains three options 1,2 and 3.
If option 3 then Pricing Type 1 and 2
How do I make the code below working?
IIf([Forms]![FrmUserSelection]![PricingType] Like 3,([dbo_AGPricingDiscounts].[PricingType])="2" Or ([dbo_AGPricingDiscounts].[PricingType])="1",",[Forms]![FrmUserSelection]![PricingType]")
I have been tryign to work with Option Buttons and am not having much success. I have been looking on line for examples and I get close.
The example tells me to Set the GroupName Property although I can not seem to find it.
Basically what I do is use the wizard and select the Option Group and add that to the form. With the wizard I enter three Label Names and take the default Values.
I then add a Control Button and use the code below.
Result:
Everytime I click the Control Button it gives me all three MsgBox's. Its reading all the values in the Option Group NOT the one that is selected??????
CODE:
Private Sub Command11_Click()
Dim x As Control
For Each x In Me.Controls
If InStr(x.Name, "Value1") Then
MsgBox "You Selected Value1"
ElseIf InStr(x.Name, "Value2") Then
MsgBox "You Selected Value2"
ElseIf InStr(x.Name, "Value3") Then
MsgBox "You Selected Value3"
End If
Next
End Sub
I HAVE BEEN TRYING A FEW VARIATIONS AND I GET ERRORS WHEN USING THEM:
1. I changed the .Caption to .Name...IF I USE CAPTION it tells me that this "Object does not support this property or method"
'Check for the string "Option" within the caption of each control.
If InStr(x.Caption, "Option") Then
2. Dont knwo where GroupName is
'Check the group name.
If x.GroupName = "mygroup1" Then
MsgBox x.Caption
3. Value gets an error
'Check the status of the option button.
If x.Value = True Then
I have tried creating a combo box in a form and as I have gone through the steps, the option to bind each choice that I created in my drop down box for the form is not an option, so how do I make each choice in my drop down box access the report I need?
View 1 Replies View RelatedBelow is the code that I used to make a Menu. The only problem is that when a report is opened, it is placed under the Menu form instead of on top of it.
How can I get it to stay on top?
Private Sub Frame2_Click()
DoCmd.Restore
On Error GoTo MyTrap
Select Case Me.Frame2
Case Is = 1
DoCmd.OpenForm "Resident from Last Name", acNormal
Case Is = 2
DoCmd.OpenForm "Resident from Phone No", acNormal
Case Is = 3
DoCmd.OpenForm "Resident from Address", acNormal
Case Is = 4
DoCmd.OpenReport "Multiple Addresses", acViewPreview
Case Is = 5
DoCmd.OpenReport "Missing Phone Numbers", acViewPreview
Case Is = 6
DoCmd.OpenForm "Update/Add/Modify PGIDdb"
Case Is = 7
DoCmd.OpenForm "Delete Records", acNormal
Case Is = 8
DoCmd.OpenReport "PrintAll", acViewPreview
End Select
MyTrap:
If Err.Number = 2501 Then
MsgBox "Action Canceled"
Else
End If
DoCmd.Close acForm, "PGMenu"
DoCmd.OpenForm "PGMenu", acNormal 'This places Menu on top of opened report etc.
End Sub
I need 2 option buttons created individually, as an option group has proven utterly worthless to me for what I need.
A simple Yes / No pair that toggle back and forth when clicked.
I would use an option group, but you cannot define an On Click Event Procedure on an Option group button, and I cannot set the value of an option to 1.06 or anything other than whole numbers.
I just want to set a simple On Click event for each to set a variable to one of 2 possible values.
Thanks
Hi All,
Just wondered if anyone can help me with this.
I have a form based on a query that has 16 options for values in one of the fields. I wanted to put an option button for each value on a form that would allow the user to view the records based on which option buttons were selected and have the form update accordingly.
The way I've gone about it is to have some code in the after_update event thingimy of each option button that updates a boolean value in a table that's linked to the underlying query the form is based on - but this just seems a long way to go about this... plus it's not working...
I've searched the archives for clues on this but haven't come up with anything. So I just wondered, is there a better way than what I'm doing. I'm not after somebody to do this for me, just point me in the right direction.
Many thanks,
Peter
Hello, I wonder could anyone help, rescue and succour me.
As a former VB6 developer, I'm now working with wonderful Access VBA 2000 which makes the simplest operation such as creating a listbox or adding a control array into a living, breathing nightmare.
Today's incubus is option buttons.
Dear people, please tell me how it can be so hard to create a group of option buttons which are mutually exclusive and by whose value I can set another variable? I tried just sticking them on the screen, but then soon sobered up when I realised that Access would merrily allow me to select all of them if I so wished in joyous defiance of what an option button is actually FOR.
So I consulted the oxymoronic Help (even though it's impossible to construct an oxymoron with one word, this particular piece of functionality has somehow managed it) and was advised by same to create an option group. This I duly did - then realising that I had to set this property called Option Value 1,2, 3 etc. No sooner said than done. Anything to get it over with.
Now having different values, one would imagine that all I do is give each option button the same name. But no - control arrays in this environment would be like the discovery of the wheel in Caveman Land. So I google it and am told that I have to select the name of the option group.
Now where in all Christendom or Islamdom or NoGodsAtAllDom (in case Richard Dawkins is logged on and wants to help) can I find the name of this option group? Nowhere was I asked to assign an option group name, nowhere can I see a control that resembles an "option group", whatever that may be.
If someone could enlighten me I would be very grateful as a simple problem has once again taken hours thanks to the Access VBA environment. Grrrrrr
And thank you.
I have a form with a number of fields for users to enter data into, with a "Total" being calculated. The users also have the option to ignore these fields and just enter a total manually into a seperate "Totals" field.
I want to set the form up so that when the form is opened the manually entered "Totals" field is hidden, leaving users to enter the component values, with the total being calculated automatically.
However, I want to add an option button so that if users just want to type in a total manually rather than enter the component values, they click the option button and the manually entered "Totals" field appears and the other component fields become disabled. This would prevent both a calulated total and a manually entered total being entered into the form.
Any help on the code that I need to use when the option button is clicked would be greatly appreciated.
Hello,
I have a form named Welcome which I want to use as search menu for my database.
I have added 4 option buttons and a unique textbox into which users will write their query criteria.
My database has 4 queries and each option button should refer to one of them once selected
Obviously I will need a command button that will run the query.
Any help or code to do this? Thanks.
I have a switchboard which gives two selections. Upon selecting a menu item, the new menu appears. If I select from this new menu, it runs as it should do. However, upon returning to this second menu, the button remembers where it was instead of being cleared to select the same item, if desired, again. How can the option box button be cleared as do the switchboard buttons?
View 1 Replies View RelatedI added an Option Group / Radio Buttons to my form.
I named a few.
My question is no how to I test and run code based on the button that is selected.
If this then that?
I just am confused here.....if it was a txtbox I would say
If txtbox = ? then
End If
I have a form with a combobox whose list items are taken from a table of currencies (called tblCurrencies)
Row Source = SELECT [tblCurrencies].[Ccy] FROM tblCurrencies ORDER BY [Ccy];
Problem is, there may come a time when the currency they want to select is not yet part of the tblCurrencies table, and needs to be added. For simplicity, I'd like to have an additional option in the dropdown (perhaps at the bottom) to specify a new currency.So an additional list item (e.g. 'Add New...') which when selected could prompt a subform where the user could specify the new currency (and any other relevant details specific to that currency) which can be programmatically added to tblCurrencies.how do I get that extra option into the list items for the combobox?...
How do I get only one item in a combo box when using the Table/Query option (ie No Duplicates). I want only one of each field with no duplicates.
View 2 Replies View RelatedI've created a form using the form wizard and all of the fields show up as combo boxes. I would like to change a couple of them to option groups with radio buttons. Is there anyway to do this without deleting the fields and making the option boxes from scratch? The reason I ask is because when I do the option boxes from scratch with the wizard, it alters the way the information shows up in the datasheet (it's a split form).
View 2 Replies View Related