General :: Auto Populating Field In Form?

Nov 20, 2013

I actually have two questions.

1. I was reviewing the Access 10 commandments and I wonder why using "lookup" is evil?

2. I am working on a db which contains approximately 14 tables. One is tblMaterialslist which contains the following fields:

ID - Autonumber
PartDescription - ShortText
PartCost - Currency
Size - ShortText

Additionally, I have a form in which I would like the "PartCost" field to auto populate when the "PartDescription" field is entered.

View Replies


ADVERTISEMENT

General :: Auto-populating Rows Based On Primary Key

Jul 24, 2012

I have an infopath form, which people in my company can fill out to order parts. The form is linked to an Access database. The primary keys for the database are the Order Number and the Line Number (where the specific part info is in the system). The form also takes info about who entered the order, when they entered it, etc.

My problem is that while the form will be used for only one order, it may be used to order multiple parts. So the infopath form has a repeating section with a table where they can enter multiple line numbers and part names, etc.If I use the form to enter just one part, everything works great. But when I use the repeating section to add multiple parts, the information specific to the repeating section is added to the database but the rest of the information (who entered, when the entered, etc) isn't.

My intial idea was that since the first part is entered correctly and the subsequent parts are missing some information which is already in another line in the database. Maybe if there was a way to pull the information from another line into the lines with missing info within access would solve my problem. So basically automatically populating the rows with matching Order Numbers with the information that is missing.

View 7 Replies View Related

Auto Populating A Field

Feb 18, 2008

In case my other question cant be resolved, I'd like to do a work around, but dont know how to do that either.

So, I have a form (Photos) with a field (PhotoTitle) and in the form is a subform containing a continuous form a (Sales).

This form contains invoiceno, location, customer etc... but also PhotoTitle field.

I've been trying to get it to populate based on a relationship and use that data elsewhere, but cant, so I'd then like it to.. on enter (or focus) automatically populate with the value from the main form (photos), phototitle field and put it into the sales subform phototitle field.

What is the code for doing that?

Thanks!

View 9 Replies View Related

Auto Populating Fields From A Different Field

Apr 19, 2006

Hi there,

I've been working on this issue for quite sometime. I've tried different methods, such as the DLookup function, but I think I'm doing something wrong. Let me explain what I'm trying to do:

This is a Work Order, the user will Select a Customer (Table Customer: Contains CustomerID and Customer Name, address, etc) from a drop down box. When they do this, I have another textbox which is designated for the Address. I would like the address to automatically populate. but its not quite working. I've tried it with the DLookup function (I entered it into the control source of the textbox). I entered the following syntax:

=DLookup("Address","Customer","CustID=" & cboCustId)

It keeps coming up with an error. I have no idea why.

Now this is just the first half. The second half I have a subform on the same main form, which lists the equipment they have on their site. The database has a number of customers with many equipment for each of them. How do I make sure that the subform only populates equipment associated with the Customer that was selected on the main form?

I hope someone is able to help me.

Thanks a lot!

View 3 Replies View Related

Auto-populating Table Field

Jul 16, 2012

I know auto-populating has been asked before for forms, but I am looking to auto-populate a couple of fields in a table based on an ID Number that corresponds to another table. I realize it is not the best practice to duplicate data in a DB, however, I am using an ID card program that requires tables to populate the ID card information. My hope is to have two separate tables for 2 versions of ID cards.

The first table is called Firefighter info with fields of ID Number, First Name, Last Name, and Firefight Certs, EMS Certs, and emergency contact information. The second table is called EMS Personnel with fields of ID Number, First Name, Last Name, EMS Certs, and other fields that will be entered manually. I would like the First Name, Last Name, and EMS Certs fields to auto-populate in the EMS Personnel table when the ID Number is entered. I have a relationship already listed between the two table that links the ID Numbers in both.

The Firefighter Info contains the information for all members of the department, regardless of whether they are EMS, or strictly firefighters. The EMS personnel table contains information strictly regarding to the EMS members. Thus, the ID number you are entering into the EMS table will always correspond to an existing entry in the Firefighter Info table.

View 6 Replies View Related

Tables :: Auto Populating A Field Based On Selection Of Other Field

Jun 27, 2014

I (will have) a form which a user fills in to enter new data.

I have two fields,

"Branch" and "Branch ID" (Branch ID will not be on the form, just in the table)

Branch will be fed by a combo box with seven choices. I would like it so that when "Branch" is populated it autopopulates Branch ID with a code which relates to the branch, so for example

BRANCH BRANCH ID
Braintree BRA
Colchester COL

View 4 Replies View Related

Tables :: Auto Populating A Table Field

May 30, 2013

I have the following tables:
Inquiry (This is the main table I want to populate through the use of a form)
Programs

My question refers to two columns in the Inquiry Table
Program
Group

The program column is populated by a drop down menu that is linked from a programname column in the Programs table.

I I want is the Group column in the Inquiry table to autopopulate based on the selected programname (There is a group column associated in the Programs table) so the form field will be autopopulated.

What I have tried is autopopulating the form (form name is Inquiries) Field called Group by using =[Program].[Column](1) in the source code of the text box. This works well, but it then does not populate the main table.

I need to either
- Learn how to populate the main table column called Group based on the form autopopulating
or
- Learn how to autopopulate the column Group in in the table so the form will autopopulate

View 3 Replies View Related

Auto Populating Sub Form

Aug 8, 2005

I’m fairly new to Access so I hope I can get the terminology correct. I’ve been working on creating a database which has a one to many relationship. With the help of the people in the table forum, I do have that working correctly, and even have a form and sub form where the data can be successfully input.

In short, I have a main item table to track my widgets. I have a reference or look up table of colors. Third, I have a relationship table that manages the one to many relationship. My main input form has all the fields that need to be plugged into the primary table. The Sub-Form is setup for continuous forms which allow me to input as many colors as I need. Again, this all works great.

Now, to go to the next level. There are times when I want to select many (lets say 8) different colors to my widgets (kept in the primary database and form). To select each all 8 colors each time is somewhat of a pain. It is my hope and intent to create a button on my sub form that would populate my subform with the static 8 colors that I want, thus bringing me down to a single click instead of 16. (1 for the drop down, 1 to select the color).

Is this at all possible? If so, can someone give me a shove in the right direction?

Structure as follows:
TblWidgets
•Widget – Text
•Value – Numeric
•Description – Memo
•Type – Text

TblColors
•Color - Text
•Description – Text

TblWidgetColorRelationship (one to many relationship)
•Widget – points to primary key in TblWidgets
•Color – points to primary key in TblColors

Thanks,

Joiry

View 5 Replies View Related

General :: 2 Field Look Up To Auto Fill Another Field On Form

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

Auto Populating Fields In A Table/form

May 5, 2008

Sorry for posting into another thread about this, but here's my problem:

Hello All. Finally getting my pride out of the way and asking this. I've searched and this is the closest question pertaining to the problem I'm having. I have created a form to populate a table in Access. I've created Lookup fields for parts of the table that will get data from another table/tables. I want a certain part of the form to auto-populate data based off of the last name I put in the initial Drop-down box. Say, I have a person with a last name (and there are several with the same last names), I want the remainder of that line in the form/report to populate with his/her data needed for the form letter. Unfortunately right now, I have it where we have to select each from a drop down menu, for both last names, first names and other data needed. I've tore my brain up trying to figure out how to link the data in each one of the combo boxes to the first combo box. Any help would be appreciated. These are driving me nuts as I should be able to figure this out and it's just escaping my vision I guess. Thanks in advance for the help.

View 2 Replies View Related

Auto Populating Table From Form Information?

Sep 8, 2011

I am trying to create a form from questions listed in a table, add a yes/no column to it and then have it auto populate a data sheet with the question and the answer. how I can have the datasheet autopopulated?

View 1 Replies View Related

Forms :: Auto Populating A Form Stops After Column (6)

Apr 13, 2013

I'm using a combo box to pull data from a table to auto populate the fields on my form. But for some reason, it stops inserting the data after city (column(6) and I can't figure out what's going on. When I run the query the data is there, if I change the order of the columns, the data shows. Here's the code:

Me.txtadjusterfname.Value = Me.cboAdjusterlkp.Column(0)
Me.txtadjusterlname.Value = Me.cboAdjusterlkp.Column(1)
Me.txtadjustertitle.Value = Me.cboAdjusterlkp.Column(2)
Me.txtadjustertype.Value = Me.cboAdjusterlkp.Column(3)
Me.txtadjustercompany.Value = Me.cboAdjusterlkp.Column(4)
Me.txtadjusteraddress.Value = Me.cboAdjusterlkp.Column(5)
Me.txtadjustercity.Value = Me.cboAdjusterlkp.Column(6)
Me.txtadjusterstate.Value = Me.cboAdjusterlkp.Column(7)

View 1 Replies View Related

General :: Populating Combo Box With Delimited Field?

Aug 21, 2012

So I'm working on an Access 2007 application for my company's suppliers list, but I am restricted to using a single Excel worksheet for the back-end. One of the fields, called [Files], is a list of files in .pdf format related to a supplier. The number of files can be 0, 1 or many. I currently have this field set up so that each file is separated by a semi-colon. A sample first record in [Files] is:

K:Users est user2008-12-24-ASTM D5857-08.pdf;
K:Users est user2012-03-12APCPP25-Black.pdf;
K:Users est userDIN_16901.pdf

The front-end contains a multi-item form. I'm trying to add a ComboBox (cboFiles) for each record, which is populated by the value in [Files]. Then, selecting an item in the ComboBox should automatically open that file.

I've tried a few approaches so far for populating the ComboBox:
Setting [Files] as the Control Source results in a single item appearing as
"K:Users est user2008-12-24-ASTM D5857-08.pdf;K:Users est user2012-03-12APCPP25-Black.pdf;K:Users est userDIN_16901.pdf"

I also tried setting the ComboBox Record Source Type to Value List and created a hidden TextBox (txtFiles) with the Control Source set as [Files]. Then I used VBA in Form_Load to equate the ComboBox Row Source to the TextBox. The code is simply:

Code:
Private Sub Form_Load()
Me.cboFiles.RowSource = Me.txtFiles
End Sub

While this does create a ComboBox with the correct items for the first record, it also populates the ComboBox for all the other records with the same thing, ie. every ComboBox has the items:
- K:Users est user2008-12-24-ASTM D5857-08.pdf
- K:Users est user2012-03-12APCPP25-Black.pdf
- K:Users est userDIN_16901.pdf

I'm thinking maybe this approach could work with some modification in the code or approach. Unfortunately, I'm not too clear on why the code goes through all the Me.cboFiles.RowSource, but only once on Me.txtFiles or how to get it to check the txtFile for each row. Otherwise, I will need to figure out some other way to fill in the ComboBoxes.

Edit: Actually, I've noticed something peculiar. Each time I select an item from a ComboBox, the other ComboBoxes for the other records also change to the same item. I think this has to do with cboFiles being unbound. Changing it to bound doesn't seem to be quite right though as it just gives the same default values as txtFiles while the items are still just copied from the first cboFiles. Also, I can't actually select any of the items when it's bound. I imagine it might have to do with the read-only attributes of a linked Excel File.

View 6 Replies View Related

General :: Populating Field Based On Combobox Selection?

Oct 29, 2013

I have a table of raw materials that have two fields, their stock code and longer description.

I have another table that is tracking the usage of these materials. I want both the stock code and longer description to be recorded in the usage table.

I want the "Description" field in the usage table form to auto populate when the user selects the corresponding stockcode from a combobox.

View 3 Replies View Related

Populating A Field In A Pop-up Form

Oct 8, 2004

The pop-up will show the content of the parent form field or a literal if it is blank.

But it doesn't work. The syntax is invalid but my meaning is clear to everyone but the compile.

Private Sub Form_Open(Cancel As Integer)

If [Forms]![MeetingStatus]![List2].[Column](3) = "" Then
Set [Forms]![Comment]![Text2] = "No comments"
Else
Set [Forms]![Comment]![Text2] = [Forms]![MeetingStatus]![List2].[Column](3)
End If

End Sub

Help!

View 1 Replies View Related

Forms :: Populating Only Key Field Value Form Combo Box Selection?

Aug 10, 2015

In the Contacts Table there are two fields, the unique Contact ID key field numeric and the Contact Name. Like this:

Contact_ID; Name
1; Tom
2; Dick
3; Harry

In a form named "Selection" there is a Combo box that references the Contact table, and lists just the three names in the drop down (showing the Contact_ID is optional - I'm fine either way):

Tom
Dick
Harry

When the selection is made it will populate the field Contact_Ref the table called SelectedName.

Question: When the user selects the name I'd like the data populated in the SelectedName table to be the Contact_ID Value, and not the Name, so if Harry is selected the Value "3" would be saved.

View 3 Replies View Related

Form Combo Box Not Populating Related Field In Table

Apr 26, 2012

I have a combobox on my form with fields related to it (ie. when an option is chosen in the drop-down, the next two fields are also populated with data based on the selection made - I know this is duplication of data, it's just the way the 'powers that be' wanted it. I'm changing it in my next version of the database!)

The two fields that are populated as a result of the selection in the combobox are migrating into the related table fine, but the actual selection in the combobox isn't - it's showing up as blank in each new record in the table.

View 4 Replies View Related

General :: Field Auto Add Numbers To Value

Jul 11, 2012

I have a field for SSN. If the SSN has a 0 or 00 as the first numbers it auto deletes those numbers. Is there a way in access that when the record is visible the 0's are relpaced so that the SSN will read the 9 digit. Also i have another fiels EIN with 7 digits an i need for there to be 2 9's in the beginning. I was goingto use vba but when i go to yp it i only get .value <

Code:
Me.SSN.Value

Value is tho only option to get. IDK y it does this or how to get it to shop if there is a ay.

View 1 Replies View Related

Forms :: Populating Null Field In Form From A Different Column In Same Table

Sep 15, 2013

I've been trying to populate a field in a form with information, but only if the field is blank.

What I am trying to do is this.

I have a continuous form displaying all of our principals, however when our principals are on leave I want to populate the field with the "acting principal". I have set it up so the field grabs the acting principal first but it is blank for several schools. For these schools where there there is no "acting principal" I want it to grab the substantive principal automatically and populate the field.

I have tried Is Null, Is Not Null, NZ, IF, Where and Then statements but to no avail.

View 10 Replies View Related

General :: Auto Generate ID Where Field Is Text Format

Jul 10, 2012

I have
Table called "Products"
Field 1= "Product ID" which is a text field (PK) but numbers are used (ie 1 -20)
Field 2= Products -showing our list of 20 products

When I enter a new product, currently I have to look in the table to find the last ID used then use the next one available. I have created a form to be used for data entry to enter new products

What I am trying to do is :- 1, have the form open at data entry level but still able to scroll and see all records and 2, Have the form auto generate the next number available. For example, I have 20 products entered so when the form opens to enter a new product, the ID is automatically at number 21. I know absol nothing about coding. I have looked at other suggestions on the forum incl the DMAX +1 and having tried and not worked, I wondered if its because the field is a text field or I am trying to insert the code in the wrong place.

View 4 Replies View Related

General :: Auto Insert Date When Another Field Is Changed

Feb 25, 2015

On my form have a status field with about 7 options to choose from a combo box, i have these values set in another table. What i would like is for my other field, which is a date, to automatically change whenever the status field is changed. So i know how long ago the status field was set. So basically if i change the status to complete i want the date to then set the date and time now.

View 5 Replies View Related

Auto Populating List Box Based On Two Dependent Combo Boxes?

Mar 31, 2014

how to auto populate list box based on two dependent combo boxes.

View 9 Replies View Related

General :: Auto Populate A Table Field From Combo Selection

Jan 17, 2013

I have a Table (tblFPAData) that is being populated with entries from a form I created. There are several fields but if I can get an answer for one relationship then I can repeat it for the others.

In tblFPAData there are the fields MaterialNo and Description.

I am creating another table called tblSchedule and using a form to enter the information. I need the user to select the MaterialNo from a combo (cmbMaterialNo) and the then table auto populates the Description from tblFPAData.

View 3 Replies View Related

General :: Auto Generate A Number In Where Data Field Is Text

Jul 10, 2012

I have

Table called "Products"
Field 1= "Product ID" which is a text field (PK) but numbers are used (ie 1 -20)
Field 2= Products -showing our list of 20 products

When I enter a new product, currently I have to look in the table to find the last ID used then use the next one available. I have created a form to be used for data entry to enter new products

What I am trying to do is :- 1, have the form open at data entry level but still able to scroll and see all records and 2, Have the form auto generate the next number available. For example, I have 20 products entered so when the form opens to enter a new product, the ID is automatically at number 21.

I wondered if its because the field is a text field or I am trying to insert the code in the wrong place.

View 1 Replies View Related

General :: Creating Unique Ordered Number Field With Auto Shifting Values

May 31, 2013

I'm creating a database using existing data from an excel file full of contact details. What I need to add is a queue type system where each contact in the database has a "Place in Queue" number which is unique obviously.

Lets say Alan is number 1, Bob is 2 and Chris is 3. They have these corresponding numbers in the queue field for their entries.

Now what I need to have, through use of a form, is a way of changing Chris from number 3 in the queue to number 1 and thus have Alan automatically shift down to number 2 and Bob to 3.

View 4 Replies View Related

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 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved