I'm pretty new to this type of programming and i was hoping for a little help,
I have completed the majority of my program it's just a few little things i need to tweak.
The main thing is that i am trying to get a text box to autofill from a selection in a combo box i.e.
i have selected a drop down box with 3 coloums looked up from another table i would like 1 of the columns to stay in the combo box after selection and the other two to appear in the text boxes on the same page.
I set up an Access database to track visiting families. Each person in a family is inserted as a seperate row in my table. The table has the following columns: Visitor # (which is an auto #), Head of household, last name, first name, phone, email, address and etc.
The first person I enter when a family visits is the head of the household. I set up a quiery with a pull down combo box in my form so when I enter a new entry I can select a head of the houshold to assign each person to. Since I put the head of the household in first. I can then select that head of the household (this way I can track each family member seperate but still know they belong to the same family). So if we have a family visit that has a husband, wife and a child. There are three entries each having a head of the household as the same. When I use the query to select the head of the household in the combo box I would like the information that is the same as the original "head of the household" entry (address and phone #) to be automacially filled in from the husband's initial entry.
How can I do this? I read some other post with some VB in them like "Me.TextBox = ComboBox1.Column(3)" but I don't understand the syntax too well since I'm new at this.
I have dependent combo boxes which is working fine what i want is to select the value from the list and the text box should be filled in my case it is attachment field i want to fill up the value based on combo boxes selection.I have attached the database also.
GOAL: select the IC number from the combo box and have 5 text boxes auto fill.
I have a table made for the IC number drop down. The columns represent the fields that need to be auto filled.
Making some kind of query to link the combo box entry to the text boxes? Some VBA where the control source is equal to my query? I have tried changing the text box control source to equal columns from my drop down but that did not work.
NOTE: the blue font in the first image represents the text boxes that need to auto fill when I select the IC number from the drop down. The second image is my table from which my combo box is generated. The acronyms are for the two tests on this form.
I am trying to populate multiple text boxes from combo box using one table. First text box is getting populate on base of combo box value while 2nd text box is not getting populating.
I have used the following to populate the text boxes, even row count is correct, But why is not 2nd text box is not populating ?
=[Combo2].[Column](1) =[Combo2].[Column](2)
One thing I noted when I provide the control source then selection gets stop from combo box...I am giving the valid control source is customerID but its not working.Could it be the reason ? Why selection gets stop from combo box when provide the control source ? If remove the control source then 1st text box is getting filled on basis of combo selection and 2nd text box value is not getting filled as describe above.
I have two tables: tblWeightTickets and tblWasteType.
I want to create a form: frmWeightTickets, where a user can enter information and the data is stored in tblWeightTickets.
There are two fields in particular that I am working on ... "WasteType" and "Rate".
On the form, I want "WasteType" to be a combobox "cboWasteType" and when I select a type of waste I want the "Rate" textbox on the same form to auto populate with the rate amount for that particular type of waste (i.e. recycling, garbage, etc).
The Rate amount is located in the table: tblWasteType under the field name "Rate". How can I do this and at the same time store the information in the tblWeightTickets? I already have the combo box loaded with the types of waste - I just need it to populate the rate text box and store it in the Weight Tickets table.
So, I have a form and I need it so that when one field is selescted, the other 2 auto fill based on my selection. The form is based off of a Table, "TblClient" and The fields are ClientID (PK), InventoryType, Policy, and DueDate.
I want the user to type in the ClientID, and then once they select InventoryType, Policy and DueDate are autofilled. I have another table, "TblData" that has the data for InventoryType and the coresponding Policy and DueDate associated with each one. So far, I have a combobox for InvnentoryType with a query for rowsource for InventoryType with the width of these additional columns to zero so they are not displayed in the combo. Then, I added unbound text boxes to my form (one for each additional field) and in the Control Source of those text boxes I put:
In the first unbound text box;
=[InventoyType].Column(2)
This worked for me, but now I realize that I want to give it the option that once these are autopopulated, they can be edited. For example, the policy most of the time is exactly the same for a certain inventory type, but sometimes, a word or two needs to be changed. Is this possible?
Hi, I've been working on a database to keep track of employee time off, It consists of the main table, a employee table, and a department table.
I had a form that our admin uses to enter the info for each employee.
They would select the name of the employee from a drop down, and then select the department that employee is in from another drop down. then they would select the days off and reason ect. Then when finished they would hit submit and this would be entered into the main table.
Well they just asked if it would be possible to make it so when they enter the employee's name, that the department would automatically be filled in for the employee.
Is this possible? I'm trying to think of how to do it, but not coming up with anything.
In my database I have a table of customers and a table of orders (where many customers have more than one order, so the primary keys for each table are customerID and orderID).
I am new to Acces programming and have been tasked with making a database for work. I is a very simple database. What I need it to do though that I can't figure out is. Once the table is populated with information I want the user to be able to select a record from my combo box and then all the rest of the information from the record will automatically display in the correct text field so any changes can be made to it. So I have say Combo Box John Smith and when he is selected I want text field DOB to automatically fill with 01/01/1960 as that is what was put in there when he was first entered.
I'm a novice when it comes to Access 2010, and I'm having trouble with DLookup syntax, and am going nuts. I have tblLookup, tblFees and Costs, and frmFees and Costs. All data entry is done in frmFees and Costs.
The tblLookup lists plaintiffs and the matter related to them. In the form, I made a combo box [Combo13] for plaintiffs and a text box for Matter [Matter], but whenever I enter the plaintiff, I get an error.
The error is: Run-time error '3075': Syntax error (comma) in query expression '[PlaintiffName]=The Plaintiff I Typed in'
The code I'm trying to use:
Private Sub Combo13_AfterUpdate() Me.Matter = DLookup ("[Matter]", "tblLookup", "[PlaintiffName] =" & Me.Combo13) End Sub
[PlaintiffName] is the column name in the tblLookup.
I looked around the forums but couldn't find anything that matched my setup.
I have a combobox on an unbound form. After making a selection, I click a command button which opens a bound form to a new record. What I need to code next or add into the macro, is for the selection of the combobox to fill in the contact id, and contact name in the correct text boxes.
The combobox row source is: SELECT qryPBS.ConID, qryPBS.PBSName FROM qryPBS; bound column 1.
I have five textboxes for husband with the values typed(HustxtAddress1, HustxtAddress2, HustxtCity, HustxtState, HustxtZip). I have five more textboxes for wife. I have a combo box asking whether the spouse's address is same as the husband - with yes or no. If "Yes" is selected, the text boxes for wife is auto filled with the same values of the husband. I tried with combo box change event setting HustxtAddress1= WifeText address1, it fills only the first field and other fields are empty.
is there a way to have a form set to either auto populate fields based on the FIRST FIELD? For example: if the user type in the STUDY ID, the other fields like (first name, last name etc..) are auto-populated/auto-filled? and if the STUDY ID is new and not in the table, then the users simply fill in all the fields/complete the form and save? And I would also like a message box to show when I am typing the STUDY ID that would say something like: this person is on the system already. Click YES for this person and NO to add the user?...
My problem is I have two tables. One of the tables was made specifically to draw information from to populate the second table. The second table has a combo box that draws information from one of the fields from the first table. What I am hoping to do though is have each selection from the combo box in the second table to draw different information from another field in the first table and use that data to populate another field in the second table.
Simplified: Combo box in Field (1) on table two has multiple selections that I want to autofill the data in Field (2) on table two based upon the selection of the combo box. Data from both fields in table two would come from two different fields from table one.
I have tried to work with the After Update button in the After Events section on the ribbon at the top; however, I am simply lousy with coding. Is there an easier way to do it other than using that option?
I have created a form based off of one table. I have added an unbound combo box so a user can select a department's number and would like department name and accountable officer to auto pop/fill based on the dept number selection. I'm not sure what I need to put in the "After Update" in the properties in order for this to work.
I have a combo box that autofills a text box, this has duplicate values and I want to fill the text box based on the selection of the combo box.
Let me explain:The combobox is Suburb, the text box is for Postcode, the data has multiple matches for example FRANKLIN has a postcode match of 2913 in ACT and also 7113 in TAS.
From the combo box I select the record that matches 7113 but 2913 enters into the text box.
This is my code: In Row source of the combo box I have - SELECT [Australian Postcodes].Locality, [Australian Postcodes].Pcode, [Australian Postcodes].State FROM [Australian Postcodes];
In Event on change I have -
Private Sub Suburb_Change() Me.Postcode = Me.Suburb.Column(1) End Sub
how to change this to be based on the selected record from the combo box?
I just learned about Access 2007 since two days ago. I was assigned to do a database on the competency test records for my company.
I currently have 2 tables: tblCompetencyRecord and tblSections.
In tblSections, I have sectionname and sectionhead. PK is the sectionname.
I created a form from tblCompetencyRecord.
I have employee name, employee number, position, section, section head, test period, status and remarks on my form (like wise in my tblCR).
Now, I want to get Section field (combo box) to auto fill the Section Head field. I've searched high n low (i think), but i just couldn't figure it out.
I am trying to auto-fill address info from a combo field. I'm using a select query on a table for the information. It appears to work for the first field (Firm Address1), but then stops working on all the other fields.
1) How to auto fill in a text box if you select a value from the last of 4 cascade comboboxes.
I have 4 comboboxes where
1 = Apparaat - cboApparaat 2 = Type - cboType 3 = OS - cboOS 4 = Probleem - cboProbleem
With all 4 comboboxes I have the vba code Me.cbo[name combobox].Requery
If I select the last combobox, cboProbeem. I want the textbox underneath to automaticly fill in the solution of that problem. I already tried to use the following vba code
Me.Oplossing = Me.cboProbleem.Column(5)
But it does not work.
2) I want to make a form for customers, where I can fill in customer info, device info and date when there contract started. Now I want to use SUM to fill in the end date of there contract.
I'm looking for a way to have a text box auto fill based on the selection of a combo box on the same form. I cannot use the method i find all over the internet of using multiple columns in the combo box and basing the text box on that because the combo box already has multiple columns being used to determine its own possibilities and other combo box possibilities.
I would really just like the text box to work like this, but im still kinda inexperienced in VBA...
If combo box is "F004-001", then text box is "237" If combo box is "F004-003", then text box is "280"
I know how to add in an "after update" thing, but i do not know how to do If/then statements.
I am trying to build a form in the MoldReq section so when the user selects the mold number(combo box) it will auto populate the Part_Name and Part_No fields by pulling the data from the Molds table.
I have tried following this video where I create a change event:
Code: Private Sub cboCombo31_Change() Me.txtPart_Name.Value = Me.cboMold_No.Column(3) Me.txtPart_No.Value = Me.cboMold_No.Column(4) End Sub
I have a table called Auction, it has three fields, seller, iid, and start_time.
I made a combo box on a forum and in the I have a query,
My question is, I have a few combo box, can I have a user select a seller, but it will automatically populate in the same row, the iid and start_time for this seller?
How do I do this, I can't have separate combo box and have user select for each seller, iid and start time because it wouldn't match it to that seller on the same row.
I have a Table (tblFPAData) that is being populated with entries from a form I created. There are several fields but if I can get an answer for one relationship then I can repeat it for the others.
In tblFPAData there are the fields MaterialNo and Description.
I am creating another table called tblSchedule and using a form to enter the information. I need the user to select the MaterialNo from a combo (cmbMaterialNo) and the then table auto populates the Description from tblFPAData.
May I start by saying Hi and that im just embarking on understanding Access 2003. I do know a little about DB as I have built programs in VB6 using databases. But now onto my problem which seems a simple one.
I have a Db called delivery. With columns as below. Mtno being the key.
Mtno Orderno Description Quantity Customer
I populate a combo box with Mtno, but on the click event of the combo box i wish to populate textboxs from the other columns.
