Help With Populating Data In Forms.

Jun 16, 2006

See this image so you know whats going on:

http://static.flickr.com/65/168560405_1b8ea5cc82_o.jpg

This is a DATASHEET VIEW, not a table.

I have a table that has the part number, the description, and the usage.

I am stumped on trying to get just the 2 fields to populate into this subform (datasheet view), when the part number is selected. I may have several lines of part numbers. How do I go about populating this form? The user will indicate the actual quantity. The quantity changes per order, yet the usage stays the same.

Any suggestions?

Bradley

View Replies


ADVERTISEMENT

Forms Linking, Populating Data From Search

Jan 23, 2006

Hi Experts! I'm having a problem that I hope some of the experts can help me with. I am in the process of designing a database for a health insurance company that does health fairs.

I need to have a data entry form for the nurses to enter the Health Fair results. I created a form for them to search for the Employer group. They type first few letters of the group, click "find group" button and it brings up a subform (frmGroup_sub) with the filtered group. I then have the group number (field PARGRP) hyperlinked to bring up another entry form (frmHF_entry) when clicked. I need the user to be able to find the group, click on the group number, then bring up another form which autopopulates that PARGRP from frmGroups_sub into the new form, frmHF_entry and stores that group number in the table tblHF. Further, they will need to do more than one "employee" for the pargrp. So I was going to make a subform of frmHF_entry where they could enter multiple records for that same PARGRP.

I just confused myself and probably all of you...but the problem I am having is I cannot get PARGRP from frmGroups_sub when clicked to open and auto populate the form frm_HFEntry.

Here is a screen print, maybe it will help explain what I need.
http://img82.imageshack.us/img82/1065/frmhfentry1ed.png

thanks in advance for your help.

View 6 Replies View Related

Forms :: Populating A Form With Record Data?

Mar 12, 2015

I have a Form in a datasheet view and i would like to be able to double click on a record (ideally any part of the record but if not, on the name at least) and have it open up a form to that record details.

Picture 1 is the table with the records in.

Picture 2 is the form i want it to open and populate.

View 10 Replies View Related

Forms :: Pre-populating A Subform With Parent Data

Jun 2, 2015

I have a parent and sub form in dataset view.

What I would like to do is prepopulate the subform with data from the parent form when I create a new item of data..

i.e.
When I click the "+" button Field1 on my subform is populated by Field1 on the parent.

I have tried beforeupdate on both the subform properties and the subform.Field1 properties.

View 3 Replies View Related

Forms :: Populating Data From A Table With Multiple Fields?

Sep 25, 2013

I am trying to create the form so when the first field (Start Date) has a date selected, it limits the following field (Report Date) to the matching available data, and same with the third field (Production Division) on the previous two.

I also need the form to allow new dates / production division combinations, but not duplicate.

I starting working with a cascade function but got confused and not sure if that is where I should be headed.

I have attached 2 different formats of the same sample data.

View 13 Replies View Related

Populating Data From One Form Into Another

Jan 16, 2006

Hello out there,

I am looking for some really smart people to help me with a problem.

I have a library forms database full of names of tapes and CDs, like a library. I also have an order form database. I would like to toggle between the library and order form pulling information from the library directly into the order form. I need help

View 3 Replies View Related

Populating Data With Asp And Access

Nov 13, 2004

Hello all.


Does anyone know of a way to populate an access database with data, specifically 1000 entries(These entries would consist of 2 fields one of which is text and other is numbers.) to a database table?


Thank you.

View 4 Replies View Related

Populating Multiple Tables With Data

Nov 8, 2004

I haven't used access for a long time so I am very rusty.

I have a few tables but I'll just use two for an example:

Table A
Ticket No
Part No
Defect Code
WorkCenter No
Clock No
(Ticket No is Primary Key)

Table B
Clock No
Supervisor
Employee
(Clock No is Primary Key)

Is there a way for me to create a form, that when Clock No is entered it will be placed in both tables?

Thanks in advance.

View 2 Replies View Related

General :: Populating Data Between Tables

Aug 1, 2012

I have an Access 2007 database with two tables (I will call them table 1 and table 2)

Both tables contain the same two fields. (I will call the FirstName and LastName)

Table 1 has an associated Form where the user enters the two names. When the value in either one of the two fields in Table 1 change I want the corresponding field in Table 2 to automatically update with the same value that were entered in Table 1. Basically I want Table 2 to automatically replicate the same data in Table 1. So if I type the text "John" into the FirstName field in Table 1 then the FirstName field in Table 2 will automatically update with the text "John"

I am new to access and am struggling with the automatic updating.

If the automatic part is too hard then I will be happy to attach the update action to a command button.

I have uploaded my database file with the two tables for reference. I want to get the fields (for all records) in table 2 to replicate table 1 so that when table 1 updates table 2 values changes to show the same text.

View 3 Replies View Related

Populating Fields With Data From Another Table?

Mar 15, 2015

I am trying to populate fields from one table into another field in a linked table. Specifically, I have a giving table and a persons table. I have the giving table have the persons primary ID field in the giving table. I cannot seem to automatically link them if I am adding a "gift" record. The gift is a dollar amount given by that person. I have a unique primary key for each financial contribution which is supposed to be tied to a person's primary key and last name in my "person" table. Am I missing something in this design?

View 3 Replies View Related

Populating Form Controls With Old Data

Jan 10, 2013

I have a form with several controls. Among them are 3 in particular:

Vendor Price - Unit cost with no tax
Unit Price - Vendor Price w/tax
Old Price

What I am trying to accomplish is a way to track what previous costs were by having the Old Cost control populate with the Unit Price controls value when there is a change to either VP or UP either due to new cost or new tax rates.I found a bit of code online but was not able to get it to work for me...probably because I haven't a clue of how to structure it for my needs.

View 2 Replies View Related

Populating Table With Data From Report?

Aug 18, 2011

I am generating a report from my database that I would like to turn into an invoice. My report generates perfectly, but I need to add an invoice number when I print the report and I need to take the data Customer ID, Invoice Total, and a maybe other data from the report and populate the Invoice Record table. I have VB code that is generating my Invoice No, creating a new record in the Invoice Record table and populating the Invoice Record Table with the Invoice number. I want to add this Invoice No to my report at time of printing, and populate the Invoice Record Table with the fields from the report as stated above.

View 10 Replies View Related

Calculated Form Data Not Populating Table

Aug 11, 2005

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

Populating Combobox With Sorted Table Data

Jul 10, 2006

I have a client table with a field called location. On a reports form that I have, I want to make a combobox for all of the locations, so it could show all the clients from a particular location and also it would reduce the errors due to someone spelling a place name wrong. I could set the source to the location field in the table, but that would show them all in the order they come out and there would be duplicates.

Any help would be cool. Cheers
Bob

View 1 Replies View Related

Listbox Populating Data To Form - Help Needed!

Apr 26, 2006

http://forums.aspfree.com/microsoft-access-help-18/menu-list-values-won-t-pass-to-db-20951.html

Here's a page that shows almost what I am trying to do, but my question is how do I make selecting an item in my listbox pupulate date in multiple field on my form?

For instance, I want to click on a line in a textbox and have the fields "City" "State" and "Zip" all changed on my form, not just "City"

View 4 Replies View Related

Modules & VBA :: Populating Unbound Textboxes With Data From A Table

Aug 7, 2014

I want to know a way of populating unbound textboxes with data from a table without using the easy assigning data in the property of the box. I want it to be all done with code, which to me isnt a huge deal but I've yet to find answers on the web pertaining to this issue.

for example:

Say i was searching a primary key in one box and based on what ever is typed in i'd like it to populate the rest of the textboxes.

View 1 Replies View Related

Populating A Table With Data Based On Drop Down Boxes

Sep 6, 2011

I am trying to setup a database in order to demonstrate a tie in between active directory and the HR side of a business.As such, I would like to select two fields from drop down menus that reference in Department and Location tables, but use this data to actually Populate the Personnel Records table rather than Query.I know this is not normally best practice from a DBA perspective.

I have this setup already in Filemaker, just through using relationships.However, I want to move to Access, as it is more industry standard and much lighter weight, so am trying to find the best way.I have attached two pics of my filemaker database, and a zipped copy of my Access file.

View 7 Replies View Related

Populating Forms

Jun 5, 2005

I need to find out how to populate a blank form with the results of a query i.e. by selecting an item in a combo box and populating the form with the results.

Thanks,
VAA

View 2 Replies View Related

Populating Forms

Mar 29, 2005

Can a form be directly Bound to a dao recordset?
I read an article form microsoft showing it being done in ado
by setting the recordset property of a form.

View 4 Replies View Related

Populating A Field Automatically OR Allowing Manual Entering Of Data

Sep 26, 2005

I have a simple table with two fields in that table called:

1. BankName
2. BankNumber

Each bank has a bank number. For example Bank XYZ and all of its branches have the same Bank Number 123. There are 5 banks I have listed in a combo list under the BankName field. I can also type in a different bank in that same field if it is not listed in the combobox list.

Now, I want the BankNumber to automatically populate based on what I choose under BankName. If the BankName is manually entered (for banks that are not in the combobox), or if the BankName field is blank, I want the BankNumber field to be able to enter a number manually.

For example, if I go to the BankName field and under the combobox I select Bank XYZ, i want the BankNumber field to automatically populate as 123. If the BankName has a bank name that was manually entered, i want BankNumber field to allow me to manually enter a number.

Thanks for ur help. I couldn't figure this simple request out.

View 5 Replies View Related

Tables :: Relationship - Client Data Is Not Populating Into Routing Form

May 20, 2015

I have created 2 tables: Client and Routing.

Each client record is unique. A client can have 'several' routing records.

Key field in Client is 'Client ID'.

Routing table has foreign key of: Client IDFK

I created a relationship of one to many from Client table 'Client ID' to Routing table 'Client IDFK'.

I created a form for the Client table and works.

Where I am having issue is: Client data is not populating into the following Routing form.

* I want a 'Routing form' that you can lookup client info and place it into that form.
* The bottom of the form will be all the routing table fields. The new routing info will be entered into it.

My client needs that form printed for the driver. Client will have many routing forms(records) but only one client record. The driver will have one completed form for each time he picks up client.

View 3 Replies View Related

Forms :: Populating Forms From Previous Records?

Jan 26, 2015

I am following mice and am trying to build a form that lets me add a new mouse to the database. I want to be able to either enter the the unique mouse id of the mother if I know it or be taken to another form that lets me identify the mother from the females already in my system. I know this is possible because I have seen examples of it where, in the find mother form, I give the strain name in a combo box which narrows down the selection of mice in the DOB combo box which in turn narrows down the unique mouse id which is the information I really want. I then want to carry that id back to the original form to enter it as the mother id.

In an ideal world the database would recognize this id being put in for a mother and note in the mothers record that she has had a litter. The litter id, which I am currently composing of motherid&fatherid&DOB, would go into the mothers record.

View 2 Replies View Related

Populating The Same Field In 2 Forms

Feb 15, 2005

I have 2 forms. Information from one field links both forms (though it is not the primary key). Using a "open form" button I want the field on the second form to be populated with the contents from the same field on the first form, when a user selects the open form button. I imagine all of this is very doable in SQL, however I am using Access GUI to construct my database and have no time to learn SQL at this stage. Any ideas would be greatly appreciated.

View 1 Replies View Related

Forms :: Pre-populating A Subform

Apr 21, 2015

I have a Form1 and Sub Form2...Form1 is a list of tasks: Each task has a quantity of Items.The forms are in Datasheet format.I have a list of people who can only do specific tasks and at present my Form2 is able to only select the relevant people for that task.The only way to "Trigger" who can do which task is to populate what quantity of work I want them to do. ie. create a link.

Is there anyway of clicking the little + button on Form1 that it prepopulates the total quantity to Form2 therefore creating a link and therefore being able to select who can do that task.If you look at the pic I want Items in the dropdown box to pre populate with the same amout as in the Form1 Items ie "1"

View 1 Replies View Related

Forms :: Text Box Not Populating

Jul 31, 2014

I am new to access but I am creating a form on access 2010 for a Pass Request. On the form so far I have two cascading combo boxes that work great so far. The problem is that once a name is selected from the second combo box(cboFullNames) I want a textbox underneath to populate(txtOrg). I have tried using requery and refresh but it never works. The only thing that seems to pull up the information is pressing the refresh button.

View 14 Replies View Related

Modules & VBA :: Continuous Form With Data From Table - Populating Listbox From Recordset

Nov 28, 2013

I'm trying to populate a listbox from a recordset. I will explain what I'm trying to achieve.

I have a (continuous) form with some data from a table. On the form header I have a listbox, showing all (distinct) customers from that form.

The user is able to do some filtering. That all works great. But I want to populate the listbox with ONLY the customers on the form AFTER filtering.

One way I thought might me the solution was using RecordClone. But I'm stuck there. It must be something simple for an expert. I'm not entirely a newbie, at least not to VBA. Is there an easy way to refer the listbox' recordset to the actual recordset on the form?

View 1 Replies View Related







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