Populating The Text Box’s That Relate To The Chosen Combo Box’s With The Sum Of A Cal

Sep 29, 2005

Hi, I'm in the process of building a program in access 2003 for estimating roofs, I've ran into a little problem, as described below. any suggestions would be very useful

Populating the text box’s that relate to the chosen combo box’s with the sum of a calculation.

In other words if X combo box is chosen (There are many combo boxes to choose from) populate xx text box with the sum of a calculation.

Refer to the print screen example of my program: http://www.roofmart.net/Rest.asp

Notice under the label felts the 15lb 36” felt combo box is chosen and it displays the value of 11 and next to the combo box is a text box that displays the value of 25 The calculation will be (11*25) = 275 this value of 275 must be added to the text box values that are being shown in the forms header under 30yr where it reads $4,606.80 and 40 yr $6002.80 only, this is because the 30yr comp and the 40 yr comp combo boxes are the only chosen roof types under the label roof types above the felt label.
Hopefully this makes sense.
Thanks -- Any help with be greatly appreciated.

View Replies


ADVERTISEMENT

Forms :: Setting Text Box Value According To Chosen Combo Box Value

Feb 7, 2015

I have a form that adds a record to a table in the database.I want that when i choose a value from a combobox in the form, it will change the value of another textbox according to what value was choosed.So essentially what i did is simply go to the combobox AfterUpdate and there i used this code:

If Me.Combobox.Text = "Solid" Then
Me.TextBox1.Text = "grams"
ElseIf Me.Combobox.Text = "Liquid" Then
Me.TextBox1.Text = "ml"
End If

But i encounter 2 problems:

1. When i set a default value to the textbox (which i want to), the changing of the value in the combobox doesn't do anything whatsoever.
2. When i remove any default value from the textbox, the changing of the value in the combobox does change the textbox to the corresponding value but then gives run-time error 2185: "You can't reference a property or method for a control unless the control has the focus".

View 2 Replies View Related

Populating Page Based On Item Chosen

Jun 20, 2014

What i am try to do is have specific text boxes or items appear on the form depending on the combobox item you have chosen.

For Example

Combobox

CAR
CAKE RECEIPE
CLOTHING

if car is chosen 2 text boxes appear example car manufacturer, Car name. If Cake recipe is chosen a larger text box appears, if Clothing is chosen another combo box appears and gives you more options.

View 5 Replies View Related

Combo Box Populating Text Fields

Jul 19, 2006

Hi All

Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box.

I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the requirements (memo).

I have put in the after update code:

Private Sub CustName_AfterUpdate()

Me!CustReq = Me![CustName].Column(2)

End Sub

Can anyone please shed light on what I'm doing wrong?

Thanks

View 3 Replies View Related

Combo Selection Populating A Text Box

Nov 13, 2006

Probably an easy one here...I have a series of cascading combo boxes where once the last once it chosen, I'd like some sales info to populate in a group of text boxes. What command would I use for this?

Also, I have a checkbox that I'd like to use to either enable or disable a textbox as well. Any ideas?

Thanks!

View 12 Replies View Related

Populating A Text Box Using Combo Box Filter

Nov 18, 2004

Hello,
This is my first time posting here and I hope someone can help me. I am not experienced with coding in access and only recently started using forms.

I am trying to create a text box that automaticly fills in once a selection is made in a combo box.

There are only 2 tables and 1 form I am working with. Table 1 has columns "code" and "bu". The second table has several columns, all blank, that the form fills in.

The combo box is working correctly, it displays all the "code"s. Once the code is selected I would like a text box to display the "bu" column.

Any suggestions are much appreciated.

View 4 Replies View Related

Populating A Text Field From A Combo Box Selection.

Apr 28, 2005

I have a combo where the list is populated with a bit of VB code to create a two field list. When the user selects the item they want from the list it displays the item in the combo box and should populate a text box in the same row with the value from the second column.

This combo is part of an orders subform and the user is selecting a product from the list which displays the product_name and the product_id.

The problem is that the product_id is not filled in and access returns the following error:
Run-time error ‘3101’:
The Microsoft Jet database cannot find a record in the table ‘product_table’ with key matching field(s) product_id.

This is the VB code that populates the list :
[code]
Private Sub comboCatagory_ID_AfterUpdate()
Dim sProd_description As String
sProd_description = "SELECT products_table.product_id, products_table.prod_description " & _
"FROM products_table " & _
"WHERE products_table.prod_catagoryID = " & "'" & Me.comboCatagory_ID.Column(0)
Me.comboProd_description.RowSource = sProd_description
Me.comboProd_description.Requery
End Sub
[end code]

What am I doing wrong?

Thx
Kev.

View 5 Replies View Related

Forms :: Populating Combo Box Based On Text Box

Nov 19, 2013

I have a text box that displays a name of a law from one table, based on that law name I want to populate a combo box with different options on how to comply with that law that come from a different table. The compliance options I need to pull in are different for each law. Finally I would like to have the selected option saved in the table the laws are coming from.

I have tried using a rowsource query [Form]![form1]![Law] for the combo box of law options but keep getting errors.

View 3 Replies View Related

Filtering With 2 Combo Boxes And Then Populating Text/memo Fields

Dec 14, 2004

I have two questions.
I have a form with 2 combo boxes. The first pulls from a simple list. Once you make a choice, the second combo box is then filtered by the first. This works correct, except that once a choice is made in the first, the filter is locked. If you change the first combo box's value a second time it does not effect the second box. The query that I am using for the second combo box has two columns that pull the first 50 characters of a pair of memo fields. Quote: SELECT MSSS.SS_ID, Left([Application_Name],50) AS Expr1, Left([Description],50) AS Expr2, MSSS.Site_Code
FROM MSSS
WHERE (((MSSS.Site_Code)=[Forms]![Edit or Delete Requests]![Combo6])); These fields are then used to populate 2 text fields using an event procedure. Quote: Private Sub Combo10_AfterUpdate()
' Display Partial Application Name and Description based on choice
Me!txtApplication_Name = Me!Combo10.Column(1)
Me!txtDescription = Me!Combo10.Column(2)
End Sub This is working fine, but it starts the next problem.

I need to change the form to include the entire memo field into a text box. I was using the columns of the second combo box to fill them in. Since the combo box is limited to only 50 characters, i could only grab part of it. I am guessing there is a much better way to accomplish what I need, but I am too inexperienced with forms and vb to come up with it. Below are the fields I need from table MSSS
Business_Name
Application_Name
Description
Acronym
Level_1_Support
Level_2_Support
Escalation_process
Troubleshooting
Priority
Links
Modified
Disabled

Thanks in advance to any help!

View 5 Replies View Related

Forms :: Populating Text Box Upon Selecting Multiple Items In Combo Box?

Nov 28, 2014

Now I have a combo box "cbo_items" and a text box "txt_selectedItems", I want to populate text field with items selected from the combo box, every time i select an item it appears in text box and to be separated with comma, so text box appears like this ( item1, item2, item3), and after finishing the whole thing the result appears in lable "lbl_result" as "total items selected: 3 items".

View 1 Replies View Related

Forms :: Populating Text Box Based On Combo Box - Separate Form

Aug 14, 2015

The main issue I'm having is trying to populate a text box based on a combo box selection. I've found threads on that - the twist that is throwing me for a loop is that I'm dealing with two different forms.

I have a main/welcome form with two combo boxes on it. Based on the user's selections in these two combo boxes, two different forms are opened for data entry. For instance, box 1 has A, B, C and box 2 has x, y, z. If a user chooses B and z, then form B and form z are opened. What I want is for a text box to be populated on one of the opened forms, not the same (main/welcome) form. In other words, when B and z are chosen, I would like there to be a textbox autofilled with "z" on form z.

View 2 Replies View Related

How Do I Display Certain Records Depending On The Option Chosen In A Combo Box

Aug 2, 2005

Hi I'm a real newbie at this but basically I have a form displaying three lots of contacts Expediting, Quotation & Miscellaneous contacts.After choosing the company name from a list box it displays the Expediting, Quotation & Miscellaneous contacts info - but doing it this way there isnt much space on the screen to show all the Contact names,Telephone fax & email addresses clearly& at a decent size.Apart from the company list box I want to have a list box/combo box with:

Expediting
Quotation
Miscellaneous

and then after choosing Expediting, Quotation or Miscellaneous from the list/combobox i want it to take the relevant data from the Expediting, Quotation, or Miscellaneous contacts sections and only display the information relating to those sections only, therefore allowing me to have bigger text and not so cramped display so everyone can read it ok and get more info on the screen for each contact group.

If anyone could help it would be much appreciated!!!! Thankyou in advance for any help. Be gentle with me I am a newbie,lol.

Thanks again

View 2 Replies View Related

Populating Combo Box Based On Data In Another Combo Box

Jan 23, 2006

Hi all!

It's been a while since I've used Access, and I seem to have forgotten this.

I have a form which allows entry of Borrower's details. I have 2 combo boxes on the form.

They are:

cboBorrName
cboLoanSN

Once the user selects the name from the cboBorrName, I want the cboLoanSN to display all loans associated with the Borrower so that they can select the correct loan and add repayment details accordingly.

I have added the following SQL statement as the record source of cboLoanSN

Code:SELECT * from tblBorrower WHERE tblBorrower.fldLoanSN=[Forms]![frmBorrower]![cboBorrName]

I have also added the following code in the After Update event of cboBorrName

Code:Me.cboLoanSN.Requery

However, it doesn't work.

Can someone please help me out?

Thanks a bunch!

View 6 Replies View Related

Populating A Combo Box

Nov 23, 2005

On my form i have a list which takes information from a table. I have set column headers to "on". What i want to do is populate my combo box with the column heads in my list box. Anyone have any ideas?

Cheers,
Matt

View 1 Replies View Related

Populating A Text Box

Mar 30, 2006

Hi guys ( and girls)


Ok so Im a noob but I have a problem with populating textboxes

This is basicly the code

' dim some variables
Dim var1(10)
Dim var2(10)
Dim var3(10)
Dim var4(1000)

w = 290
y = 0
For x = 1 To 10
y = y + 1
w = w + 1
var3(x) = y

' set focus and get some data

Set ctl = Combo277
var0 = IIf(Nz(ctl.Value) = "", "", [Combo277])
var1(x) = DLookup(var3(x), "variable type", "[machine] = [machine]")

' compair the data and do some more stuff

If var1(x) = "" Then var2(y) = ""
If var1(x) = "1" Then var2(y) = "Set"
If var1(x) = "2" Then var2(y) = "Act"
If var1(x) = "3" Then var2(y) = "Prod"

' this is where I am having trouble- var 4(w) holds the name of the text box that I wish to use on my form
' and var2(y) holds the data I wish to place in the text box
' so how can I tell the code that the data in var4(w) ,290 for example, is actually a textbox name instead of
' just a numeric variable??


var4(w) = var2(y)

Next x


So any help would be excepted with blind thankx


Tankx in advance Chris

View 1 Replies View Related

Text Box Not Populating

Mar 16, 2005

Dear All:

Code:

Private Sub text458_AferUpdate()
If Graduation_date = 2/1/2005 Then

TEXT_GRADUATION_DATE = "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."

End Sub

The Graduation_date is a combobox where the dates are selected. In a textbox titled "TEXT_GRADUATION_DATE", it should return "DATED AT THE CITY OF NEW YORK THIS FIRST DAY OF FEBRUARY TWO THOUSAND FIVE."

This text box is blank.

Any ideas on how to fix this?

Many thanks in advance,

Dion

View 5 Replies View Related

Populating A Combo Box In A Sub-form

May 8, 2007

Good day,

I have a main form with project data and a sub form that has related financial information. Once the user selects a particular project from the ProjectType drop down box, a field called Project Codes in the subform should be populated with only project codes for that particular Project Type.

Can someone assist?

Thanks

View 5 Replies View Related

Populating Combo Box With Last 5 Entries

Apr 8, 2005

Nubie question ( first real database)

I'm trying to populate a combo box with the last few entries of a record. I've been looking on SQL Queries and can see a way of using SELECT TOP on the recordset but querying/sorting the whole record every time seems a very clumsey way of doing it (especialy if the recordset gets large).
So is there a more elegant way of getting lastrecord,lastrecord-1,lastrecord-2, etc into my combobox ?.

Note as a suplemental question is there a way of a subform showing records from last to first instead of what seems to be normaly first to last?

Thanks for any help.

View 4 Replies View Related

Populating Text Boxes

Aug 13, 2006

I have a list box and three text boxes on a form. the list box contains data about an individual.

I want to be able to select a certai individual and populate the text boxes with info from the list box

any ideas on how i go about doing this?

View 1 Replies View Related

Populating Text Boxes

Aug 17, 2006

I have text boxes in a form displayed in a continous form with rows and columns. For ex. I populated textbox in column1, then edit some textboxes in column1. Once I go the column2 to populated textbox in column2, textbox1 is default to its orginal data, it doesn't hold the data I made changed to.

View 1 Replies View Related

Populating An Editable Text Box

Sep 22, 2004

I have a complex problem:
I have a form that displays the result of a query in a listbox (lst_dp_results).

Upon selecting a result in the listbox other data about the selected record is displayed on the same form in listboxes
Code:Private Sub lst_dp_results_AfterUpdate() With Me.lst_dp_productname .RowSource = _ "Select M_Paint.Product_Name FROM M_Paint " & _ "WHERE M_Paint.Catalogue_Code = '" & Me.lst_dp_results & "'"End Sub
As all these fields are listboxes displaying a single value based on the "rowsource" string, they are not editable.

I will like to have these as textboxes instead of list boxes but I guess textboxes do not have anything like 'rowsource'...

Can anyone suggest some method to display value from a field in a textboxt AND be able to edit it??

View 1 Replies View Related

Populating Text Boxes

Mar 23, 2007

I have a text box that I'd like to update from a table like a combo box. I text box is for a order type depending on the order type there can be a sub order type. How I would like to handle this is to have the list box with the primary order types and after the user chooses a primary they can type a semicolon and are given a list of sub order types. Is this possible?

View 1 Replies View Related

Forms :: Text Box Not Populating

Jul 31, 2014

I am new to access but I am creating a form on access 2010 for a Pass Request. On the form so far I have two cascading combo boxes that work great so far. The problem is that once a name is selected from the second combo box(cboFullNames) I want a textbox underneath to populate(txtOrg). I have tried using requery and refresh but it never works. The only thing that seems to pull up the information is pressing the refresh button.

View 14 Replies View Related

Problems Populating A Textbox From A Combo Box

Jan 5, 2007

I'm really hoping someone can help me, as I'm about ready to tear my hair out at the moment!!!

After a few problems, I've managed to set up a subform with three cascading combo boxes (i.e. "Family", "Order", "Common species name"). However I want a fourth field (a textbox: "Latin species name") to update automatically when the value of common species name is selected, so that the appropriate Latin name appears in the textbox at the same time.

Subsequently, in the afterupdate event of the "Common species name" combo box, I put the code:

Me.Latin_Name = Me.Common_Name.Column(2)

(Where Common_Name.Column(2) is obviously the field containing the value for Latin species name.)

Which seemed to work fine.... for the first record at least!

The problem comes when I try to add a new record to the subform - and instead of resetting, the "Latin species name" value entered in the first record also carries over to all subsequent records.... and changing the value in any later record simply also changes it in the first (and all other) records.

Can anyone work out what I'm doing wrong here? Any help will be much appreciated!

View 6 Replies View Related

Values In Combo Box Not Populating On Some Computers

Feb 4, 2008

Hi,

Hopefully this is a really simple requiring a simple answer.... hopefully

On one of my forms I have a combo box thats values are generated by a parameter query. On my computer and a couple of others i tested it (on the same network) this combo box populates fine, but i put it on a couple of other computers today and it doesn't show any values. I checked and the query itself runs fine, plus a combo box that runs off a table populates fine.

not too sure if its relative but the database is split with the tables sitting on the network share and the database sitting on the main computer. or perhaps this could have something to do with blocking unsafe expressions.. i am not sure

any help on this would be greatly greatly appreciated

View 8 Replies View Related

Populating Combo Box With Certain Select Queries

Jan 7, 2008

I have a form that has a combo box that contains every query in my database. This worked fine until i started having to create cascading queries to return the data I want. How can i populate my combo box with only certain queries in my database.

This is the code I was using to put all queries into my combobox.

FROM MSysObjects
WHERE MSysObjects.Name NOT LIKE "~*" AND
MSysObjects.Type = 5
ORDER BY MSysObjects.Name;

Upon clicking a button or clickin the query in the list, I want the query to run......So the main question is how to I include certain queries in my combo box but not all of them? I do not know SQL or any programming, so as specific as possible will help immensely. Thank you everybody.

View 1 Replies View Related







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