Auto Populate Data When A Particular Value Is Selected
Jan 23, 2014
I have been tasked with creating a databse that contains multiple test records. Within a single test record, there is a field named 'bits' in which there are 10 different bits (0 - 9) each with a different value and description. I would like to set up the database such that a user can view a single test record and select a particular bit field from a drop down box and when the bit is selected, the descriptive information for that particular bit is automatically displayed to the user.
For example:
- User selects 'test record A'.
- Within 'test record A' there is a 'bits' dropdown box.
- From the 'bits' dropdown box, the user selects bit '0'.
- When bit '0' is selected, another field named 'bit description' automatically fills in the bit description for bit '0'.
I have a standard Data Entry Form based on a WorkOrder. I am dealing with over 90 offices nation wide with mulitple offices in a state. I have a seperateTable that lists all 90 Offices which I have created a Query to Promt the user to enter the State code for that State.
Is there a way I can Select an Address from the Query and auto populate that information onto my WorkOrder form?
Any help would be greatly Appreciated as I have Exhausted myself trying to figure this out!
I have 2 fields, a "Total' field and a "Submitted" field. The 'Total' field value will never change as it is used for reporting purposes but the 'Submitted' field will be edited as the work is completed but the initial value should be the same as the 'Total' field.
Is there a way to have the data in the 'Total' be set as the default value for the 'Submitted' field?
I need to pull data from a master project list to auto update other forms. When someone enters a project number I need it to pull the data for that project into another form so they dont need to keep typing details in. The other forms are trackers for our processes to complete the projects.
Let me know what you think...would a subform pull the info automatically somehow?
I have created a basic Volunteer Events and Hours Volunteered tracking database.
I created a form Volunteer Hours to allow an end user to use that form to record the volunteer and hours volunteered on a specific Event. There are two tables needed in the form Volunteer Hours to be used for the end users to record the Event, Volunteer, Date and Hours. The form has drill down fields from two tables:
I want to be able to select the Volunteer Event and have the event date automatically populate in the Volunteer Hours form date field when the Event is selected to eliminate the end user from having to enter the date in.
Also; I would like to be able to add more than one volunteer at a time to an event on the form, this would also decrease the data entry time.
In my UpdateForm I have 3 fields. PartNumber, Description and SerialNumber. I use 2 tables for these. My MainTable and PartsList Table.
In my PartsList table I have the list of PartNumber in Column (0) and Description in column (1).
In my MainTable I have 4 fields: TransactionID (autoNumber), PartNumber(text), Description(text) and SerialNumber (text).
Now, In my UpdateForm I want the user to just select the PartNumber with a combo box (that also show the "Description" (I created this using the combo box wizard)). But I want to auto populate the field in my "Description" text box every time the user will enter new record and will also update my MainTable with all the values they entered in my UpdateForm.
I tried this codes in the after update of PartNumber combo box (properties):
Ok, this is what I have, I have a database that has 3 tables, a year table, that all my forms get inputted into, a table that has manufacturer addresses on it and a table that has sampling locations.
On my form, I have it where there is a drop down box, so you can just select the name of the manufacturer and select the name of the sampling location. But what I want it to do is, that you select the name from the drop down box and then in another box or two it auto populates the corresponding street address, and city for both the manufacturer and the sampling location.
I have with my database. It's holds cost data including purchase made in foreign currencies which need to be converted to GBP using the correct exchange rate so a variety of reporting & stats can be performed.I have a table called Costs within which there are 2 fields
Purchase Currency Exchange Rate
I also have another table called Exchange Rates 13/14 within which there are 2 fields
Currency Exchange Rate
When a value is entered in the Purchase Currency field on the Costs table (this is a look up field linked to Exchange Rates 13/14 so it shows the listed currency in drop down) I need the database to automatically populate the Exchange Rate column in Costs i.e. match the value in the Purchase Currency field to the Currency field in Exchange Rate 13/14 and populate with corresponding Exchange Rate from Exchange Rate 13/14.I have tried the following and none work:
SQL Tried
1. UPDATE Costs SET ExchangeRate = [Exchange Rates 13/14].[Exchange Rate] WHERE Costs.[Purchase Currency] LIKE [Exchange Rates 13/14].Currency
2. UPDATE Costs SET ExchangeRate = [Exchange Rate] FROM [Exchange Rates 13/14] INNER JOIN [Exchange Rates 13/14] ON Costs.[Purchase Currency] = [Exchange Rates 13/14].Currency
3. SELECT [Exchange Rate] FROM [Exchange Rates 13/14] WHERE Costs.[Purchase Currency] LIKE [Exchange Rates 13/14].Currency
I know it is possible to have a drop down for Purchase Currency which shows 2 columns (both Currency and Exchange Rate) you can then use the exchange rate figure for a calculated field. The problem I have is that I am importing data into the costs table from excel. In Excel I can only have 1 value in the Purchase Currency column on the upload template. If I just have Euro in this column the database does not match it to the Euro in the Purchase Currency drop down and also store the correct exchange rate.
Or is the alternative to put this into the calculation of GBP Unit Cost where this somehow matches the Purchase Currency in the Costs table to the Currency field in Exchange Rates 13/14 tables and uses the appropriate exchange rate from Exchange Rates 13/14 to calculate GBP Unit Cost in Costs table.
I'm trying to figure out a way to get my access database to auto-populate data into a field based on the information I type into the first record.
So what I'm looking to do is that when I type a name into the UserName Field it will automatically fill in the rest of the field with the same information.
To clarify I'm looking for a way so that when I type something into one record it will fill the rest of the field in with that same information.
I have two comboboxes in access form. what i want is if i select "A" from combo1, I want to have one value to combo2 could it be "x" or "y" or "z" but of my choice.. After combo1 is selected "A", I want automatically pop, lets say, "y" or any value i want may be "z" at combo2 of the form. Combo2 also has list of values (x,y,z) fetched from table.
Please note that both combos are fetched from tables that contains two columns (ID, name) and combos are fetched by binding first column and assigned column count 2; so that it shows the values rather than numbers. Moreover, the combos are allowed to store multiple values (defined in master table).
I'm using a sub form to display data form a table. The users wanted it display like a spread sheet. In order to get all the data to display on the same page I am trying to break some of the longer feilds out (i.e. comment field) and display them in a list/text box and not in the table with the smaller fields.
Basically what will happen is when a record is selected in the sub form the comment field tied to each record will be displayed below. I've tried a few things but I keep getting errors displayed in my list/text box (#Name?)
I am trying to do the following. I understand how to create relationships.However, when I create a field with a drop down selection (in this example Phone Number and Email) once that list item is selected I would like the column to the right to populate that information.So when Phone # is selected, the field to the right will populate a number for this individual.
I have built a form that holds details of training records. What I want is when a drop down is selected in the main form, that it will populate some of the fields in the subform. I have this working at the moment, that for example, when a certain course is selected, that their modules will appear in the subform. Where my problem arises is that I have a relationship between two tables that I want to appear on the subform, so that details can be filled in on the subform against the list of modules that automatically appear.
What I’m trying to achieve is a database that I can enter the number of calls a salespersons makes in a day. Please find diagram below.
<< Date >>
,,,,,,,,,,,,,,,,,,No-Calls Name Ben,,,,,,,,,,,,,,,1 Bob,,,,,,,,,,,,,,,2 John,,,,,,,,,,,,,,3
I have kind of got one working but when I create a new day I have to type in all the names every time and it get a bit boring. Can anyone point me in the direction of how to auto populate the names of salespersons when I ad a new date ?.
I have attached a quick mock-up of what I have got so far so if I haven’t explained myself very well hopefully you can see what I’m gibbering about.
Hi all,I tried looking for an answer to this but I haven't found anything yet. I have a form that features a 'Bill To' and 'Ship To' section with 'City, State, Zip etc..' for each one. I'm triyng to create a button that my users can press to automatically copy the data from 'Bill To' into the corresponding fields in 'Ship To' to save time if the data is the same. I tried creating an update query but it seems to confuse the form code and throws errors.Any help you can give me would be appreciated.
I know this is a easy task, but I can't just figure it out. I have a table with branch No and Branch Name. In my form I would like the user to select the branch number from the combo box and the Branch name field will be placed in the Branch Name field automatically. How do I go about handling this task.
Ive been through-out a decent chunk of the internet, trying to figure out how to Auto-Fill or Auto-Populate a select number of Text Boxes on a form.
Example ill sit there type in someones ID number and his Name, Where he works. all of that information have come up yet considering its probably a really simple question, can someone please help me out.
Hi, everyone! I hope that someone is willing to help me with a database that I'm trying to set up. I'm a teacher and want to use Access to track behavior notes and parent contacts. I'm trying to make the database work efficiently for me and need some help with auto-populating fields.
Here's an example of what I want: Field 1= date (I have this setup to fill in automatically) Field 2= student name Field 3= behavior code Field 4= comment
I want to type in a code for a behavior in Field 3, such as "t", and have "talking excessively" automatically pop up into Field 4. This would just make it faster for me to enter all my info, and then I can make a report that only shows the date, name, and comment without the codes showing up. I currently have the behavior codes listed in another table, but I don't know if that's where they belong or what. I've found some web sites that have codes for auto-populating, but I have no idea where to put them or what to change in order to personalize them for my database. Is there anyone willing to walk me through this? TIA!
These are the codes that I have: codememo bdid not have book in class cdclass disruption dadetention assigned dcdress code violation dsdetention served hdhad head down throughout lesson nwdid not complete classwork ooffice referral rreferral for 4 tardies ssleeping sdskipped detention ttalking excessively wdid not have workbook in class
Maybe im just having a brain fart, but I cant get this method to work.
There are two forms, the first records Two Names, The Bride and The groom along with their wedding date and where they registered. After all the data is entered on the first form, the first form is closed, and the second one is open.
What I would like to do is pass the info from the first form on to the second one. The second one uses the bride's info and the wedding date.
I tried using the query to fill it in but I havent had any luck. Been a long day.. maybe just not thinking clearly.
Any help would be appreicated, and thank you in advance to any replies!
I accidentally posted this in "general"...so I am posting it here under "forms", since it is "form" related. My intention was not to double-post...sorry. Summerwind had posted an example to auto populate a combo box. The code below follows his example, but is not working for me:
The fields I have on my form are:
cboCompany cboLocation
cboCompany is based on tblCompany( with fields CompanyName, Location)
When I update the cboCompany field, I want the cboLocation combo box to populate with all locations for the company that was entered into the cboCompany combo box on the form. E.g. The company "Visions" may be exist in the tblCompany with 3 different locations: Visions (Las Vegas), Visions (Ohio), Visions(California). When I pick the company "Visions" from the cboCompany combo box, I want the cboLocation combobox to be populated with "Las Vegas", "Ohio", and "California".
The code is as follows but returns empty records in cboLocation:
Code: Dim StrSource As String
StrSource = "SELECT Location FROM tblCompany WHERE tblCompany.CompanyName Like " & Me.cboCompany.Column(1) With Me.cboLocation .RowSource = StrSource .SetFocus .Dropdown End With
Okay--I have a table of scholarships, and each one has fields for primary contact, secondary contact, tertiary contact, etc., in which the names of the contacts associated with each scholarship are stored. What I need to do is to have every name pulled from this table and listed--each as its own row--in another table. I'd like it to do this automatically so that if a new name is added to the scholarship table, it will create a new row in the other table.
Is it possible to change the colour of the text in a table. For example the word "URGENT" is selected from a combo box, and when viewed in the table it appears red.
I am creating an inventory database and was wanting to know how to make a combo box or any box auto populate information from tables. I would like to have a combo box so that you can do a search inside of it and find the necessary product, select it, and all the product specs will be displayed. I have created the combo box with this information, but no luck getting it to populate on the form itself. Thanks in advance for your help.
Haven't touched Access in quite some time and now I can do a simple task.
Here's what I have:
2 Tables
Table 1 includes 2 fields COURSE CODE and COURSE NAME
Table 2 will be a list of students and the courses they have taken
What I'm trying to do is as I'm entering a new student in the database I want the course name to automatically fill in when I type in the course name.
I did lookup fields for both the course code and the course name to ensure the correct codes are entered. However since the data in table 2 does not autofill there is the posibilty of having a row with a course name that does not match the course code.
How can I force table to 2 match the course name and code relationship from table 1?:confused:
When I populate a combo box named BusOrgCode, I want to auto-populate the HRName box with the name that corresponds with the Bus Org Code. I get a run time error "2001." Help!
Here's my code: +++ Private Sub BusOrgCode_AfterUpdate()
Dim strFilter As String
' Evaluate filter before it's passed to DLookup function. strFilter = "BusOrgCode = " & Me!BusOrgCode
' Look up HR Partner Name and assign it to HRName control. Me!HRName = DLookup("HRName", "HR by Bus Org Code", strFilter)