Filling In A Column Using Data From Another Table

Jan 20, 2015

I have a list of 4300 clients. The clients' personal information and ID numbers are listed in the table BasicInformation. Another table, DiseasesAndValues lists 17 diseases and a "scheduled value" (long story short - an amount of money) for each disease. Each client has one of these 17 diseases. I would like to have a column in the BasicInformation table which shows the scheduled value for the disease that a particular client has by going back to the DiseaseAndValues table and checking to see what the scheduled value of their disease is. Alternatively, I could use a query that could enter in these values with a click of a button.

View Replies

Filling Data Down A Column In Access.

Jan 12, 2005

Is there something fast to fill down a new column into approx. 900 records with the same data similar to using Excel (Fill Down)?

View 6 Replies View Related

Tables :: Filling Some Table Data From Another Table

May 14, 2015

I currently am working on a small inventory project. I have a table with the fields "Part Number" which is my primary key, "Description", "Cost", and "Sale Cost". I have a second table that I would like to use to keep track of purchase orders. It has the fields "Part Number", "Description", "QTY", and "Cost". I would like to be able to open purchase orders and be able to select a part number from a combo box that pulls "Part Number" from my item list.

So I can enter items in to my item list and later when I do purchase orders I can go to purchase orders select my item and have it automatically fill in the description and cost in my purchase order. If the item does not exist I can enter in the item in to the item list table. At this point i'm not worried about a prompt to enter in new items if they don't exist in the item list table. I just want to my Purchase Orders table to be able to autofill description and cost by selecting a "Part Number".

View 2 Replies View Related

Access 2010 Selecting Data From A Table And Auto-filling Fields

Aug 14, 2015

I have staff table which is a lookup field on the phone call table.when the phonecall form opens I want the employee field to auto fill in the employees name from the lookup field according to there security level.so something like this

On Open
Select Case Forms!frmLogin!cboUser.Column(4)
Case X = 4'the employees security level'
Case X = Insert Table_tblPhoneCalls!EmployeeID"4" into Form_frmPhoneCalls!Employee.
End Select

of course this is a syntax error as I do not know the correct code words.

View 1 Replies View Related

Copy Data From A Column In One Table To A Column Another.

Jul 18, 2007

Please would you be able to advise me how I would copy data from a column in one table to a column another table.

But I need to only use table not a query.

Thank you in advance for your help.

View 10 Replies View Related

Add A New Field (column) To A Table With Data

Jan 27, 2008

I have a table of at least 1000 records. I want to add a new field to that table. I have the data of that field in an excel sheet. Can I import that data to the new column of my table ? If I import directly to access, access creates new set of records. I don't want this, I want my records updated.

Thanks for help

View 1 Replies View Related

Populate Table Column With Data From Another Table

Dec 23, 2004

I have one database containing several tables, two of which are associated to this inquiry:

1) tblCategories
Contains two columns: CatID and Category Name

2) tblPending
Contains many columns of data obtained through upload from a web form including a column to capture the CatID and also a column for Category Name.
I wish to populate the Category Name column based on the results of data uploaded into CatID column

How is this accomplished? This is inherited project and I have very little experience with Access so just limping along...
Specific instruction much appreciated.

Thank you.

View 1 Replies View Related

Data Transfer By Filling A Form

Mar 3, 2006

Dear All!

I'd like to ask you to help me in the following. The issue is basic I think, but not for me...

I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same values). This table is connected with one to one relation to the table which the form bases on.

(An automatic data-transfer would be desirable. If it is difficult a button will do as well.)

Please write if you have got any good idea or solution.

Thanks in advance.

BR
xxyy

View 2 Replies View Related

Filling In A Text Field With Data From Another

May 8, 2006

This is simple Access but I am quite simple so help would be cool
all I want to know is how to put text from one field into another, but not every time.
lets explain
I have an order form and two fields , one date booked , and one date requested.
if date booked is empty I want to copy the info from date requested to it, if its full I want Access to say its already booked.

its porbably something along the lines of where datebooked.txt = "nothing" then datebooked.txt = date requested.txt or something like that anyway

View 1 Replies View Related

Modules & VBA :: Filling Combobox With SQL Data?

Oct 6, 2014

I have a select statement (AlphaName and StaffName are variables) in a module that woks fine, its been tested with a basic insert. what i want to do is get this result into a combo box without creating another table?

Code:
strSQl = "SELECT [Week No] FROM [" & AlphaName & "_Hours] WHERE [Alpha Name] = '" & StaffName & "';"
Me.Week_Cmb.RowSource = strSQl

View 7 Replies View Related

Find Duplicate Data In Different Column In A Table

Sep 12, 2007

Hi

I have a customer database and would like to merge anyone who has the same
phone number or mobile number.

The table is
First name Last name Phone Mobile Email
John Smith 123
Mary Smith 456 123

So I want to find these Mr&Mrs Smith because John phone number is the same
as Mary's mobile

Can you help??

View 2 Replies View Related

VBA Help : Exporting Column Names With Data From One Table To Another

Feb 12, 2008

I have an Access table say Tbl_People that looks like :

ID1-ID2-Name-Age-Location
xxx-yyy-Mike-25-Essex
uuu-vvv-Jack-32-Surrey
mmm-nnn-Bob-36-Newcastle

I want to transfer this data into another table say Tbl_Output with four columns in the format below:

xxx-yyy-Name-Mike
xxx-yyy-Age-25
xxx-yyy-Location-Essex
uuu-vvv-Name-Jack
uuu-vvv-Age-32
uuu-vvv-Location-Surrey
mmm-nnn-Name-Bob
mmm-nnn-Age-36
mmm-nnn-Location-Newcastle

In Tbl_Output's 3rd column, only the Columns names: Name, Age and Location are repeated for each person and not column names ID1,ID2 (only its data xxx,yyy etc. is required in columns 1 and 2 as shown).

I was helped by rpeare with a VBA module that gives a single column output in Tbl_Output as

Mike
25
Essex
Jack
32
Surrey
Bob
36
Newcastle

The code is:

Sub main()

Dim db As Database
Dim rstElements As Recordset
Dim sName As String
Dim sNumber As String
Dim sArea As String
Dim freefile
Dim Filenumber As Integer
Dim sSQL As String

Set db = CurrentDb
Set rstElements = db.OpenRecordset("tbl_elements")
rstElements.MoveFirst

sSQL = "DELETE * FROM Tbl_Output"
db.Execute sSQL

Do While rstElements.EOF <> True
sName = rstElements.Fields(1)
sNumber = rstElements.Fields(2)
sArea = rstElements.Fields(3)

sSQL = "INSERT INTO Tbl_Output (OutputField) SELECT '" & sName & "'"
db.Execute sSQL

sSQL = "INSERT INTO Tbl_Output (OutputField) SELECT '" & sNumber & "'"
db.Execute sSQL

sSQL = "INSERT INTO Tbl_Output (OutputField) Select '" & sArea & "'"
db.Execute sSQL

rstElements.MoveNext
Loop

Set rstElements = Nothing
Set db = Nothing

End Sub

How can this be modified to get the required format data above? Thanks for any help in advance

View 4 Replies View Related

Queries :: Copy Data From One Column Into Another Of Different Table?

Jun 9, 2013

I have two tables pertaining to the same database.

Table [Purchase_Order_Details] amongst many fields have Columns - (Purchase Order #) which is the Primary Key and (Work Order #)

My second table [Order Details] also has a column (Work Order #) . Now I have added another column to this table i.e. (PurchaseOrderNo) - this column is blank as of now.

However I would like to run a query to fill the (PurchaseOrderNo) column depending upon the (Work Order #) which is present both the tables.

View 14 Replies View Related

Filling Up A Table From Another

May 23, 2007

Hi all:

I have an inventory table, and I wish to pick items from that inventory table and populate an order placement table.

In oracle, clicking one of the item windows in the form provide with a LOV (List of Values), and usually items are picked from there.

How do I achieve this in Access, and it does not have to be LOV as in Oracle.

I shall be thankful for your kind help.

Regards - Prabir.

View 4 Replies View Related

Filling Table?

May 30, 2005

I have a table:

Product:
Code | Name | Description | Price

I have a form with a text box. i want whatever i write in the text box to be inserted in the table Product under Code.
Its like im inserting a new product.

How can i do that? Im new to Access and VB, so bare with me.

Thanks alot

View 1 Replies View Related

Make-Table Action Query Column Data

Jan 30, 2006

I use a Make-Table Action query to import data from a linked table into my database. The linked table is on a network server that is automatically updated.

One column of the linked table is named "QTY/PARTIAL" and approximately 10% of the 500 records have a "P" after a number i.e. 1000 P. I would like to separate the number and the P into separate columns in the new table to faciliate being able to compute the total number "QTY".

Thanks,
Gunner...:confused:

View 12 Replies View Related

Filling In Other Text Boxes With Corresponding Record Data From Query

Nov 28, 2012

I have a query that selects records in a certain date range. Then I have a textbox that gets an input of the earliest date of that range... I used the code...

=DMin("<field name>","<query name>")

What I want to do is fill in other textboxes next to that one with the other fields' data for that corresponding record. So for example, the query runs and outputs the data and part number 2123 was ordered 10/2/2012, which happens to be the earliest in that particular date range. So the one textbook does work and outputs "10/2/2012"...Now I want another textbox right beside it to output "2123".

View 1 Replies View Related

Filling A Table Using Combo Box

Dec 21, 2004

I have one table (tblComplete) with a listing of 30-50 company names and associated information...

"tblComplete" has fields: AutoNumber, Company, Address, City, State, Zip, Phone

On a form I created a combo box linked to AutoNumber and Company to drop down the list. Once the 'company' is selected, I would like it and the rest of the fields (address, city, state, zip, and phone) to go into the blank table (tblSelected).

Could I use a Macro to do this or should it be a query?

View 9 Replies View Related

Filling A Table Using Combobox On A Form

Feb 26, 2005

I have a basic design question that I am not sure how to address.

I am trying to build a simple data entry database with a form to take input from the user, store the values in a table. Once the data is gathered into the table I want to use this table to print a report of each record (entered using the form before).

To achieve this objective, I made a form (frminput) with some text fields. Most of the fields on this form are Bound fields to a query (qrymaster). One of the field is a Combo box (whose value is shown from another table). I have designed the RecordSource of this Form to be a Query (qrymaster).

This is a basic Data Entry form where the user selects the Combo box item and based on what he selects, some of the fields in this Form gets pre-filled. The rest of the fields on this form are bound to the query "qrymaster" and the user has to type these fields manually.

Now, I want a Save button here that would save all the values on this form to the table "tblmaster". How do I do this efficiently keeping in mind all the normalization laws on the database?

At this time, behind the Save Button, I have included a SQL statement to insert all the field values into the table "tblmaster".

I am sure there is a better way to do this. Can someone point me in the right direction please?

Thanks.

View 3 Replies View Related

Filling A Table Field With A Query Result

Nov 23, 2004

I have a query_ReimburseResult
that counts the yes/no answers in field Reimburse from tbl_Survey.

How do I take the results from the query and put it into a field in another table?

I have tbl_Result and a field called ReimburseResult. I set the type to long integer and then what?

thanks!

View 2 Replies View Related

Filling Multiple Columns In A Table From One Combobox?

Oct 22, 2014

I know how to have multiple columns fill a lookup in a combobox both from a table and a query. But I need to have the other fields that aren't saved by the combobox saved in the neighboring columns. So, my primary table is a master list of chemicals to be analyzed along with their respective registry numbers. I know what most of the programmers say about repetitive data being bad form etc. These names and registry numbers will NEVER change, so I'm not worried about a change causing problems later. I'm trying to build a separate tables that will have specific chemicals and the methods that they are analyzed under that effectively copy from the master list, but add their own quality control criteria. Further more, not all of my clients need all of the chemicals that are available for every method. It should be noted that not all chemicals are analyzed by the same methods and that some methods will have some of the same chemicals as others. I need the registry numbers because this is what the analysis software uses to uniquely identify each chemical and I need the name because names are easier for me. Long story short, I need both of these pieces together. It was suggested to have a macro copy the remaining columns from the dropbox in the table to the other columns in my table, but I'm not sure how to do this (I'm still very new to Access and my VB is very rusty). I understand how to do this for a form, but when client reporting lists become involved later on, this will make my database very bloated to have a form to populate each respective table.

View 1 Replies View Related

Queries :: Run A Simple Update Query To Copy Data From One Column To Another Column

Sep 24, 2013

I am trying to run a simple update query to copy data from one column (Addrl1)to another column (Working_Addrl1) within the same file and I can't for the life of me figure it out. Then I need to repeat for addrl2 and addrl3 to working_addrl2 and working_addrl3.

View 7 Replies View Related

Modules & VBA :: Input String In Column Based On Data In Another Column?

Nov 30, 2014

I need to input a string into a column named "EventType". The code should first check if the column "Agent Name" contains any strings. If there is none, it will input "IBM Director" into the EventType column.

Once it has looped through the agent names, the code will then loop through the Details column and input into EventTypes based on what is displayed within the string.

These are the codes that I am using to achieve this, however nothing is being input into the EventType column.

Code:
Private Sub Command11_Click()
Dim dbs As DAO.Database
Dim rst As DAO.Recordset

Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Final")

[Code] ....

I think the problem lies with the code that checks the agent name. When I removed it, it managed to populate the EventType column based on the details. But I still need to find out how to check the agent name too.

View 4 Replies View Related

Forms :: Subform Not Filling Required Info Into Table

Mar 15, 2013

I have a database which has been in production for quite a few years, it even made the swap from .mdb and .accdb without losing any of the functionality. Well I just had to export from access to new access to start a new file for one of our projects and now one of the subforms is not adding information into the table. The way the subform functions is it feeds information to the table Lease Tracts, at the same time it has another table Xrf Property Tracts Leases (I didn't pick the name and it drives me nuts too!)

When a user starts to add information into the subform the table lease tracts generates an auto number "tracref" which it adds onto the line where the user is inputting the rest of their information. The relationship is set as all alike between xrf and lease tracts to input in both tables, well the xrf lease num1 is being filled in by the master/child setting but the lease num1 on the lease tract is the only field not autofilling.

View 3 Replies View Related

Moving And SORTING Multiple Column Data Into One Column

Feb 25, 2008

Hi. I have a question I'm hoping someone can help me with. I would like to take data from multiple columns and put the data into one column. Additionally, I do not want to exclude any data (union all) and I would like to group the resulting union by another field. For example:

Original data layout:

Column Headings: Sample Event, Depth 1, Depth 2, Depth 3,
1st Row Data: 1, 6, 9, 12, 9
2nd Row Data: 2, 7, 9, 8, 3

Desired data layout:

Column Headings: Sample Event, Depths
1, 6
1, 9
1,12
1, 9
2, 7
2, 9
2, 8
2, 3

So far I'm using the following SQL. What do I need to add or change to get my desired result of grouping the unioned depths by the 'sample event' field?

I appreciate any help anyone may have to offer. Thank you.

SELECT Depth1 AS Depths
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth2
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth3
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth4
FROM Depth_Velocity_Substrate_Correct
Union all
SELECT Depth5
FROM Depth_Velocity_Substrate_Correct

View 5 Replies View Related

How To Highlight One Column And Change All Data Inside Of That Column To Same

Aug 18, 2011

I have a Access 2003 file and I want to filter anywhere where there last name is "expired" and change the column first name to say "no". How do I do that?

View 1 Replies View Related