Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Auto Populating Fields In A Table/form


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Auto Populating Fields From A Different Field
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 Replies !   View Related
Auto Populating Sub Form
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 Replies !   View Related
Populating Fields/table
I have search the forum but dont seem to be able to find the solution i am looking for. I am hoping its because it has a simple solution .......

I have a database which records grant applications for the current year. What i also have is a table which stores all the grant applications from last year and i have a search form which the user can search to see if the applicant applied last year. What i want the user to be able to do is if the applicant did apply last year - to be able to double click on the particular applicant on the search form and populate the fields in the new applicant table, show on the new applicant form, and delete the applicant from last years table. This would save the user time because they would not have to retype name, address etc. Can someone please point me in the right direction? I seem to have a mental blank with this one.

View Replies !   View Related
Populating Fields From Another Form
I deal with freight carriers and each one is assigned a code. There are over 30,000 carriers so I don't want them all in my carriers table.

I have them all in a CarrierCodes table. I would like to open a form that would allow the user to search for the appropriate carrier and when they choose it would populate that data to my Carriers table.

Any help and suggestions will be appreciated.

Thanks.

Gary

View Replies !   View Related
Populating Form Fields
I have a form based on a table named <Staff>. The fields in the form are StaffID, Surname, Name, Grade. What I am trying to achieve is that when a particular StaffID is selected, the other corresponding fields (Surname, Name, Grade) are filled up automatically. Could anyone assist? Thanks.John.

View Replies !   View Related
Control Source For Calculated Fields Not Populating Table
Hi Everyone,
I know that a calculated field on a form does not populate the underlying table. However, if I bind the field via the control source to the field in the table and set the "default value" to my calculation shouldn't the result show up in my table? This is driving me nuts.... :eek:

View Replies !   View Related
Beginners Question - Auto Update Fields Based On Fields In Another Table
I don't have any database experience whatsoever so please go easy.
I'm guessing this kind of this is extremely simple for all of you.

I'm constructing a database of network resources and devices and I'd like to automatically update the values in one field based on the values of a field in another table.

The first table is called "IP" and the fields are called "Address", "IP Type" and "Device".
The second table is called "Devices" and contains the fields "Name", "Description", "Asset Number" and "IP".

Here's an example of the tables: (ignore the "code" tag. i've only used it to align my columns properly)

DEVICES:
NameDescriptionAssetIP
XserveFile Server107203.30.144.75
ProliantXDHCP119203.30.144.15



IP:
AddressIP TypeDevice
203.30.144.75Static
203.30.144.15Static


What I want is for the Device field in the IP table to automatically update it's values based on the values found in the Devices table. In this case, the values that should appear in the Device field in the IP table are "Xserve" and "ProliantX".

I've searched through but haven't found a complete solution, just little pieces which I'm too inexperienced to put together myself.

thank you
-Tim

View Replies !   View Related
Seeking Advice! Populating Fields Based On Other Entries In Table
Last week some very altruistic folks here helped me solve a many-to-many relationships quandry, and I am hoping that there may some others out there who can help with another question.

I have a feeling this is simple, but I can't quite get my head around it, and have not been able to find it in the past forum threads, but....

I want to create a tblJobs that has information about our clients' Companies, as well as Contact. As there can be many Contacts for each Company, my current setup looks like this:

tblContacts
ContactID (Pkey)
Name
Lookup_to_qryCompanies_to_Contact(shows Contact's company)

tblComanies
CompanyID (Pkey)
Company Name
(Client info is included as embedded table based on qryCompanies_to_Contact)

qryCompanies_to_Contact
Company (from tblCompanies)
Contact (from tblContacts) (one-to-many)

In my new tblJobs, I would like to have a combo box in which I can input the company name, and then the next field will have another combo containing ONLY names of the contacts affiliated with the chosen company. (I will also eventually like to make a form that allows the same function, but am assuming that the process will be the same for updating the table trhough a form as it would be updating it directly).

Thank you for any advice!!

Blair Sly

View Replies !   View Related
Auto Entry Of Fields From Another Table
I have a simple table called CUSTOMER with contact details on there...First NameSurnameDate of BirthAddress 1Address 2Address 3Town/CityCountyPost CodeemailetcI have a second table called TOWN_COUNTY_REGION that lists all the towns and cities in the UK. Each Town/City is listed with its corresponding County and Region. This table has 3 fields...Town/CityCountyRegionThe TOWN field in the CUSTOMER table is populated by the user selecting from a list of towns in the TOWN_COUNTY_REGION table. When a user clicks the town that they are in, I would like the appropriate COUNTY and REGION fields to be automatically populated in the CUSTOMER table. So, for example, if the user clicks LIVERPOOL from the list of towns and cities, Merseyside and Northwest should automatically be populated in the other 2 fields.How do I do this ??Many thanksAllan

View Replies !   View Related
List Box: Populating Table From Form
Hi,

I have a form with various list boxes that display options based on a query. When options are selected the text relating to them is populated in a seperate text box at the side.

The problem im having is when I select options from the list box I want it to store the selected options in the table that holds each record when the form has been filled out and submitted. At the minute it populates everything into the table apart from the options selected from the list boxes.

Does anyone know how to do this?

Thanks in advance

Edit: I have got the control souurce of the list boxes set to the correct field in the table.

View Replies !   View Related
Calculations And Populating Table From Form
I hope you can help - I have two simple problems and one slightly more complicated problem (bearing in mind I'm quite an Access Novice!)

Problem 1.
I have set up a simple form for a Timehsheet where the user can select a project and then enter hours worked in 7 text boxes for Mon-Sun. Then I have create a Total Text box at the end of the row. I need the Total box to Sum up the hours from the 7 boxes dynamically. How does one do this?


Problem 2.
How do I then ensure this calculated field populated the field hoursID in tblHours? (I am able to do this with a normal field, but with a calculated field, doesn't the formula go into the Controlsource field??)



Problem 3.
I plan to put this form as a sub-form into a main form 4-5 times so that a user can select 4-5 projects to enter hours against. I would like to have a SUBMIT button on the main form, so that all the calculated hours and selected projects populate the respective tables ONLY after this button is pressed.

Can this be done?

Thanks in advance!

Sunil

View Replies !   View Related
Auto Populating A Field
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 Replies !   View Related
Calculated Form Data Not Populating Table
Hi all ... been awhile since I have had to create a database so I have gotten a little rusty. :eek:
I have a form where some of the fields I have formulated to calculate an amount. Example... =[GrossAmt]*[FeePercent] This is calculating into the form correctly but not writing to my table for that field. What am I doing wrong or missing here?

View Replies !   View Related
Auto Highlight In Form Fields
Hi guys

I just built a tracking database (I can't post it because it contains PHI, and I do hope I don't have to) and it's been giving this issue starting today.

When I am in a field the cursor automatically goes to the end and highlights everything between the end and where I click. So if I mistype the third character I need to delete everything from the end to the third character to edit it.

It just started doing this when I loaded it up. Does anyone have any idea?

Thanks

View Replies !   View Related
Auto Populate Fields On Current Form
Hi. I tried to find out if this issue was already posted, but did not find. If anyone can help me, I am trying to auto populate two fields on a subform. The field I want to populate is the description of a role. So if the user selects the role name from the combo box, the description field will automatically update. Thanks.

View Replies !   View Related
Populating An Underlying Table When Using Cascading Combo Boxes In A Form
Hello everyone

I have read the FAQ on cascading combo boxes and have managed to apply the theory to my DB's data input form (frmDataEntry) which is very cool and prevents a lot of errors however in doing so it no longer populates the underlying table (tblProductionDetails).

I am at a loss as to how to correct this as you can see from the example I need the customer and description field to be populated with the correct data rather than the fields I am using to make the cascading combo boxes work.

Any help would be greatly appreciated

Regards

Adrian

View Replies !   View Related
Auto-populate Fields In A Form Using A Command Button
Can someone help me figure out how I can create a command button on a form that will prompt the user to enter a file # (or similar data) and that will auto-populate all the fields in the form from the underlying table? I hope this makes sense. Any and all help is greatly appreciated.

View Replies !   View Related
How Can I Configure A Table To Auto Data Entry Into Fields Based On A Previous Field
My situation is this. I have 3 tables that I have imported from my mainframe system, between these 3 tables I have the data of product code, description,supplier code, supplier name, order method, and ABC code.

I am trying to create another table that I can capture daily Out Of Stock data for products.

What I would like to do is to enter the product number in the first field of my new table, and then the remaining fields will auto populate with the correct details based on the product data stored in the parent tables that I have imported.

How can this be done?

View Replies !   View Related
Populating Fields
I am looking to populate fields of one form based on another table with about 100 records.


Information
Table Name: 1) StaticInfo
2) Data

Form Name: EntryForm (Based on the Data table)

I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.

Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.

So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?

Also, could someone provide a method as to how I would go about populating these fields from table to form.

View Replies !   View Related
Populating Fields
I am looking to populate fields of one form based on another table with about 100 records.


Information
Table Name: 1) StaticInfo
2) Data

Form Name: EntryForm (Based on the Data table)

I want to be able to select a value in a combo box in the EntryForm and have certain fields populated in that form based on the StaticInfo table.

Want to use all of the fields in StaticInfo to populate the same fields in Data. Historical data in the Data table needs to remain intact, meaning that if something is changed in the StaticInfo table, the historical records will remain unchanged in the Data table.

So, if I am able to select a department in a combo box in the EntryForm and have the fields populated in this form based on the StaticInfo table, will the records in the Data table change or not change if there are changes made to the fields in the StaticInfo table?

I have the information in StaticInfo, which I want to be automatically entered in the form EntryForm, so that it can be saved in the Data table along with the other information that will be entered in the form. The Data table (and Entryform) contain 6 memo boxes in which data must be entered. I want to have it so that the automatically populated information comes up when someone selects a department from a combo box, then once that information is in the fields, the individual can proceed to enter their corresponding information into the 6 memo boxes available. Once this is done the individual can hit a save button and all of the information would be a new record in the table Data. Could someone provide a method as to how I would go about doing this?


Thank you in advance

View Replies !   View Related
Creating New Table From Form Data Fields/clreaing Datat Fields.
I created a form in Access that retrieves data from a table. Inside the form, I am able to access/populate data fields with data from the table. I also have data fields, inside the form, that requires key-in data. I have some how lost the ability send all data field information to a second table and clear existing data fields for new entry.

Questions: What settings, code or buttons can I use to send/store data field information to a new table? What settings, code or buttons can I use to automatically clear all data fields from my form once data has been sent to the new table?

View Replies !   View Related
Populating Fields On A Webpage
I wasn't sure where I should have posted this question so please feel free to move it if necessary.

I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful.

What I would like to do is export data directly from Access (via form, table or query) and populate it directly to an existing, external webpage.

A little background. My company orders cars an for certain manufacturers, Toyota for example, we order via a secure website. All of the other manufacturers have their order directly transmitted to them. The orders for Toyota take 3-4 times longer to place and I was hoping to speed the process by exporting existing order information directly to the webpage.

Please let me know if it seems like I am smoking something and I will gladly step away from the pipe....=)

Thanks in advance,
Brian

View Replies !   View Related
Two Fields Populating The Same Column
I posted a few days ago about how I am using a combo box for selecting/entering a name on a form. Once the name is chosen for 'txtEventLeader' it updates the query so the next record shows that name as an option for selection in the combobox.

What I want to do now is also have a field called 'txtEventFacilitator' which would also update the query and update the combobox (regardless if one is choosing the Event Leader or Event Facilitator). I think I need to make a one column query which puts all of the names in one column, regardless if they were the Event Leader or Event Facilitator.

I hope I asked this correctly.

View Replies !   View Related
Form Or Table: Auto Entered Value
Hi there

I have a small problem that I was wondering if someone could help with.

When a user creates a new record I would like it so that some html is written automatically in to a defined column.

Is this possible? I tried to use the default value property of a column but access does not like it.

Any ideas :confused:

Thanks :D

Jools

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved