Autofill Via A Combo Box
Sep 9, 2006
Hi sorry I am only new to this, I am trying to learn as I go so please excuse my ignorance. (I have done some searching on this forum but am just getting more confused)
Anyway
I have a form which is based on a table that holds all the info for orders placed by customers.
It holds info on all the orders plus some info about the customer
Example of Orders Table
Order ID
Customer No
Suburb
State
Item Number
Qty Ordered
Description
Length
Weight
Order Type
Day Received
Last Dispatch Day
Actual Dispatch Date
Comments
Date Due at Customer
On this form I would like a combo box which is linked to a Customer table which has all the details regarding the customers. When I pick the customer I would like all the other fields relating to the customer on this form (Customer No, State, Suburb) to be auto populated to save entering data individually.
Example of my Customer Table
CustomerID
Customer Name
Customer No (not unique)
State
Suburb
Customer Factory
Rail Terminal code
Destination Rail code
Destination Road code
Cust Code
I have tried many different ways but no success.
Any help or advise would be most appreciated
Tks
View Replies
ADVERTISEMENT
Aug 15, 2006
I have 2 forms with 1 combo box in each form. I would like to be able to choose, for ex. a date in 1st combo box and be able to have that displayed in the 2nd form in the 2nd combo box.
View 1 Replies
View Related
Jun 20, 2006
Anyone know if an input box can have an autocomplete like Comboboxes? So say I type the string "Blue House, Red Carpet, Green Grass" and enter it. the next time I go to enter in a value and start typing "Green Grass", the form, auto inserts it, and as I start typing "Blue House", it is also auto inserted. anyone know if this is doable?
View 2 Replies
View Related
Jul 27, 2005
Hi all,
I am fairly experienced with Access but am stumped. I have a table with a primary key ID field, product name, and product price. On an order form, I want to select the product from a combo box and have that product's price automatically populate a text box beside it for further calculations. Any help would be much appreciated, thank you!
View 14 Replies
View Related
Sep 14, 2006
Hi all! :D
I'm trying to make a form to autofill with customer data (from a database), with 4 columns (= 4 customers). Each column contains on top a combo box and below 5 text boxes with address, phone etc.
So i created a form and placed a combo-box (from wizard) with the option "Find a record on my form based on the value i selected in my combo box".
The problem is that this one combo box controls all the text boxes. Even if i create an other one, it still controls all of them.
So i'd like to ask: How can i link a combo box, to autofill specific textboxes?:confused:
Thanks... :)
View 9 Replies
View Related
Sep 20, 2006
Hi all
I use a form that has a combo box and a text box.The combo box values are
Email,Cna,Dna.I manage to make users to select values from combo box and show it in the text box.I want to ask if it is possible when user select "Cna" and "Dna" from the combo box the same will appear to text box but the text box will be locked.If you choose email it would be enable.
Thanks
View 3 Replies
View Related
Sep 13, 2006
:confused: I have a combo box on a form that is used for data entry that allows the user to pick the date. This is based on a table that includes date, week ending date and month, all very specific for our business. I used a function that says Me.txtBox=ComboBox.Column1 for example. So my combo box would include all the information, and all but the actual date is not visible. I want this to feed into another table that will be used for reporting, and that table has the same fields of date, week ending date and month. I keep getting an error saying that the value selected from the combo box doesn't fit the criteria, and I believe what is going on is that it is taking all the fields instead of just the date. Any suggestions how I can still have the text boxes update if I only have the date in the combo box?:confused:
View 1 Replies
View Related
Dec 10, 2013
Autofill text field using combo box selectionHello,
I'm trying to autofill a field on a form using MS-Access 2010 Web version sharepoint using macros without coding.
The form has an existing Combo Box field called Segment, using the row sources "REW", "WTT", "DBM".
A user begins filling out the form and eventually selects the Combo Box for Segment and selects any one of the segment no Multiple selection
There is another text field, which is actually alpha-numeric, called Job_No. I want this to autofill based on their Segment selection, using this format:
REW-YYMMDD-TTTT, or REW-131210-20001 for example, for today with the time displayed as military time and last Job No.(20001) for REW and Also for WTT (30001) as starting number.
View 1 Replies
View Related
Mar 29, 2005
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
I am not a programmer so if specific code is required, I would need to know exactly what it is.
Your assistance is appreciated.
View 1 Replies
View Related
Dec 10, 2005
Two questions,
1. After my relationship table is built, is it possible to have some tables automatics fill in according to what another field in the table is inputed? EX: I have a Ordertable(orderID,itemID,Itemdesc), and a Inventory table(ItemID,Itemdesc), When you select an Itemid to put in the order form, the order Description from Inventory would appear in the Itemdesc of the order form.
Is this possible? If so how?
2. In tables, is it possible to make a cell = to something? So like if I wanted to add a subtotal and a final total after tax, I could use = * .08 or something?
View 1 Replies
View Related
Apr 22, 2006
Can I fill all cells in a column that dont contain any data with the same value?
I have a table with about 1000 records, I have a column called "brand", half of the records contain some data but the other half dont and I really the ones that dont to contain the text "none".
Any Ideas?
Thomas
View 2 Replies
View Related
Feb 12, 2005
I have 2 tables tblcontact and tblinfo.
tblcontact
contactID-PK
Customer
Contact
tblinfo
infoID-PK
PONumber
location
I want to build a form and have a combo box autofill these fields on the form. how can i do this?
Thanks,
Tim
View 1 Replies
View Related
Apr 16, 2008
I am trying to self teach myself and I am sure I am going about his wrong.
I have a form with a fillable text box called ProcessCode, a drop down box called CostContainerSize, and a fillable text box called disposal cost. Their are dozens of possible process codes and container sizes of 55,30,15,5,P,Y etc... I want the disposal cost box to auto fill based on Process code and disposal cost. I wrote the following in the control source IIf([ProcessCode]="LF" and [CostContainerSize]="55","$65.00") THis works to auto fill, but obviously only for that particular set of parameters. I have tried adding "or " comments to include other sizes for that particular process code with limited success. I have tried IIf([ProcessCode]="LF" and [CostContainerSize]="55"or"30","$65.00"or"$50.00") among other variations.
Any help is appreciated.
View 7 Replies
View Related
Apr 3, 2007
Ok, basically I have enough Microsoft Access knowledge to be dangerous.
I'm in the military and built a database that keeps track of the members who misuse their government travel card.
What I'm trying to do is enter a SSN into my form and have it fill in their name, rank, unit, etc if they are already in the data base.
I'm pretty sure it is possible, but not sure how to do it. Any help would be much appreciated!
View 1 Replies
View Related
Dec 1, 2005
I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant figure it out. Anyone?? Im not very good with code but if thats what it takes thats what it takes.
View 2 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
Jun 16, 2006
Hi everyone,
I have a table which includes several columns. Two of these columns are important for this update query I wish to do. In my table, I have two columns like this:
API# Current Operator
---------------------------------
1 |
1 |
2 | Bob
3 | Joe
1 | Mike
3 |
2 |
I am wondering if there is a way to run an update query which would automatically fill in the blank fields in column 2. The numbers in column 1 will always correspond to the same person in column 2.
Thanks,
Chris
View 4 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
Mar 28, 2005
I have a form based on a table with several fields. The table contains names of employees and their departments, etc.
When I fill in the form with the employees name, how can I have it autofill the dept?
Your assistance is appreciated.
View 2 Replies
View Related
Mar 30, 2005
Hello !
I am having some headache trying to figure out how to autofill or validate some fields in a form. (pardon my english)
This is what i want to do:
I have a form with these fields
combobox named "status" (contains 3 values)
textbox named "date"
What i want to do in the form is to automatically set the status to a value when date is filled.
If someone could help me with this i would appreciate it alot.
:confused:
View 5 Replies
View Related
Feb 22, 2006
Can anyone please help:confused: . I am setting up a database for events for local companies, I have an events table (event title, date, time etc) and a company table (name, address, postcode, tel, etc) They have a one to many relationship, with the events table being 1 and the company table being many.
I have a main form with the event details and I want to add a subform for companys, but would like this form to autofill the companies address and contact details when I enter the company name. Is there a way you can do this? :)
View 1 Replies
View Related
May 5, 2006
Sorry me again,
I have a combo box for rooms: single, twin, double, suite, grand suite
This is found from a lookup table
In the next field on the lookup table is the cost per night for the room, how can i get the cost per night to automatically appear in a text box when the type of room is selected?
Thanks
View 4 Replies
View Related
May 24, 2006
Hello
I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.
Well I created a Form and what I want to do is this:
If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).
Can you please give me ideas on how to do this? Thanks a lot. :)
View 1 Replies
View Related
May 24, 2006
Hello
I'm new to Access Programming and the whole Visual Basic bit and I have a project I need to finish.
Well I created a Form and what I want to do is this:
If I enter an ID number, I want the Form to populate the rest of the fields automatically (eg. phone number, address etc.).
Can you please give me ideas on how to do this? Thanks a lot. :)
View 1 Replies
View Related
Jun 18, 2006
I've searched the forums and Google. I've possibly come close to finding a solution, but can't quite get it right.
I have a checkbox that I want, when it's checked, to put the current date in a Date Completed field.
I know I have to edit the OnClick event, but the code has puzzled me.
Thanks for your help.
View 2 Replies
View Related
Jul 21, 2006
Ok here goes
I need some help with getting my form(form 2) to autofill from another form(form 1).
Now i dont want to use combo boxes or command buttons as i only want to use the keyboard and not the mouse.
Basically when a customer phones up to get prices they tell me there account code( this is in the customer details table) and i enter it into a text box on form 1 and after pressing enter it opens up form 2(this bit i can do) but i cant get it to open the form and display the correct details from the table on the form.
p.s why is it access books tell you everything except what you want to know.
thanks.
View 2 Replies
View Related