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.
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".
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.
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?
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?
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.
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]
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.
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
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".
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.
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.
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
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?
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??
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."
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.
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?
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.
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??
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?
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.
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!
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
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.
