Forms :: Autofill - Possible For Fields To Have Auto-complete Option?
May 20, 2014
I have combo boxes set up with the different choices for major, minor, year, etc. Is it possible for these fields to have an autocomplete option? For example, there are about 30 different subjects that students can choose for a major, so rather than having to look for it in the drop down menu, could the person entering the data just start typing "ant" and have it automatically fill with "anthropology" for example?
I should also mention that the reason I made these fields into combo boxes is because I built SQL in the row source so that it is bound to the primary key but displays the description instead (with the column widths set to 0; 1).
View Replies
ADVERTISEMENT
Dec 18, 2012
I am building a database to store student assessment information. I have a table with student information, a table with teacher information, and tables which will store the student's scores on a certain assessments.
Q1: I have a field in the assessment table for Teacher ID and Student ID which are linked to their respective tables. What I want to do is create a form for inputting the assessment data but the fields for teacher ID and Student ID to auto-complete or be combo boxes, I don't care which. That is, when a person is entering a student's scores, and go to enter their ID, they won't have to type the whole number out and hope they dont make any mistakes, they will essentially have a list of choices to choose from. Or as they type, the corresponding number will filter down. I already have refferential integrity on so that they can't enter an invalid ID in either field but I want them to have the choice.
Q2: In an assessments table, there is a 1-1 correspondence btw student ID's because only one student can have one score on a particular assessment. However, clearly one teacher can be tagged to several student's assessment scores. Any better way to tag the teacher to multiple student's scores without having fields in the assessment table for teacher ID which is repeated multiple times.
View 3 Replies
View Related
Jul 21, 2015
I have created 2 tables, one for direct customers and one for indirect customers. (I consider indirect a customers customer). The 2nd table has a field that links every indirect customer to a direct one. I also have a table for inserting credit notes. The credit note is either for a direct or an indirect customer. I am using a form for this one. So the form has 2 fields, one for each kind of customer. If the customer is direct, i only insert the direct customer field. If its an indirect customer i insert the indirect customer field. What i want is to create a combo box that when choosing an indirect customer, to display the linked direct customer and to save it to the direct customer field.
View 2 Replies
View Related
Jan 7, 2014
I currently have a form with two comboboxes. One contains a list of products that the user can select from the other contains a list of percentages (sales commission rates).
What I want achieve is that when the user selects a specific product then a specific commission rate is select.
However, after selecting the product the user should still have the possibility to select a different rate if that is what has been agreed with the client. Ie. deviate from the standard rate defined by choosing the product.
How can I link the two comboboxes so that the correct rate is selected? while still retaining the the possibility to select something different?
View 1 Replies
View Related
May 24, 2014
I am trying to auto populate a form from a table containing CustomerID, CustomerName and PCCID_FK
Now in the form I want to auto populate the field cmbPCC when I update the cmbCustomer
using dlookup I've managed to show it manually
=DLookUp("PCCID_FK","tblCustomer","CustomerName='T est'")
It gives the ID of PCCID_FK which is what I want. how do it I modify the expression to replace the TEST part with a value in a combo box.
or is there a better way of accomplishing this.
View 1 Replies
View Related
Feb 2, 2005
I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.
I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.
Any ideas?
View 1 Replies
View Related
Mar 15, 2005
I have a table which contains:-
Employee ID Full name
AD Alison Doody
AM Ape Monkey
PT Pet Tepee
etc
etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help? :confused:
View 5 Replies
View Related
Mar 15, 2005
I have a table which contains:-
EmployeeID-----Full name
AD------------- --Alison Doody
AM---------------Ape Monkey
PT----------------Pet Tepee
etc
etc
In a form i want to be able to select the Employee ID and then next to it in another box the full name appears.
I've looked at other auto complete post, but nothing seems to match what i want to do.
Can anyone help?
[for those of you who read the extremely BIG writing in the last post of the same as above, i apologise!! My PC decided to have a hissy fit just as i hit the submit button :mad: :o ]
View 1 Replies
View Related
Jun 7, 2006
I have a table witch hold a reference number in one field, house number in another and street in another field. I need to create a form that when the refernce number is entered by the operator the house number and street are automatically entered in the other fields. I'm not sure how to go about it can any one help.
Steve
View 1 Replies
View Related
Jan 11, 2008
Hi
Does anyone know if it is possable to get access to complete some fields based on data you have already entered? For example, if there were 2 fields 'title' and 'sex', is it possable to set the database up so that when you select Mr, the next field automaticly enters male?
View 3 Replies
View Related
Jan 24, 2006
I'm using cascading combo boxes with sql in each subsequent combo similar to:
SELECT DISTINCT [incidentnavigation].[type] FROM incidentnavigation WHERE [incidentnavigation].[involved]=cboincidentinvolved And [incidentnavigation].[person]=cbowho ORDER BY [Type];
If the result of the query is one line, i.e. click arrow and there's only one choice, can I get access to auto-fill in the box?
I tried an excel kind of if(count(query=1) then etc and it doesn't like it.
View 2 Replies
View Related
Sep 19, 2006
Access 2003.
Auto complete was working with a combo box. After adding much functionality
to a database I find that auto complete does not work on any combobox in any
form. So I create a blank database and a simple test shows that auto complete
works. When a form from the faulty database is imported in the test database,
auto complete stops working on the test form. Even if the imported faulty
form is removed, auto complete still does not work.
I tried creating a new database and importing the faulty form after removing
all controls and events from the form except for the combo box. Auto complete
still stops working. Not only on the imported form but also on the existing
form which works prior to the import.
I checked auto expand and it is 'Yes' in all conditions.
What ever is causing the problem on the faulty form seems to cause some
property of the database to change.
Is there some database option or property setting that controls auto complete?
Is is possible that importing a form will cause a database property to change?
--
RobGMiller
View 2 Replies
View Related
Apr 28, 2008
Hi,
I'm trying to create a table which needs some feilds to be automatically filled up when the control goes to it. Say my table has feilds, "size" and "result". In each row, the result cell should be filled up corresponding to the size value of that row. This needs to be looked up from an existing table.
Would appreciate any solutions!
View 1 Replies
View Related
Feb 26, 2014
I'm working with a DB to enter orders for picking. I have an item list that I'm linking to when entering orders, and bringing in the data from the item list such as item location etc.
It's setup right now that when I type the first couple of letters into the item field it automatically brings up the matching items and if I click enter it completes the item and brings in the other fields from the item list.
Example: If I type in 'tom' I get back 'tomato', 'tomato sauce' etc. and when I choose the right one and hit enter it fills up the rest of the required info such as item location.
What I would like it to do is have the auto complete also check for middle words.
Example: when I type 'alm' it returns 'almonds', 'almond milk', but don't return 'container almonds' or 'container roasted almonds' etc.
View 1 Replies
View Related
Jul 28, 2014
I have a form that I want to expand to show more fields depending on whether a user decides to or not.
Basically there will be 5 fields that a user always completes for this form, however depending on whether they answer yes or no on the final field I want it to expand the form and have some further fields that need completing.
If they select yes it should expand, if they select no then the form is complete.
What are some possible ways of achieving this?
View 3 Replies
View Related
Oct 4, 2014
I have a form with option group (two option buttons) and date fields (to select a date range). The form should pull/pass parameters from the query. There's a form button that generates a report based on the query.
Issue: I can't figure it out how to link option buttons and date range to the query so when the button is clicked it generates the report with chosen criteria. The form is for the user to enter parameters.
View 14 Replies
View Related
Sep 24, 2013
I have a data entry form feeding a table named [Group Members] using Access 2010.
It has 4 fields; [Group ID] & [Group Name] derived from tbl.[Groups] and [Member ID] & [Member Name] derived from tbl.[Mail List]. The 'ID' fields are foreign keys from the respective tables.
The 2 'Name' fields have drop down lists for input selection, but my requirement is to cause auto fill of the 'ID' fields when the respective 'Names' are selected.
I had assumed that this simple requirement could be achieved with a suitable control on the form property sheet. It is so simple to do in Excel!!
View 3 Replies
View Related
Jul 6, 2015
MS Access 2010
I have a form "Admin" used to create new records in a table "RCJ"
I have a table called "Projects" that contains detailed information for projects.
I have a table called "Waterfall" that contains basic information and schedule information for each particular project.
I have a combo box "Contract" that selects information based on a query "Core" that gathers certain information I want to use of form "Admin"
I understand it's generally not a good idea to duplicate data in tables, but for specific reasons I am here. My combo button "Contract" has an event "On Click" that gathers information I want copied from table "Waterfall" via query "Core" is:
Private Sub Lookup1_Click()
Me![Project Description] = Lookup1.Column(1) =>goes to a text box
Me![TContract] = Lookup1.Column(3) => goes to a text box
Me![Requestor] = Lookup1.Column(5) => goes to a combo box
Me![AEM] = Lookup1.Column(4) => goes to a combo box
Me![AE] = Lookup1.Column(6) => goes to a combo box
Me![Priority] = Lookup1.Column(12) => goes to a combo box
End Sub
Now, the items listed above are sometimes just a text box and sometimes a combo box (because there are times, when items get entered that don't fit the original combo box.
Now, here's the rub. When I select the pull down on the combo box it lists all available projects. You find the one you want and select it. At that point, only Columns 1 (text box) and 6 (combo box) auto fill. The other information does not fill in .. BUT, if I more to the prior record and back, all information shows up OR if I click on any of the particular fields, the information shows up in that field. In theory, everything should show up right away.
I thought it might be because it doesn't like to autofill a combo box, but one of the combo boxes fills fine. And all of the information is acutally going to the various boxes, it just doesn't show up right away.
View 10 Replies
View Related
Jun 15, 2013
In this table I have two fields Seats Available and Seats Remaining
When I register a student to a Course in the Courses table I would like the corresponding Seats Remaining field for that course to decrease automatically.
I can, of course, run a report or a query to see how many are enrolled in the course and then manually update the Seats Remaining field (which is what I currently do), but I would like this process to be automated each time I register a new student.
View 4 Replies
View Related
Oct 22, 2007
Hello everybody!
Im new in Access as well as in this Forum! Glad to be here :)
Im currently developping a small application in Access 2003 and here is my problem:
I am trying to autofill the value of the field OrderID in this form : "FRM/SupplierID/CurrentYear/OrderNumber"
Where the SupplierID is charged once the SupplierName is selected from a combobox and the OrderNumber entered from another textbox.
Note: SupplierName values are from other table: Suppliers
Any help is highly appreciated,
Thanks in Advance
View 5 Replies
View Related
Mar 11, 2005
Hi
Need some help with a table, or possible more to do with a form design..
I'm looking to autofill in a field depending on data that's in the previous field.
E.G. I have too fields.. One for employee and one for department.. I want the department field to automatically select the department whenever the employee is selected from the drop down list.
It's probably a simple query or something I need to do..
can anyone help..
Thanks
Saifon
View 1 Replies
View Related
Jul 24, 2014
I have made a database. I have gotten to the point where I use a form to get the information. I am trying to get the information to auto populate fields after using 3 drop menus. They are department name, shop and shift. All of the information comes out of tbl department name, tbl shop and tbl shift.
I also have a table with department name, shop, shift, line, employee total, shift leader total, ratio of shift leaders per line and total employees off. I am trying to figure out once use the 3 drop down how can I Auto populate the remaining fields. Also I am trying to figure out where and how to put in the code.
View 1 Replies
View Related
Feb 18, 2007
Hi,
I have a form that has a field called scope of work which is a combo box that you have 3 options to select from.
I have set up a table called scope of work which has other fields
ie: Scope of work, Est Man Hours, Normal Rate, Overtime Rate and Est Due Date.
The combo box works fine selecting the scope of work but I want the fields on the form to automatically fill in the other information. Say they select option 1 in the scope of work based on this option it will fill in 40hrs at $150 per hour normal rate and $180 per hour overtime rate and this will take 4 weeks to complete. Based on the start date field it will also calculate 4 weeks from now for the completion date.
I have tried everything from queries using SQL statements, joining tables one to many etc.. and for some reason I cannot seem to get it to work for me and I've spent hours searching around for a solution..
If anyone has any ideas it would be greatly greatly greatly appreciated!!
Thanks a Bunch
View 1 Replies
View Related
Aug 30, 2013
The table ProductInfo has an ItemID, and its corresponding Quantity.The table Orders has a PO column, an Item# column, a OrderQuantity column, and the column Item#CurrentStock which holds the Quantity of the selected item, for 3 items.I have created a form that has a ComboBox populated with the ItemID's from ProductInfo, that when selected populate the corresponding Item# in the Orders table.
I would love if the Quantity(stock) from ProductInfo would automatically fill the Item#CurrentStock field on the form when the ItemID is selected from the ComboBox.But all of the fields only relate to Item# from the first ComboBox!?!?I have tried =dlookup,
View 3 Replies
View Related
Dec 16, 2013
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):
Description = Partnumber.Column(1)
I tried also:
me.Description.value=me.PartNumber.column(1)
both codes unsuccessful.
View 3 Replies
View Related
Jun 10, 2013
I created a table to allow me to enter automobile information.. year, make model, etc.
Now how can i make certain "drop downs" dependent on next to autofill info?
Such as
make= ford
model= crown victoria
make= chevy
model=impala
such that they could not choose a
make=ford
model=impala
because "impala" would not be on that dropdown selection/choice?
View 3 Replies
View Related
