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 Replies


ADVERTISEMENT

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 :: Plus / Minus Button For Any Numeric Box On Form

Oct 1, 2014

I'm working on a form that I want to insert a plus button/minus button.I am aware of the vba code numbers 107 and 109 if you want to use the actual keys but I would rather use a button.

I made a button and here is the code I used now. This code is numeric box specific. So it only adds one to the MileageStart numeric field. (Additionally you can put a minus in to subtract one).

Private Sub Command153_Click()
MileageStart = MileageStart + 1
End Sub

Instead of having a bunch of these buttons all over boxes on my form is there some code that I can use to "select" a text box and just have the Plus/Minus button on the form header that I would hit and it would add or subtract (and then I could go to another box select it and hit Plus/Minus and so forth).

View 7 Replies View Related

Forms :: How To Store Data From One Textbox Into Another On Button Click

Jul 2, 2014

In my form, when a button (cmdContactedToday) is clicked, a text field to the left (txtDateContacted) is updated with today's date.

However, before this happens, I want the the current date in txtDateContacted to get stored in another (hidden) text field (txtPreviousDate)

Then when another (undo) button (cmdUndoDate) is clicked, the date in txtDateContacted should get replaced with the date in txtPreviousDate.

I've made it as simple to understand as I could.

View 14 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

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

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

Combobox Store ID Not The Corresponding Value To The Table

Apr 17, 2012

I am newbie to access database, I have 2 tables namely business_unit(id,b_unit) and division(id(pk), bid(fk),division) . I have created 2 combo box in my form one for b_unit and another division, based on the selection of b_unit the related division will be loaded in division.

If i try to store the b_unit and division value from the form to the table called "training" it stores only both of the field ID's not its value.

I execute this query ,

Private Sub Command12_Click()
CurrentDb.Execute "INSERT INTO training(business_unit,division)" & _
"values(" & Me.business_unit & ",'" & Me.division & " ')"
End Sub

View 1 Replies View Related

Forms :: Sort Numeric In Alpha-numeric Text

Mar 11, 2014

I have a text field having data i-e HO-1, HO,2, ACW-25 and so on. The field name is nBadge_num and is Unique. The data in this field is sorted automatically like 1, 10, 11, 12, 13, 2, 3, 4, 5...because this is the text field.

The number on the form is automatically generated, when the user type HO- for example on field exit event. The last number will generate like HO-5.

Code for automatic number generation is:

Dim dbs As Database, rst As Recordset, Response
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("SELECT Max(Right([nBadge_Num],Len([nBadge_Num])-" & Len(Me.NBadge_Num) & ")) AS MaxNo " _

[Code]....

My problem is when the number is generated it give HO-5 instead of HO-14, How can I sort the numeric part of the field ?

View 2 Replies View Related

Forms :: Opening A Form Using Combobox And A Button

Oct 28, 2014

I'm having some trouble opening a group of forms using a combobox. I think I'm really close, but I'm having some errors that prevent me from doing so.

I have a Combobox called "Letter Type" that contains the names of all of the other forms that exist. I want to be able to select a form from the combobox and click on the button "Compose." This should then open that form.

I had some trouble trying to get the Combobox value to work properly so I decided I would just create a hard workaround by using If/Then statements.

This is what I have in the On_Click event of my button.

Private Sub Compose_Click()
If Me.Letter_Type = "Refund Request" Then
strForm = "Refund_Request"
ElseIf Me.Letter_Type = "Request for Records" Then
strForm = "Request_for_Records"
End If
DoCmd.OpenForm strForm, , , Me.[Reference_#] = Forms![Reference_#]
End Sub

The catch is that I want the form to only open with one record and I want that record to be the same record the user was viewing on the previous form. I thought I would tie them together using the "Reference #" since it is unique.

When I click on Compose I get a "type mismatch" on the Reference #, though I'm not sure why.

View 5 Replies View Related

Modules & VBA :: Code To Store PDF File Names In The Combobox?

Mar 11, 2014

I have a folder in which there are PDF files stored. Now in the Form, there is a combobox and I want the code so that when a Form is loaded then add all those PDF file names(only first 9 letters of that) in the combobox.

e.g if the PDF file name is ABCDE1990-YYY then add ABCDE1990 in the combobox. So if there 10 PDF files in the folder then add 10 names in the combobox.

View 5 Replies View Related

How To Use Option Button To Store Value Into Table

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

Option Group: How To Store Selected Button?

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

Option Button - Use Text Instead Of Numeric Value In My Query/report

Apr 26, 2007

Hello,
I am not sure what cateogory to choose for this question but I would greatly appreciate your help.

I have 5 buttons in my option group:
1. very often
2. often
3. occasionally
4. rarely
5. never

I have to produce a report using description of each button in my report, not numeric value. I heard something about global variable but I am not sure how to do it.

Many thanks,
Debbie

View 1 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

Forms :: Update Row-source Of Combobox Based On Value Selected On Another ComboBox?

Apr 26, 2015

I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.

Code:

Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub

But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?

View 5 Replies View Related

Hyperlink Button Linked To A Combobox

Jun 9, 2006

I have a button that, when clicked upon, I would like to hyperlink to one folder--the location of which being specified by a value the user selects from a combobox.

Example of what I would like to happen:
1)The user selects the Ship Name "AGER 2-Pueblo" from the combobox list.
2)The user clicks the "Go To Ship Folder" button to go to this ship's folder.
3)Access takes "AGER 2-Pueblo" from the combobox and tacks it on the end of the general address of "C:Documents and SettingsDesktopShip Stuff" so that the folder "C:Documents and SettingsDesktopShip StuffAGER 2-Pueblo" opens.

I tried searching for this...but found nothing except the application.followhyperlink code, which I can't get to do this. Can this be done? I would appreciate any help.

View 3 Replies View Related

Modules & VBA :: Button To Select First Item On Multiple Combobox

Feb 1, 2014

I have a contineous form with a combobox for each record and i have a button to select the first item in the combobox then to refresh the list in the combobox .I want to creat a one button to select the first item in the combobox then refresh the list then go to the next record and select the first item on the list

View 2 Replies View Related

One Query Cannot Store 2 Different Textbox In Different Forms

Nov 26, 2005

One Query cannot store 2 different textbox in different forms:
Query Name: rem

Form Name: QR
Form Name: Pro

Query parameter: Forms!QR!txtbox1
Forms!Pro!txtbox2

I tried it, it cannot run.
If you run the form "Pro" and run the query rem, then you will get the message:
Forms!QR!txtbox1?????

same thing if you run the form QR and the query rem

View 2 Replies View Related

Forms :: Store Lookup Value In Table

Sep 9, 2014

I have form with student details on it and I want to add some additional information against that student (stored in a seperate table). I've created a form to input the data and a button on the main form to open the new form.

On loading the form I've brought with it the name of the student but I also want the UPN. I've done all the above fine.

What I need to do is then store the UPN in a field in the new table which is where I'm stuck.

What do I put in the Control source to make it store it. Currently I just have

=[Forms]![PupilPremiumStudents]![txtUPN]

View 9 Replies View Related

Forms :: Add Two Fields And Store In Another Field

Apr 11, 2015

I have a form (frmFeeIncome) based on a table (tblFeeIncome)

On the form I have three fields which are FeesMonth, FeesYear, FeesUK (currency), FeesElsewhere (currency) and FeesTotal (currency). Each new record is entered like this

January 2015 25000 25000

What I need is for the total in the FeesUK field and FeesElsewhere field to be added up and stored in FeesTotal when FeesTotal has GotFocus

The FeesTotal has to be stored (I know it shouldn't be but it has to!)

I have tried the following in the GotFocus Event procedure but it does not work.

=[FeesUK] + [FeesElsewhere]

View 3 Replies View Related

Forms :: Format Numeric Field In Forms

Sep 25, 2013

I have a table (Table 1) with a field (F1) that has a numeric value. The data in this table is imported trough an excel and is going to be updated regularly.

F1 consists of a four digit number (1234) but if the first one, two or three numbers are a zero (ie. 0033) Access only display "33". I have solved this in Querys by using: Format([Table 1.[F1];"0000").How do i use Format([Table 1.[F1];"0000") or similar when i display data from Table 1 -> F1 in a form?

View 14 Replies View Related

Forms :: Buttons To Store Actions And Dates?

Apr 8, 2015

Suppose I need a database with customers, able to store: what different events, were performed on what date.

So let's say possible actions are: a customer called, emailed or visited.

(note, it might be possible that a customer both called, emailed and visited on the same day)

Should I start with four different tables for: customers, called, emailed, visited? Or would the three actions just go into one table?

Another aspect that I don't understand at all yet is how to proceed with the dates.

Should I create another table with a long list of possible dates for the coming x-years?

I would like it to work:

I am thinking about creating a form with buttons behind the terms 'called', 'emailed' and 'visited'. When one of those buttons is pressed, I want an entry for that action, day and customer entered in the database.

So that later on I could e.g. look up on what day how many customers called, etc. etc.

View 11 Replies View Related







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