Option Button Description Table
Nov 13, 2007
Option Button Description table
I would like to create a table containing description value of my option button group.
This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6
And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552
How can I associate description with the selected options?
Many thanks,
Debbie
View Replies
ADVERTISEMENT
Dec 9, 2013
I want to make option button in access to allow user choose status like: Single, Married and Widower
Single
Married
Widower
When user choose the value must save into table. How to do this?
View 4 Replies
View Related
Sep 9, 2013
I have a combo box in a form that is used to populate one of the columns in a table. How do I get the description to appear in the table instead of the primary key?
View 3 Replies
View Related
Feb 20, 2015
My combo boxes are not returning the actual combo box values back to my table, instead in the table it is displaying the combo box data list number i.e 1,2,3,1,5,1 etc where it should be displaying a property address.
View 2 Replies
View Related
Feb 18, 2013
I am using Access 2010. I have many tables that are downloaded from SAP into Access.
Within each table structure are the following standard Access attributes: Field Name Data Type Description
When I create a query I add the Field Name from the table nothing earth shattering here. But, in addition or instead of Field Name, I want to use the Description attribute. Mostly because the SAP field names are acromyms in German and are useless to the untrained eye. Please see attachment as an example.
Is there a way either using VBA or some special SQL language in any query I write to show me the Description instead of or in addition to the Field Name?
View 1 Replies
View Related
Feb 10, 2014
I have 3 tables joined as attached and Im trying to use the PO from the PO_Detail table to display the Description from the Material_Req Table. The two values are linked as the description in the Material_Req Table is for the PO in the PO_Detail table but I just cant get the results to show this.
View 8 Replies
View Related
Apr 17, 2012
How to add a prefix to an existing description in a project table, generated from the project number. Here's a sample of my data:
PROJECT NUMBER DESCRIPTION
01200000 Completed Projects
01601530 Steele Sub
I would like the Descriptions to read:
01200000 MO-20 Completed Projects
01601530 MO-60 Steele Sub
The state, "MO," comes from the first two digits "01" and the coop, "60," comes from the second two digits. I have a table of a thousand or so projects in an Access database that I need to amend the descriptions of to include these prefixes. Is there a simple way to do this in Access or in Excel without writing code?
View 1 Replies
View Related
Feb 9, 2005
I was wondering if there is a way to export the Table Design Structure:
1) Field Name
2) Data Type
3) Description
Into a Spreadsheet.
I was able to do this a long time ago, but can't seem to remember. I'm using Access 2000.
Thanks!
Joe
View 3 Replies
View Related
Apr 30, 2015
I have a table I'm trying to query information out of. Key fields are below:
RecNo (Key)
ParentRecNo
Description
I need to have a "record" in the query show both the description of itself, as well as it's parent. I was hoping to use Dlookup directly in the query design. If there is no other way, I suppose I could create a temp table and look through the recordset in VBA and dump them into the temp table, but like I said; quick and dirty was the hope here, it's for my own use, and the tables aren't large 50-100 records is what I'll be pulling out when I use this.
View 1 Replies
View Related
Jun 6, 2005
Lets say that I have a large list of locations in a listbox. What I want to do is to be able to have an option button that I can press in that will sort these locations. Like 3 or 4 different buttons, lets say like retail, finance, ect. Anyone know what kind of code I might have to use to make these sort on clicking the option button?
View 4 Replies
View Related
Mar 23, 2006
I'm working on a survey database, I'm having the users select the opton button to rate (1 - 10). Then as an after thought, I thought I would add a button that says N/A or doesn't apply. Course option buttons store numbers.
ANy idea's on how to accomplish this? What ever value gets stored I wouldn't include it in the results.
View 1 Replies
View Related
May 30, 2006
Hi peeps,
I am encountering a few problems when I'm using the options button on a form.
Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair?
Also can a number of option buttons have the same control souce? at the mintue I have three buttons pointing at one control souce and when I select one of the buttons they all get selected.
Any help will be much appreciated.
View 14 Replies
View Related
Dec 7, 2006
I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add 4 option buttons, depending on what the user clicks on Opt1, 2, 3, or 4... that is what populates the combo boxs? This seems rather simple, but I can't figure it out.
View 1 Replies
View Related
Jan 24, 2006
Hello,
how do I reference the value of an option button in an option group?
i tried this:
Code:If [exact] = -1 Then where = where & " AND [SerialNumber] = " & Me![serialno] ElseIf [exact] = 0 Then where = where & " AND [SerialNumber] = " & Me![serialno] Else where = where & " AND [SerialNumber] Like '*" & Me![serialno] & "*'" End If
attached is an image of the form.
thanks
View 1 Replies
View Related
Feb 2, 2006
Hello,
Does anyone know how to unclick an option button on a form after a selection has been made?
One option is to go to the form and delete it there. But I am looking for a more effective way.
Thanks!
View 3 Replies
View Related
May 23, 2006
Hi,
I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank.
Any thoughts?
Thanks
View 2 Replies
View Related
Jun 14, 2006
Hi there guys,
I have set up a form that is going to be used as a survey.
I have 19 questions that need to be answered and have set up an option group for each question containing 5 option buttons in each.
Is there away to calculate a total score?
for example if all questions were answered using opt5 then the total in the textbox would appear '95'
Thanks for all your help!
View 7 Replies
View Related
Jun 28, 2006
Morning folks,
Todays problem is as follows!...
Is there away to set the values in a combo box depending on what option button you have selected.
What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?
So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other
If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...
Hope this makes sense.
View 1 Replies
View Related
Oct 11, 2004
On my form is an option button called "optClosed". When the option button is selected, I want to lock the current record so that data cannot be changed. Is this possible?
View 2 Replies
View Related
May 7, 2015
I have a form that is linked to a table. The form show an option box that is by default set to off. This option button links to a yes/no field in the table.
I want to allow a user to change the state of the option box from off (no/false) to on (yes/true), but once it is on, it should not allow the user to switch it off.
View 3 Replies
View Related
Aug 3, 2015
My frame name is "Frame1" with Option buttons "Circle" and "Square"; My code line : Name = me.Frame1.however "Name" get a value of 1 or 2 depending on the selection.how I can get a return of the String Values instead of the Numeric values.
View 3 Replies
View Related
Apr 25, 2013
I'm new to access. I have created table with following fields.
ID No, Name, Address, Gender, Favorite Food
I want to create form to insert data into tables. I have used option buttons for Gender and Check boxes for Favorite Food. But data didn't insert to the table specially option button and check boxes data didn't insert but other data successfully inserted into the table.
Database1.accdb
View 2 Replies
View Related
Sep 8, 2005
Alright, I'm running out of options!! I have several pieces of equipment that use text file configuration data. What I want to do is create an option button for each piece of equipment so that when I click that option button, its output ties directly to a memo box.
What I want to be able to do is have 7 different option buttons and each time I click a different option button I can paste text file config data for each piece of equipment into the same memo box and save it. That way, when I query a particular site ID and look up configuration data for any one of those pieces of equipment, I will be able to view the saved config files in the same memo box just by selecting a particular option button.
Is this possible? I've tried subforms, tabs (although I can't seem to be able to use tabs within tabs), option groups, etc. Any suggestions or help would be most certainly appreciated! :p
View 1 Replies
View Related
Aug 25, 2005
Hi,
On my form I have an option group with 4 radio buttons. Depending on the button selected certain fields become visible. This works all fine. Problem is though that I don't know how to store the selected value. At the moment, every time you open the form you have to select the same button to see the info stored in the fields that become visible. I guess that I'll have to somehow store the value for the selected buttons in the table. But How? Do I refer to the frame and store the value corresponding to the number of button (1, 2, 3 or 4) or do I store the balue for each button seperately?
I've played with it for too long now and cannot find the golden tip. Please advice.
Thanks,
Walt
View 5 Replies
View Related
Aug 17, 2004
Hi,
Asked this one yesterday but I think I must be doing somthing wrong. I have a main form named "Techdata" on this form I have an option group with 2 option buttons. I would like when selecting the first option button for the subform "effectivity" to show up on the main form. When the second button is selected I would like the subform "effectivity single" to show up in the same place where "effectivity" was(would like effectivity to be invisable then).
Can anyone walk me through this from whoa to go as Im havn a lil bitta trouble
Thanks for your time everyone
View 3 Replies
View Related
May 31, 2015
I'm using option group with value 1 and value 2 with a command button to open two different forms. This is the code:
Code:
Private Sub Command9_Click()
Dim strForm As String
Select Case Me.Cornice0
Case Is = 1
[Code] ....
I would like to close form's option group once clicked the command button after the opening of the requested value form. I tried Docmd.close but all I get is the option group no more working.
View 4 Replies
View Related
