Radio Buttons
Jul 30, 2005
I have a table and a form called patient demo. It displays last name first name and address city state zip. I created another table and form called insurance as radio buttons i have the following self, spouse, child, other. It also displays last name first name address, city, state and zip as text boxes. what i want the radio button to do is when i click self it will copy all information from patient demo to insurance form. I tried to do this several ways but every time i change the information in the insurance form it also changes the patient demo which i dont want it to do because i want to edit that box without changing patient demo. any ideas.
View Replies
ADVERTISEMENT
Oct 18, 2007
Hi all,
I'm somewhat new to access and I'm having a small problem. I have create a web based form via Frontpage 2003 using the access database wizard. In one part of my form I have 6 different options (radio buttons) for a user to select. I want the user to be able to select "multiple options" that apply not just one which is all it is doing right now. How do I change this to allow multiple selection? I opened up my results table and went into the design mode and I can't figure out where to allow multiple selections. Thank you for any help you can provide.
Mark
View 2 Replies
View Related
May 1, 2006
Hi all
Just found this forum, looks great!
When a control like a check box or radio button is on a form, how can you make the size of the actual control bigger? When changing the size in Properties, it only increases the size of the black border.
Thanks
Rich
View 1 Replies
View Related
Mar 10, 2006
I have a database with 1 main form. This form has a bunch of lookup tables that are being displayed in comboboxes on the form.
What I want to do is create another form that has a series of radio buttons that when selected show the specific lookup table which can then be updated/modifyed.
I am unsure where to start. When they select one button I need the table to open "sub form?", "List Box?", and then when they choose another table the first should close and the next open etc. I want all of this to be done within 1 Form.....
Any thoughts?
View 1 Replies
View Related
Feb 28, 2007
I 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
View 1 Replies
View Related
Sep 2, 2013
I'm trying to tick "Yes" to a radio button which are side by side on a web page (Yes and No). The HTML is below and the VBA I'm trying to use is:
ie.Document.all.Item("newsletter").Checked = "0"
I've also tried
ie.Document.all.Item("newsletter").Checked = "True"
ie.Document.all.Item("newsletter").value = "True"
ie.Document.all.Item("newsletter").value= "0"
<table class="form"> <tr> <td>Subscribe:</td>
<td> <input type="radio" name="newsletter" value="1" /> Yes
<input type="radio" name="newsletter" value="0" checked="checked" /> No
</td> </tr> </table> </div>
View 6 Replies
View Related
Feb 25, 2013
I'm trying to build a database of car dealers while using Access 2010. They only sell three types of cars. Once the user select which car dealer they want to look at, I hoping to populate three radio buttons based on values from the database. From what I've read, it seems that the radio button, while using the option group wizard, that the radio buttons are meant to populate a database field, rather than having the database record populate the radio button.
how to do this, so that I am able to show three radio buttons in my form to show which three types of cars this specific car dealer sells?
View 5 Replies
View Related
Apr 18, 2015
I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.
When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.
I realize the I will need some scripting here.
As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.
View 3 Replies
View Related
Aug 18, 2006
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.
View 3 Replies
View Related
May 30, 2005
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
View 2 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 2 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 4 Replies
View Related
Jun 26, 2006
I have four (4) radio Buttons and I want to join them in order when one radion is chosen the other three to be unmark and so on.
Thanks in advance
View 1 Replies
View Related
Sep 11, 2006
Hi i have done this before but can not remeber how i did this.
Basically i am doing a report function where users can choose which type of report they want to print- i am decided to use a radio button function so user have to click on the radio button to enable which report they want to view
(see pic) http://img153.imageshack.us/my.php?image=radiobuttonstu8.jpg
Can some1 help me with the code i need to use so when a user clicks on the radio button one combo box is enabled and the other is disabled
Many thanks in advance
View 3 Replies
View Related
Dec 13, 2004
How do you convert a combo box to a radio option?
I have made a table called level it has only one column and is only two values (udergrad and grad)
I have a form that sets requirements and in there I have the option to choose what level the requirement is on.
Instead of using a combo box for the level (with a select statement SELECT Level.LevelName FROM [Level]; )
I was wonder how I can conver the Level into two radio buttons one for undergrad the other for grad,
and depending on what was selected that value would be stored in the table.
thanks for any help
View 1 Replies
View Related
Sep 24, 2005
How to create a Radio Control Button that selects the records with the artists and names of artists for cd's and print a report based on those autoreport records?
View 1 Replies
View Related
Jun 25, 2014
I have a database I use at work for writing up non-conformance reports and we have 5 different dispositions(see picture) but when we run our report, they show up as numbers(1-5). I want to know how to get them to show up as text. I went into the main table and changed the "disposition" category to text and changed each button to show what text I wanted it to but for some reason it wont save. When I go back and click the radio button and bring up the properties, it reverts back to a number. I just want our dispositions to show up as the text(Use As Is, Rework, RTV, etc) instead of numbers when we run our monthly report.
View 6 Replies
View Related
Sep 29, 2006
I'm an Access newbie, self-taught. I can make a basic form to input data.
What I'm trying to create is a tool for assessing aquisition of student skills. I want to be able to check that a student knows the name of a letter or the sound of a letter - but have the check recorded as a date in the datasheet.
Is this possible? And, can you explain to me how to do this in language I can understand? I'm not a programmer you see
Thank you,
Amie
View 1 Replies
View Related
Jul 14, 2015
I can do this if there is one record: ie
Private Sub Form_Open(Cancel As Integer)
If Me.field1 ="DontShow" Then
Me.cmd_splt.Visible = True
Else
Me.cmd_splt.Visible = False
End If
End Sub
This creates a button that masks my radio button i.e. hides it. However this only works on single forms.
I need it to be different for each record in a continuous form.
I am putting the code in the "OnOpen" property. Maybe that's my problem?
I've also tried conditional formatting but it wont over-ride a transparent text box.
View 5 Replies
View Related
Feb 11, 2014
I would like to store the string in my table when I choose a string from a combobox or radio button in the form.For example, if I choose 'Business' ( from major field in my department table ) in my combobox, I expect there is a 'Business' in my major field in my department table. And if I click radio button labled 'A' (position field), I expect there will be 'A' in the position field in my table. However, those only store numeric values, for example '3' for 'Business' and '1' for 'A' in the table. How can I store the 'real value' in my table instead of number when I choose them.
View 3 Replies
View Related
Oct 6, 2005
Hello,
I'm interested to know how I can select a (1) student and assigns to multiple classes.
Attached I have the database with some tables and forms. Please take a look. I can assign a student to a class, on a specific day but I couldn't figure out how to select multiple classes at once.
Thank you for your generous help.
Isabel
View 10 Replies
View Related
Feb 21, 2005
i have constructed a switchboard/main menu and have set up buttons which link to forms. i have also made a 'return to main menu' button which does as it says, the only problem is that after going back to thge main menu both forms are now open...any ideas on how to stop this problem
View 12 Replies
View Related
Feb 22, 2005
how would i get a button to be able to delete a record that is present on screen?
any help would be brilliant :confused: :confused:
View 1 Replies
View Related
Mar 16, 2005
I have been making some custom buttons and noticed that the size of my db went up 360kb after I added two buttons. One button consists of two images and the other button one image. The original file size was 2kb for each image. Is 360kb a normal increase in db size after converting images to buttons?
There might be a hefty price to pay, in db size, if I get carried away and add my "up market" buttons to all my forms!
View 6 Replies
View Related
Dec 19, 2006
Hi everyone,
I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks. I would like to export to excel or anything that will capture what I am looking at. I have noticed that Yes/no boxes do not export to excel?
View 3 Replies
View Related
Feb 13, 2005
I have a form that's unbound (Music) with a subform (Arist Info)that is bound. This subform also contains two other Subforms (bound).
Their names are (Album Info) and (Song Info). The subform (artist Info) contains some pagebreaks, which I'm trying to use to bring up
the two other subforms .The cmd buttons used to control the pagebreaks are located on the main form (Music). My problem is with the third & fourth cmd buttons. I can go back & forth nicely with the first two, and even go the the third. That's were the problem starts. I can't go back to the secound or first from the third or go to the four. The VB code haults and the GoToPage line is highlighted. The code use on the on click event is as followed:
Forms!Music.SetFocus
Forms!Music![Artist Info].SetFocus
Me.GoToPage 1
The only thing that changes between all four of the is the page#. I hope someone can help me with this, it's driving me crazy not knowing what i'm doing wrong. If you need to look at a smaple DB there's one on a post called "Problem dealing with macros". I just posted this one a few days ago.
Thanks,
Rich M.
View 9 Replies
View Related