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
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?
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.
I was just wondering if it is difficult to enable a cmd button when a text box has been filled in. I have a button that allows users to add a file which displays the filepath in a text box. So what I wanted to do was when the path appears in the text box then this will enable the button. I thought that It may have been something like
Private Sub FilePath_Change() cmdOpen.Enabled = True End Sub
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
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.
Hi, I have a form called Product Details Display Form, which is for Product Details Display table. This form contains a button "Done" which saves everything into the table, or in other words, bounds the unbounded textboxes to the table. Basically, I want this button to be disabled at the begining, when the form loads, and when the user enters ALL the fields, it becomes enabled. Here is the code I have at the moment: Private Sub Form_DataChange(ByVal Reason As Long) If Me.Product_Brand = Null Or Me.Product_Code = Null Or Me.Product_Name = Null Or Me.List34 = Null Or Me.Price = Null Or Me.Details = Null Or Me.Discount = Null Or Me.Combo0 = Null Or Me.Combo2 = Null Then Me.Command36.Enabled = False Else Me.Command36.Enabled = True End If End Sub
I also have Me.Command36.Enabled = False in the Form-Load. I dont really know if it has to be in Private Sub Form_DataChange or not.
I have two text boxes and a check box - so the user can enter (1) patient weight, (2) patient height and then check whether the patient is male or female. The first two are then used to calculate a Body Mass Index. (simple enough and works OK). What I then want to do is have four command buttons that become visible when the calculation is within a certain range. So - simplistically- if the calculation (calctxtbox) is between 0 and 5 AND the patient is female then the command button called "normal"(Command79) is enabled. My VB code writing is improving (thanks largely to this forum!) but still very basic - can some-one help please?
Do I put my code in the "after update" event of the calctxtbox?
Private Sub calctxtbox_AfterUpdate() If calctxtbox > 0 (How do I say and <5) and then how do I say Female =Yes Then Command79.Enabled = True End Sub Am I close? Also can you enable labels and text boxes or just buttons.
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.
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.
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.
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.
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.....
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?
I'm by no means an expert when it comes to using access and its many controls that are avaliable to use on forms. Thats why I've come here to seek your help.
I have a database that has been created by someone who has now left the company and it needs a little work done to it.
The ideal thing we would like to get working on form, is that we would like a number of options to be greyed out and only accessable when another option is ticked.
I'm not sure how to group these options together, nor an I sure how make them active only when an specific tick box is ticked. Any help would greatly appreciated on this matter.
Working in the theatreworld, I'm trying to create something which will usefully combine my contacts and also a database of which shows we have done (dates, actors involved etc, etc) and what shows we have bought in.
So far, I have created my form which has the usual fields (name, address and so on) and also a field which asks users to describe what type of contact they are ie. are they an actor, or a director, or a theatre company. There are also two command buttons, which will either open up another form which lists all the productions they have been in with us over the years (In-house productions), or one that opens up another form which lists what shows each theatre company has brought to us.
I would like to be able to select 'actor' in the category field which will then enable the command button for me to see what productions that person has been in. Or if I selected the 'theatre company' category then the other button becomes enabled.
Can anybody advise me on this please? Alternatively, if this all sounds far too convoluted, then I am open to suggestions!
I have code set up to disable a textbox by clicking on it (Yes, that right, I want the textbox disabled as soon as it is clicked on) with Me.Txt.enabled = false during the _onClick Event. However, the with which I am working has 500 textboxes. Is there a way to call a function or something that would disable just the textbox that is clicked on?
I want a form to default open in read only mode to avoid users deleting info. I want them to be able to edit the form by pressing a button. Does anyone know the VB code to run from a command button to do this.
Private Sub Form_Current() If Date = Null Then Forms!getorder![Orders].Form.ProductID.Enabled = True Else Forms!getorder![Orders].Form.ProductID.Enabled = False End If
End Sub
getorder is a Form Orders is a Subforms
i want to do something that if i didn't entered a text in a date field hole subforms or Product id will be Disable
but if any texts enterd in Date Field it will be Enabled
hi, there is this form i want to create which uses a drop down list.... i want to be able to auto enable and disable selective fields upon selecting one of the choices.
e.g. in a drop down list containing: choice 1, choice 2 and choice 3
and there are the fields field no. 1, field no. 2 and field no.3
If i select Choice 1 --> field no. 1 get enabled and the other 2 gets disable... so on and so forth....
Hi, I have a field in a form that says when you are able to book a certain event, and i want the field in which the event can be booked, to remain unable to be edited until the tick box says yes. Is that possible?
I have just finished a DB in access, so I went into options and disabled all menus and shortcuts (I wanted to make it foolproof, this DB is for my mum!).
Anyway, it turns out that I wasn’t completely finished, and now I want to make a change to the DB. How can I do this?
Please view the screenshot, it shows which menus are/aren't enabled. I have explored all of the menus and I cant think of anything.