Say I have two bubbles (options,buttons, whatever you know them as) I want the system to be set up so that only one of the two can be "true" at a time. Say they are titled Option1, and Option2. What code would I put on them so only one can be "true" at a time. If Option1 was true, and then someone clicked on option2, I want it to cause option 1 to go false.
Any help would be greatly appriciated. THANK!
I have form using a toggle option with four buttons. The values are 1,2,3 & 4. How can I convert the values to read (in the table) as words instead of values.
Example
1=dog
2=cat
3=bird
4=hamster
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’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.
Hi
I've got an Option Group with 3 options; Yes, No and Future.
I also have a range of Check Boxes; 1 for every day of the week.
When one of the check boxes is selected I want the Option Group to change to Yes.
Currently, the Option Group defaults to Future and No will only be available by manually selecting it. This doesn't need to be changed.
Any help will be greatly appreciated!
Cheers
Hi !
I have in Form textBox and toggle button.
How could i Filter Form by Value in TextBox? (when toggle button is pressed, Form show records filtered by texbox, when unpressed - shows all records.)
Thank You in advance!
Hello,
I'm trying to update this movie database, and I need something to save me time, not to mention my finger.
One field in this db tracks if a movie is colour or black/white. In the old/existing db, that was done with text - "color" and "black & white". I want to replace that with a yes/no field [Color].
But the db has a few thousand entries.
What I would like to do is either change all of the [Color] fields in the new db to yes, and then manually uncheck the ones that are b/w. But I guess it should also be possible to do the whole operation automatically.
Any ideas as to how to accomplish either of these would be appreciated.
Thank you.
Hi all,
I have a form with two subform on it and two toggle buttons.
Clicking each toggle button will open one of subform, and clicking it again will close that subform. But the problem is that I need to click the toogle button two time to open the sub form.
So, what is the problem??
This is the code under On Click event:
Private Sub Toggle0_Click()
If Me.TendComm_Label.Visible = False Then
Me.TendComm_Label.Visible = True
Me.TendComm.Visible = True
Else
Me.TendComm_Label.Visible = False
Me.TendComm.Visible = False
End If
End Sub
Private Sub Toggle1_Click()
If Me.AuthorizedSignature_Label.Visible = False Then
Me.AuthorizedSignature_Label.Visible = True
Me.AuthorizedSignature.Visible = True
Else
Me.AuthorizedSignature_Label.Visible = False
Me.AuthorizedSignature.Visible = False
End If
End Sub
Hi.
I have never used a toggle button on a form before, and have searched the previous threads, with this one (http://www.access-programmers.co.uk/forums/showthread.php?t=113115&highlight=toggle+button) being the most relevant I think.
I need a toggle button, so that when it is pressed, it runs one query, and when depressed, it runs another. Basically, it is used as a add/Delete button sort of thing....but the add is an append query and the delete is a delete query.
I can't seem to change the code in the above sample, can anyone help?
Many Thanks.
Frank.
how do these work syntactically? there's no wizard for them.
i want to create a button that displays a picture, then when you click it, it shrinks the form and changes the button picture, and when it is clicked again, the form goes back to the original size and picture. thanks
Hi, I'm very new to programming and i have very little knowledge about it. My problem is probably more simple than I may think, but for some reason I haven't been able to find a solution for it.
In MS Office, I'm making a form with a few toggle buttons which are linked to Yes/No fields on a seperate table. What I would like to do with the buttons is in their default state, which is "No", I want for the word "No" to appear on the top of the button. When the button is pressed, I need for the button to display the word "Yes". I know that it's possible to set the caption on the button to "No". Is there a way to have the caption change to display "Yes" with the press of the same button it's on? If so how? Also to have the fields reset to default with a new page on the form.
Please explain it to me as if I'm a 5 year old trying to learn programming.
Thanks in advance.
I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".
[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]
The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.
Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.
Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.
Does any one know of a way to toggle a multiselect listbox's property programmatically?
The One In The VBS Help doesn't work!
hi again,
i am making a form which has a help link on it;
the help link is basically a label using this code:
Private Sub help_Click()
Me.help_pop.Visible = True
End Sub
this makes the help_pop label appear visible (as it's visibility is false)
ok so i have that bit sorted, now i want to be able to click the help link agian to make the help_pop label disappear..
any help appreciated
Rob
Hi, I would like to have a toggle button on my form that when clicked it changes the button colour and the button text. The toggle button doesnt have to be bound.
cheers
I have got a DB being used in the office, its a big one so obviously it has quite a large number of tables and forms, alotta the forms are either split forms or have related tables inside them (and in a few cases both)
Everything working fine but people in the office are getting confused, as there are many fields in some of these tables I've set default values to make things easier for everyone, however when people look at the info on the DB they sometimes see a new record, with some fields seemingly filled in (default values) and hence assume its a record that exists which caused confusion
I've attempted to explain that a star on the left hand side indicates a new record which doesnt exist, however this just adds to their confusion..... (seriously makes me wanna facepalm), anyways im thinking it might be simpler if there were a way to toggle on or off the new records row (or hide/unhide it)
of cuorse i know this may cause problems, as if im successful some people will go "hey what happened to the star in it?" or simply ignore the last row outta habit, however i figure ill cross that bridge when i come to it.....
I have a form that is basically just a matrix/visual of a query. Is there a way to "toggle" between the use of queries/data?
i.e. have a drop down and select query, "SH-LS", "FPH-ENV" or "FPH-Asset" and it will show the corresponding data. The queries are all set up the same, just gathers/calculates different criteria.
Hi - I have another problem. I hope you can help me out on this one.
Right now, I have 3 toggle buttons to control the visibility of 3 subforms. However, I only want a single subform to show at any given time. So, if I were to select toggle 1 it should give me subform 1, and afterwards if I select toggle 2 it should give me subform 2 WITHOUT showing me toggle 1.
Is there anyway to get the toggle buttons to work with each other?
Thanks,
:)
Hi
Using a toggle box to ask the following question, i have data that contains either OPEN or CLOSED against each record. I tried using the following in the criteria for the specific data to either select all the OPEN records when the box is clicked and i would like to select all records OPEN and CLOSED when it is nto clicked
IIf([Forms]![MEQN_ProdACStn_Picker]![Toggle38]=True,"OPEN","")
This didn't work and a number of other attempts failed as well...
How do i do it in the criteria selection or is it not possible
Cheers
Newbie Jasper
I created a form that has about 200 fields and all the fields are utilized at a point depending on the work order assigned to us. I wanted to know if it's possible to put like a toggle box or a check box etc. next to the field so if it is checked it would be in a Dark color and the ones not utilized are in a shade of gray. All the fields are coming from the same table. Another thing it's an estimate worksheet so a row would have something like, Labor, QTY, HRs, Overtime, total as columns, so I would want a check box to have control over those but one for each row, EX contractor, locksmith.
View 3 Replies View RelatedIs there a way to show the toggle buttons in an option group as NOT selected when the form first loads up? I've cleared all the default value properties in the table and the form but it always loads as showing one of the buttons pressed/selected. I want the form to load and both buttons in the group look the same.
View 3 Replies View RelatedI am making a specialty form where it must toggle on or off when the user clicks on a boxed area. Since toggle backgrounds cannot be set to transparent, I need to do it some other way. I thought of either using a button to control a hidden checkbox, or just writing code altogether. The problem is that I don't know what code to use to programmatically change the state each time the box is clicked.
View 14 Replies View RelatedI have a contact list db that displays in datasheet view on startup. I also have an alternate form that displays in datasheet mode that i want to be able to toggle to with a click of a button. I would like the button to appear at the top of the default datasheet form, that will allow a user to toggle to the alternate form when they need to.
View 7 Replies View RelatedI have form with a number of of combo boxes that filter a query that populates a list box. It's used to track inventory. I want to add a toggle button that when press will filter my query so that it shows only items with a value > 0 in the quantity field. And when not pressed it won't filter by that field at all.
View 14 Replies View RelatedHere's a little design problem, all of my VB script works fine, it's just a design problem:
Toggle Button (onClick) {
if pressed in, unlock protected field, pass focus to protected field
else (if not pressed in), lock protected field
}
Protected Field (lostFocus){
When Focus is lost, protect field then reset toggle button
}
See, there's no way that I know of for Access to tell what field has focus at any given moment. It lies inert until an event fires off then it responds. You can't wake Access up and tell it to go do something. So, Protected Field has to lock itself when it loses focus.
Here's the problem. If a user unlocks the field but then decides not to make a change and clicks the toggle again to lock the field, first Access fires the script to protect the field (locking it), then it resets the toggle button, then it registers the toggle button click which unlocks the field. See the problem? If the user changes their mind about changing the field and then tries to lock the field, it ends up unlocked. I need something that will work whether the user is good about it or whether the user is in a rush and forgets about it.