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

Radio Buttons

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

Re-sizing Check Box, Radio Buttons, Etc.

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

Radio Buttons And List Boxes

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

Radio Buttons And Option Group

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

Modules & VBA :: IE Automation - Radio Buttons (Tick Yes)

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

Populate Radio Buttons From Database Record?

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

Forms :: Database For Medical Facility - Admit And Discharge Radio Buttons

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

Blank Option (radio) Buttons In Option Group

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

Round Buttons Or Oval Buttons Instead Of The Normal Square Buttons

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

Change Colour Of Navigation Buttons And Command Buttons?

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

Change Colour Of Navigation Buttons And Command Buttons?

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

Join Radio Button

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

Enabling Textboxs With Radio Button

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

Convert A Combo Box To A Radio Option

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

Auto Report Radio Control Button

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

Getting Radio Button To Display Text In A Report

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

Check Box Or Radio Button That Records Date In Datasheet?

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

Forms :: Visible Radio Button Based On Field

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

Forms :: Do Combobox And Radio Button Store Only Numeric Value

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

Register Multiple Classes For A Student (form, Combobox, Checkbox, Radio, Listbox)

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

Buttons

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

More Buttons

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

Buttons & Kb's

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

Buttons

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

Cmd Buttons

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







Copyrights 2005-15 www.BigResource.com, All rights reserved