General :: Auto-fill Within A Form From Other Tables
Jun 25, 2014
I'm stuck on making a form to automatically fill information in the other boxes based on what I typed in a previous box.
In one table, called Project_ID, there are three fields, in which the first, contains the unique key for the product. Example:
ProdID (unique key) | Product Name | Product Use | etc
In the other, I have a table called Shipping Reports, in which it contains the two fields previously stated after another unique key called ShipID
ShipID | Product ID | Product Name | etc
What I am trying to accomplish, is when I go to a form under Shipping Reports, and type in an ID in the field for Product ID, I want it to extract the information for the Product Name under the table Project_ID
View Replies
ADVERTISEMENT
Apr 3, 2015
I have two tables, "Summary" and 'POC Information". In the "POC Information Table I have all my Contacts Information (Name, Title, Phone, Email, etc...) and I am trying to assign 2 POCs to each of my multiple projects located in the "Summary" Table. I am using a Form called "JCIDS Tracker Input Form" as the link. So far I am able to assign one POC by a combo box that lists "Full Name", then it autofills the other information...Phone Number, Email, etc... The problem come into being when I want to assign a second POC to the same Project...I can assign a name, but it won't correctly autofill the rest of the information...it just autofills in the information from the first POC that was selected.
View 8 Replies
View Related
Nov 14, 2012
I have a master list of projects, with project reference number, project name, and nature of project.
I have also got a form for individuals to fill in details of project events, with date, time, name, and two or three other fields - also included are project reference and name. I'd like the name field to be auto filled when the user selects the project reference from a combo box; I think? (the list only shows open projects).
I'd did something similar some years ago in Access 2003 (I think) but cannot figure it out in the version I'm currently using 2010.
View 8 Replies
View Related
Jan 2, 2013
Is it possible to look up 2 field to auto fill another field on my form?
Field 1 is "RiskLetter" this is autofill with "Risk" is user input.
I need to lookup RiskLetter and Risk and autofill from "Number" field. This to stop incorrect data being inputted.
So I need to look at the "Risk" & "RiskLetter" to come up with a "Number"
Would it be possible to use a Dlookup to look at RiskLetter and Risk to give me the score.
View 14 Replies
View Related
Jun 21, 2013
I am in Access 2007. I have two tables (Employer Contacts and Employer Followup). I have been successful in linking the "Employer Name" sections between the tables, and I have added to the "Employer Followup" table a combo box for the "Employer Name" field that when clicked successfully shows all the companies we added to "Employer Contacts" table in the field of the name "employer name". This is what I want. Now the trouble comes with trying to get the data from the fields; Location, contact name, original contact date, phone and email to auto fill into "employer follow up" using the information captured from the "Employer Contact" table. I can see it all in the drop down box but cannot get it to auto fill.
View 2 Replies
View Related
Aug 31, 2011
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??
View 1 Replies
View Related
Jun 6, 2013
Is there a way to auto populate a table or form in Access from an Outlook email? For instance, if I send a survey via email and the survey is taken and sent back via email is there a way to have that data auto fill into the database or will the info need to be manually data entered?
View 3 Replies
View Related
Mar 15, 2007
I am new to Access, and I need some help for this project I am working on. Please let me know if my question doesn't make sense.
I have created four tables: Clients, Tenants, Property, Contract
Clients
Client ID | Client Name |
Tenants
Tenants ID | Property ID | First Name | Last Name
Property
Property ID | Client Name | Contract ID
Contract
Contract ID | Clients ID | Client Name | Tenant ID | Tenant Name |Property ID |
Is there a way that when I enter Client Name in the Contract table, Client ID would automatically come up and check against other fields in the table if the information entered in Contract table is in sync and relevant against to data entered in Client, Tenants, and Property table?
Please let me know if this is not clear and I need explain more. Thank you.
View 8 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
Feb 7, 2014
I am creating a Access Data Base for Product Complaint. I have created several tables that share an auto complaint number (Primary Key). How do I make that auto assign? Below is the format of my Complaint number;
A Complaint Number is assigned using the format: PCYYMMXXX
Where:
PC = Prefix indicating Product Complaint
YY = Last two digits of the year when complaint originated
MM = Two digits for the month when complaint originated
XXX = Sequential number starting at 001 for each year
View 1 Replies
View Related
Nov 9, 2012
I have a Table named TBLBookings...on one of the fields I have a Lookup wizard thats linked to a Table named TBLVehicles which includes
Car Reg
Car Type
Location
When I run the TBLBooking and click the drop down list it shows up
Car Reg
Car Type
Location
but once the field is clicked all it shows in the records is the REG where in a form id like to see what vehicle it is location etc...is it possible to have extra fields in the form named Car Type and Location and once the registration is chosen it automatically fills in the correct details for them?
View 4 Replies
View Related
Feb 7, 2014
My problem is I have two tables. One of the tables was made specifically to draw information from to populate the second table. The second table has a combo box that draws information from one of the fields from the first table. What I am hoping to do though is have each selection from the combo box in the second table to draw different information from another field in the first table and use that data to populate another field in the second table.
Simplified: Combo box in Field (1) on table two has multiple selections that I want to autofill the data in Field (2) on table two based upon the selection of the combo box. Data from both fields in table two would come from two different fields from table one.
I have tried to work with the After Update button in the After Events section on the ribbon at the top; however, I am simply lousy with coding. Is there an easier way to do it other than using that option?
View 10 Replies
View Related
Apr 10, 2014
i have a user permission table.that consists of PermissionPK, UserFK, CompanyFK. I also want the username to be automatically filled in?So when a user ID is filled in on the table, it also fills in what that UserID's Username should be?As i need both the UserId and Username text for code that looks at the Environ username.
View 2 Replies
View Related
Jan 6, 2015
I understand right off the bat if you're reaction is "don't duplicate data!!" -- mine would be too (don't fret, I know my normalization).
I've linked a table in my db to my Global Address Book in Outlook 2007 and, upon entering an employee number as a new record, would like to verify that the number entered is listed in the GAL and then pull in the associated name and location info.
The key is that I don't want this info to rely on the GAL going forward. For example, if an employee leaves or is no longer listed in the GAL, I don't want to lose the employee info (past data is needed for audit purposes). Note: I will be creating a report later to show if there are discrepancies between the GAL and my table, but that's another story...
So, what would be the best auto-fill options in Access 2007?
View 3 Replies
View Related
Apr 24, 2005
I am a new access user and need some help. I have created an auto fill query to fill in information on a sales order table from my customer table based on CustomerID.
I have also created a sales order form. When I enter the customer ID in the form the rest of the data does not fill in. Actually nothing happens.
How do I link the form to the query so that the form knows where or how to look for the auto fill customer data.
Thanks
Darrell R
View 1 Replies
View Related
Oct 25, 2004
I have a database with a table of all our records. I created a form, and would like to be able to type in the last name in the last field and have it bring up the record. Also, this could be a problem because there are several people with the same last name. How do I do this? Thanks!
View 1 Replies
View Related
Aug 7, 2006
can I have fields in a form auto filled from fields in another table?
View 1 Replies
View Related
Jul 1, 2013
I have a table called Client Info which stores the clients name and their requirements (Gas safe etc). And I have a table "Job List" where i select from a drop down menu the clients and it auto fills all the requirement check boxes based on what is stored in the Client Info table. However I can't get the code to work.
Private Sub Client_Click()
[job_list].[Gas_Safe].Value = [client_info].[Gas_Safe].Value
End Sub
View 7 Replies
View Related
Jan 2, 2013
I am trying to autofill a field based on another field but am not sure the best way to accompish this. I have a database that includes an employee table which has an Employee ID Number (EIN), name, address, etc. All my employees are listed in that table (full time as well as temps).
I also have an attendance table, which i have created a form to input the information. When a full time employee is off, they are covered by a temp. So, the form includes a field for the guard who is off, how many shifts they are off and which temp employee worked for the full time employee and for how many shifts. My payroll department needs the employee ID added to each employee (full time and temp) on the payroll report.
My Report is formated by Guard Off with a start date and end date to coincide with our pay periods. Multiple people enter info and then a bi-weekly report is sent to payroll. The report lists the employee off and then sorts by date and lists the employee working that date and shifts worked. (I hope that makes sense)
All the employee information is in one table. What I would like is when a name is selected on the form for Employee Off from a list box the EIN is automatically added to the EmployeeEIN field in the attendance table(the name in the list box is pulled from the Employee table). I also need the same for the Temp employee. When a name is selected from a list box for the temporary employee the TempEIN is automatically selected from the same Employee table based on the name selected.I can go into relationships and link the name in the Employee table with one name in the Attendance table, but not both.
View 9 Replies
View Related
Sep 14, 2006
I have stumbled through making a few new forms and tables for my new job, and have done alright so far (even if it takes me forever to do so), but there is one thing that keeps tripping me up. I just cannot figure out how to do it, even by looking at the designs and properties of other tables/forms.
Part of my form requires me to input location details. A table is setup with every City, State and Zipcode for usage on the form. Our old form was designed to auto-fill (is that even the right term?) the City and State fields upon entry of a Zipcode. These are all coming off the same table, and it works on our old form, but I cannot seem to replicate it on the new one.
I have 2 other issues with the form, and they are also both related to this auto-fill/auto-lookup hangup. Another table is set up with employee IDs, and their corresponding Last name, First name and Middle Initial. I'd like to be able to type in the ID and have the next field automatically enter the corresponding name. Similarly, I need to enter certain other data, and I would like the next field to fill in a short description of said data.
Can anyone help me or point me in the right direction? Like I said, I've pretty much made everything else work by learning from the designs of other tables/queries/forms we have, and by trial and error. But this final hitch seems insurmountable.
View 2 Replies
View Related
Jul 31, 2013
I have 2 tables named Candidates & Comments. CandidateID is the Primary key for Candidates and CommentID is the primary key for Comments.
I have CandidateID as a foreign key in the Comments table to link the two together.
I have a form "frm_CandidateMain" which lists a candidates details and a subform within it "frm_Comments" (in datasheet view) which lists comments that have been made for that candidate. These forms are linked by CandidateID as the Master/Child fields. This is working fine, and when double clicking the comment field, another form opens "frm_expanded" which is a pop up and has a larger field to that detailed comments can be written/read without the need to scroll along in datasheet view.
However, when double clicking on a blank line in the "frm_comments" field the "frm_expanded" form opens a blank form with no CandidateID selected, but I'd like it to auto populate the CandidateID from the main form that is currently open.
I've tried to do with with a Macro within Macro builder, but failed to do this.
View 3 Replies
View Related
Jul 1, 2015
I've got two tables, Member & VBS. They are linked (many to one) via the EnvNum. I have a form that has all the information I need for VBS. I was wondering how could I go about typing in the first and last name (each in their own field) and having access find the EnvNum and Automatically filling that in?
I know how to do it with a combo box, but we have over 300 members and usually get over 100 kids for VBS, and the kid may not be registered as a member. I thought about making a form to enter the first and last names, then have a button that would open up the registration form with the EnvNum, FName, and LName fields filled in, but I'm blanking today and can't figure out how that would go.
View 1 Replies
View Related
Aug 21, 2013
I have a form that is populated by the User via a combo-box lookup. I'm trying to get an unbound field on the form populated after the combo-box is updated; the goal is that the field will have a value from a table (other than the form source) whose record can be found using the value from the combo-box.
Say for example, the User selects an OBJECTID of 100 and the form populates. There is another table in the database that has an OBJECTID field but that also has a different code or designation for the same asset. This is the value I want to pull into this field. I have tried the DoCmd.SearchForRecord approach, but Access doesn't seem to be buying it.
Is there a direct way to reference this value into the field, or do I need to consider making a query the source of the table and going that route?
View 3 Replies
View Related
Feb 16, 2013
I would like a field on a form to auto fill with a phrase after I have entered data into another field.
So if I type Yes and field A then Field B updates to Not Decided. If I type No in field A, then Field B updates to Not Applicable.
View 3 Replies
View Related
Jan 10, 2012
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?...
View 2 Replies
View Related
Apr 10, 2007
Is it possible to fill an unbound text box in a seperate form with some text "Warning.HIGH RISK" on the click event of a checkbox on a different form?
View 2 Replies
View Related
