Have Data In 1 Field Autofill Another, Easy?
Here is what I want to do. I have a table called "TblRates" and in the table are two fields called "Description" and "Rate" the description field has data in it like "PC Repair", "Onsite Repair" and the "Rate" field has currency data "$50.00" and "75.00". I have a for called "FrmRates" and I want to be able to select "PC Repair" from the "description" field and have it auto fill "$50.00" into the "Rate" field and the same for "Onsite Repair" and have it bring up"$75.00". That is the best way I can describ it. I would like to either know a macro or somthing easy I can type in VB code which I know nothing about. Please Help
View Complete Forum Thread with Replies
Related Forum Messages:
Autofill Of 1 Field
I have 2 forms (school and venue) I have a button on the school form that opens the venue form. I want the school field that is on the venue form to auto fill with the same information that is in the school field on the school form. Any help would be awesome. Martha
View Replies !
AutoFill Data
Hello, I am creating a helpdesk support database. My question is for my Customer Form. As I tested the form I realized that one of my Combo Boxes may not work cause the name may not be the same when the customer calls. Let me Explain: The Combo Box is query from one table with 5 Fields: CompanyID > PK Company NumberID > unique Number Company Name > Short Name Company Number > telephone Number Company category > Category Company belongs to So, when the customer calls they may give another name for the company or just an abreviation. what I did I created a pop up form which displays all records showing the NumberID; Name; Number; and Category, with a lookup txtbox to search for the customer by typing the company NumberID on a continues form. Now, Here the agent can actually do two things: One, the agent Can Update the company Phone Number and Category. the second thing will be to either double click or select the right company and autofill the combo box or should I used a textbox instead of the combo box in my form. P.S. Right now I using a Combo Box. Thank you. Any help in the right direction will be great. Mr. Dix
View Replies !
Autofill Field With Employee
Hello all! Ok, lets get down straight to the point. What i want to achieve is that when i login that automaticly the name has been filled in on every form. I have a login form. I put my name in there like "Michiel" and ofcourse the password. After that its going automaticly to the mainpage. In that mainpage i want to create a field that automaticly filles in my name (so if somebody else log in that their name will be filled in). After that i want when i go the incident form that automaticly the employee form has been filled in. (The person that at the moment is logged in that his name automaticly been filled in) Ive tried various ways to achieve this goal but nothing worked. Im not that very expert in Access but im trying to understand and learning pieces by pieces the Access world. So if somebody could help me because im getting desperate! Thanks in advance all! :D Greetz. Creegfire
View Replies !
Autofill Field From Selection In Combo Box
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 Replies !
Question About Autofill Fields From One Individual Field
I have a form with the following Fields: Customer Name, Address, City, State, Postal Code, and Phone Number. I also have a field called License Number. This question is that once the data is entered the first time, is there an easy way so that if an individual that has been entered into the database comes back you can enter there License Number only and the other fields will fill in automatically. If so How. I am assuming so kind of query but i need help. Please Help..thanks
View Replies !
Autofill Fields Based On Results From Another Field In The Table?
I have an Access database with several tables and a multitude of subforms which are displayed on a single master form. The subforms are used to facilitate data entry. In several of the tables there are fields which are related and I would like to have some of these fields updated based on the results entered in the related field (i.e. the answer for one field depends on the other). Field 1Field 2 [facing][DISC_CODE] un3 up1 dn2 Field 1 is a simply a description of the basic dataset. This field is already set-up on form as a combo box that allows the user to choose one of three options. Field 2 is a code number used by another piece of software to identify a particular symbol. It is a new field being added to the database. There are 200 codes that identify a wide range of symbols for different types of data and I don’t want to have to look them up when I, or my assistants, are doing data entry. My question is this; is there anyway to have the DISC_CODE value, Field 2, automatically entered in the table when the value for Field 1 is selected in the combo box on the form?
View Replies !
I'm Sure This Is Very Easy: Update Multiple Fields Based On One Field...
I promise I have searched, but I hav spent 10 minutes reading through posts that are unrelated... What is the code to have multiple fields updaterd based on what is input into a field? --- Example: A ZIP Code Field, which updates City & State on the form when entered. (I have a table that has over 39,000 ZIPs w/ City & State already there) --- I have several applications for this, but if someone could explain this use to me, I will be able to figure it out. Thanks a million!!!
View Replies !
Autofill Query Field Based Upon Other Fields Within The Same Query?
Hi, Baisically I got this query which controls the selection of Software within a system. i.e. It contains the fields Vender_ID, Application_ID, ApplicationEdition_ID and ApplicationVersion_ID. These auto-filter based upon the users selection (e.g. Vender=Adobe so Application=Acrobat/Photoshop/etc...) Right some from the user software/application selection i want it so that it will automatically assign a License_ID defined within a table tblLicense_Information. Baisically im asking whether i can put this in the 'criteria' box: "SELECT tblSoftwareOverview.License_ID FROM tblSoftwareOverview WHERE ((tblSoftwareOverview.Vender_ID=qryHardwareSoftwar e.Vender_ID) AND (tblSoftwareOverview.Application_ID=qryHardwareSof tware.Application_ID) AND (tblSoftwareOverview.ApplicationEdition_ID=qryHard wareSoftware.ApplicationEdition_ID) AND(tblSoftwareOverview.ApplicationVersion_ID=qryH ardwareSoftware.ApplicationVersion_ID));" I know the sql is not exactly right but you get the idea of what i want to achieve! But im guessing you cant really have an sql statement within an sql statement so any other suggestions on how i can do this would be much appreciated as the INSERT INTO command didnt like inserting into a query and when inserting straight into the table, the query failed... cheers
View Replies !
Autofill Data To A Main Table From A Reference Table
First of all apologies for the lack of proper terminology I'm a novice Ms Access user and I like to thank everyone in advance for trying to help. Ok here is the situation: I have two tables, NewJobs and Contacts which have the following fields. Newjobs -------- JobID (AutoNumber, Primary Key) JobName JobDate JobDescription JobOwner (Linked to table 'contacts' via LookUp) Contacts --------- DisplayName EmailAddress Department Extension Ok basically what I want is to have a form based on table NewJobs which will allow me to enter new jobs into the database. When I get to JobOwner a drop down list linked to 'Contacts' table will show me all the data from column 'DisplayName' and allow me to select it (saves time on typing). I have already done this and its not a problem. Now I would also like in the same form to have additional fields from table 'contacts' such as EmailAddress, Department and Extension which will autofill with the right information soon after I select a JobOwner from the drop down list. So for example if I select 'Joe Bloggs' Access will automatically fill the additional fields in the form with Joe's information (department, extension etc) from the Contacts table. I hope all this makes sense. Thank you all for your support. - Mitch
View Replies !
Autofill
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 Replies !
Autofill
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 Replies !
Autofill
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 Replies !
Autofill
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 Replies !
Autofill
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 Replies !
Autofill Help
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 Replies !
Help!! Autofill Troubles
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 Replies !
Autofill Fields
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 Replies !
Autofill In Subform
I have a Subform on my form. I am trying to get it to be filled in when someone does the following: Enters number into txtNum and then clicks on the OK cmd button. The form is based on a table called Cancel. The subform is based on a tabled called Deal The controls on the subform are as follows: intNum txtName txtContact txtPhone txtFax dtmUpdated Also, the intNum cannot be duplicated in the Deal table. The field that links the tables, Cancel and Deal, is intNum. Thanks for the help.
View Replies !
Autofill Query?
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 Replies !
Autofill Fields
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 Replies !
Autofill Dept
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 Replies !
Validation Autofill ?
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 Replies !
Autofill Subform
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 Replies !
Autofill Text Box
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 Replies !
Autofill Form
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 Replies !
Autofill Form
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 Replies !
AutoFill From A Combo Box
Hi there everyone. Please could someone help me with a problem! I have a form running from two qry's deceided by grp selection, written in the back end with VB. My problem arises when I attempt to autofill txt fields with the record connected to the selection made in the cbo box. Can anyone give me advice (all of which will be greatly appreciated) and can anyone see a good way of doing this. Thank you for taking the time to read this and I look forward to any guidance. Chris.
View Replies !
Autofill On Checkbox
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 Replies !
Desperate Autofill Help
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 Replies !
Autofill Combo Box
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 Replies !
Autofill Via A Combo Box
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 !
Autofill In A Subform
I manage a self-made database of property deeds for my business. Since it often happens that there are multiple owners and multiple buyers of these properties, and that many of the owners and buyers are the same people from time to time, I think I can manage this database more efficiently by using subforms that autofill when I start to type a person's name. I hope this is possible. My main table and form are based on the deed description. Each deed will have unique buyers and sellers and each buyer and seller can be on many deeds. Thus far I have created tables and queries for sellers and buyers. The seller subform is set up and can accept entries in the form view. When I scroll from record to record, the names seem to show up where they belong, so I'm happy with that. The problem is that when a name comes up a second (or more often) time, I end up typing the entire name in again. This sort of defeats the purpose of having related tables. How can I get it to recognize that the name is already there and perform an autofill for me? What am I missing?
View Replies !
Autofill Problem
Hello friends, I have exhausted my resources, and have not figured out how to get my text boxes to automatically fill with data associated with the selection of a combo box. I have a table with the following fields: PK - autonumber Frequency - text TimeD - text TimeN - text The frequency entry describes the frequency at which paramaters are to be measured, and Time1/Time2 are the times that are set by each frequency for Day and Night resp. I know this has been discussed ad nauseam, but I have spent almost a week searching this forum as well as a couple of others, and just keep coming up short. I have uploaded a zipped db that will better illustrate where I'm at with this project. Please have a look. thanks in advance.
View Replies !
|
TRACKER
