Auto-fill one field from another table

I am working on Access 2007.

I have two seperate tables (called inventory and job log) and they have a few of the same field items (number, name, style 1, style 2, and area).

I would like the job log table to autofill the name, style 1, style 2, and area when you type in the number when logging a new job (pulling this information from the inventory table). It has to be fairly straight forward but I am having trouble trying to make this happen. Could someone please help, I am sick of flipping between tables to fill in the information

Sponsored Links:

Related Topics

Auto Fill Fields in a Form using a Combo field
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.


Auto Fill Fields in a Form using a Combo field
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. Any idea what's going wrong


Auto-Fill text fields in the form
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?.


Auto calculate field - extract certain information
I wonder if it is possible to generate a new field which auto fills values with everything between brackets "(xxxxx)" in the source field?

I have a field with records like abc(xxxx) and I want to auto fill another new field only with xxx


Auto fill in value based on two fields
I am creating a user input database with a table name “tblOutput”. It several fields such as OrderNbr, Oper, PartNbr, Machine, Area, UserName, InputTime and etc. I also have another table for reference calls “tblOrderRef which has field such as OrderNbr, Oper, PartNbr, Machine, Area.

I would like to auto fill in the values for field PartNbr, Machine and Area based on the OrderNbr and Oper the user input. I need help with create reference query auto fill those field in either table or Form.


Auto Fill Field
I would like to auto fill a specific field for every new reord of a table with the same value. I have a table that includes a field "project Number". When you add a new record the same Project Number needs to be included for every record.

I have tables for separate projects and need to compare information from 1 project table to the other project tables.


Auto-fill field not saving to table
with this:

In the form, there is a field that gets filled in automatically by what is entered into two other fields on that form.

The information that is being automatically generated in that field is not saving to the table.

Example:

Field 1: Meeting Type
Field 2: Meeting Year
Field 3: Auto-fill field (starts out blank)

Field 1: I choose "Annual Meeting" for the meeting type (this puts AM into Field 3)
Field 2: I choose "2010" for the meeting year (this adds 10 into Field 3)
Field 3: "AM10" is now what shows in the field

I save the data base. I go look at the table and there is nothing in the Field 3 column, when there should be "AM10."

Any ideas about how to get it to save that info in the table


Design View = Text 6 Char =Next Column
My Table has the following fields:
Example:
Field A = aaabbb
Field B = aa-aaa
Field C = aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

When I fill the fields I want them to advance to the next field if they have the maximum characters, 6 char in Field A & 5 Char in Field B. I have been able to auto enter the "-" with no problem in Field B. I only use Field C when I want to make a note. I'm not using a form view. I'm trying to avoid unnecessarily keys to continue.

Work Flow:
Field A - 6 char auto advance to Field B
Field B - 5 char auto advance to Field A
Field C - I use mouse to select since it's a rare event.


Auto fill data (number) between tables
I created a database to track a group of records (people). I couldn't figure out how to auto number the primary key to a random unique number that was less than 10 digits so I generated a list of random numbers and just use the next number off the list as I enter the next person which works OK- but I have to put that number on each table as the ID number to relate back to the Primary key and it seems that I should be able to have those auto fill with the entered number. Is it possible to have the number typed in "table 1" (people) primary key auto fill onto each of the other tables as an ID number?


auto fill certain text fields?
Does anyone know of an easy way to set 3 different text fields to automatically fill with the same info? I have an online store database, and would like to have certain postal fees and charges to automatically fill in because they never change. Also, I have a lengthy refund policy that I would also like to fill in automatically.

I don't know vba at all, so if it's that, I'm done for. Is there anyway to set a default on the table? For example, one field will always say something like $2.95. So, when I add data into the form, I'd like the field to be pre-filled


Auto fill field upon New Record selected
I have a field in a table ( Clients ) called Clients_Client#, which is a text field. Each year we start a new group of clients numbered as follows:
and so on.

I would like to fill in this field automatically when a new record is selected to avoid typos and duplications


Data Entry in SUBFORM
I have a database that each month I assign various tasks to multiple people. I am trying to auto fill some of the information from one table to a new record in another table. People: Hireid (primary key) name, supervisor, role etc. Assign: empid (primary key matches hireid) AssignMonth, supervisor week1assignment, week2assignment.
I am trying to make a subform that auto fills the empid (hireid from People table) in the subform so I don't have to fill out information I already have. The Assign table is empty. Is there a way to auto fill a table with the subform when there are no records in the subform table.and how if you can


Auto fill a table?
Is there a was to auto fill a table? Eg: I am looking for a way to create 200 records from 001 to 200. Just a count from 1 to 200. With out typing them in manualy.


Auto Fill-In Capability?
I am fairly new to microsoft Access so I do not know of all of the capabilities that it can do.

I was wondering if Access had the capability to have an auto fill-in feature.

For example: On some job applications they have information that you fill in but that info can automatically be filled in by uploading your resume.

I would like to do something similar to that nature with a database that I am trying to create


Auto Fill Field
I have a table with over 30,000 records. I have just inserted a new field at the beginning of the table that I have named "Index"

I want to make this the primary key and I want to fill each record with a number, beginning with 1 for the first record, 2 for the second, etc.


Auto-fill a field based on the selection in another field
Our company is moving a lot of our logs from Excel to Access and I have been learning Access on the fly.

I have gotten the hang of things as far as creating tables, forms, and split databases, I have yet to find step-by-step instructions on how to perform this "auto-fill" function so your assistance will be greatly appreciated.

Just as a side-note, I am using Access 2010:


Auto fill a field from multiple lookup
I have three tables in my database.

[customer]=> CID, Cname, Ccontact, SupplierID
[Supplier]=> SupplierId, Suppliername, Suppliercontact
[ order]=. OrderID, CID, SupplierId, product.

I have a multiple lookup field of CID|SupplierID from [tblCustomer][tblSupplier].

I am working on order form and I want if I put CID from lookup it automatically fill Supplier ID associated with that customer or any other way to fill SupplierId auto instead of look up field.


Auto-Fill Text box on form
The problem I have now is as follows.

The 'TrainingDuration' table has 4 fields, ID, Duration, StartTime, and EndTime. The 'ID' field is linked to the 'Duration' field in the 'TrainingSchedule' table. Which works fine if you go into the actual Schedule table.

What I want to be able to do is have the fields 'StartTime' and 'EndTime' auto-fill in the various forms. The problem is the StartTime and EndTime aren't actually in the Schedule table, they're in the Duration table.


Appending Records with a desired auto number in a table with Auto Number
Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.

I am sure Im not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question


Autofill a field based on previous filed within the same column
How do I get access to auto fill a text (supplier)? I realize that for a new supplier I would have to input the supplier name, however my question is what should I do for Access to enable auto-fill so that the next time I have to input that supplier it would auto fill for me. Please keep in mind that all of this is happening in a single column.
For example: In the supplier column, I typed Dell in the first row, Apple in the second row, HP in the third row. Now when I start typing 'Apple' in the fourth row, I want it to autofill 'Apple' because I have already input that once