General :: From Given Name In First Table Search For Same Name In Second Table

Jun 11, 2013

Access 2007. I have the start of a family history database containing two tables with very similar data.

First table:
FILTERED Births 1837-2005

IDGiven_Name Location County Town Year
1 Eliza Ann England Yorkshire Leeds 1837
2 Elizabeth England Norfolk Aylsham 1837
3 Isabella England Lancashire Preston 1837

and

Second Table:
FILTERED Deaths 1837-2006
ID SURNAME GIVENAMES LOCATION COUNTY TOWN YEAR
1 FRANKLAND Alice England Lancashire Clitheroe 1846-1855
2 FRANKLAND Ann England Lancashire Clitheroe 1837
3 FRANKLAND Barbara England Yorkshire Whitby 1837

My problem; from the Given_Name in first table I want to be able to search for the same name in the second table probably using the Town field to narrow the search down. As an example;

FILTERED Births 1837-2005
ID Given_Name Location County Town Year
16 Birtwistle England Lancashire Haslingden 1838

FILTERED Deaths 1837-2006
ID SURNAME GIVEN NAMES LOCATION COUNTY TOWN YEAR
18 FRANKLAND Birtwistle England Lancashire Haslingden 1838

This show that Birtwistle died as a child, but it is also an easy match to spot due to the unusual given name.

View Replies


ADVERTISEMENT

General :: Search Fields From Table B And Populate Into Table A

Jul 23, 2013

I have a table called BID with the following fields

bidder, seller, iid, starttime, bidtime, and bidprice

bidder is an id number that is reference to uid of table USER

the USER table have the following fields,

uid, uname, city, and state

I created a BID form for the user to enter data into the BID table. What I am trying to do but is having trouble with is have the user search for their name that may already be store in the uname field in the user table, and what ever they choose base on their search, the uid of this uname gets store into the bidder field of the bid table.

I still have a second step where the user in the bid form can search the iid but shows the itemname from the item table, and the value of seller, iid, and starttime from the auction table gets populated into the bid table.

iid from the auction table is reference to the itemtype and the following fields exist in the itemtype table.

iid, itemname, description

View 14 Replies View Related

General :: Search A Table Using Part Of A Field

Jul 24, 2014

We have a form with a field Drawing No from the Table Job Register

I want to be able to take the first part of the drawing number and display all matching items from the quote details table.

Aesthetics I can sort later.

I've created a query Item History.

My intention is to have a command button on the form Job Register that runs the query qryQuoteHistory displaying matching results.

My issues are as follows:
drawing numbers are sporadic in length and information ie:
kk80
a2-19520
a2-19520 rev a
e8
1128215 issue d

Retrospectively I would have had issue or revision number in a separate field, or better yet have a products table and link the info there. Unfortunately this isn't the case.

View 14 Replies View Related

General :: How To Search A Table Based On A List Of Keyterms

Apr 7, 2014

I have a master data table containing 4 columns and ~ 500K rows. I have a list of keyterms from column1, column2 and column3. How do I use Access to search the masta data table and return the corresponding column4 value for each row on the list.

View 6 Replies View Related

Search Record In Other Table And Show Result On Current Table

Apr 11, 2012

Actually I have a small form of customer details, that i made in excel, the field name mention below,

Customer Details Table
First Name
Last Name
Contact Detail
Address Detail

Postal Code
Last Purchasing Date
Remark

Now i want to make a search form like this

Search Form

Contact Details

& the result is show which I insert the contact number.......

View 1 Replies View Related

General :: When Transfer Data From Table In Excel To Table In Access / It Loses Format

Jan 29, 2015

When I try to transfer (ctrl c + v) data from a table in Excel to a table in Access it loses format.

Exemple: $ 1.000,00 (Excel) become 1000 (Access).

I need to keep the format to make sure that the code works properly.

View 9 Replies View Related

General :: Copy Data From Local Access Table To Linked SQL Server Table?

Jan 13, 2014

I have an MS Access accdb with linked SQL Server 2012 ODBC tables. I am working on a procedure to copy data from local tables to these linked tables (identical schema). I did a simple

Code:

DoCmd.RunSQL "INSERT INTO linkedTable SELECT * FROM localTable"

This works, but is very slow. Way too slow. (INSERT copies the data one record at a time).

I would like to copy the data in a bulk operation, or operations that I can execute programmatically.

View 1 Replies View Related

General :: Possible To Have Data From Linked Table Automatically Update Into Existing Table?

Aug 17, 2012

I have one DB that is used for creating/storing customer ID's, and another DB that is used for creating/storing job information for customers.I have linked the table from the customer DB to the job DB.

There is a table in the job database that holds customer name and ID, and some VBA that generates unique job codes.

Is it possible to have the data from the linked table automatically update into the existing table?

View 1 Replies View Related

General :: How To Cleanly Convert A Linked Table To Local Table

Apr 1, 2015

I have a database that is designed with a front and back end, with the FE linked to the BE. Some potential customers want to play around with the database, and the easiest way for me to get them access to it would be for me to combine the FE and BE and just give them a copy of that. how to link a table, and I know how to import a table. What I'm unsure of is how to cleanly convert a linked table to a local table.

View 2 Replies View Related

General :: Can Create Extra Sub Table Under Sub Table Already Created

Jul 19, 2012

I have two tables. The first one is as follows:

MP No (Primary key), Sales, Date Entry, Specs, Email

The second Table is as follows:

MP No, Quantity, Description, DWG, Price

There is a "one-to-many" relationship between the two tables through the MP No field so whenever I go to the first table there is a sub-table for each MP No. Correct?can I create an extra sub table under the sub table already created?

View 10 Replies View Related

General :: Combo Box Referencing One Table - Inputting Value From Different Table

Jul 11, 2013

I am trying to use a combo box to select the Company in an input record form for my Transactions. In the Transaction table, each record contains the Company ID, but not the company name (I have a relationship with a Company ID primary key in a separate table that has all the companies information).

I would like to be able to select the proper company in the combo box and have the form save the value as the Company ID number with the rest of the input data in a record (it will then refer to the correct company name in the other table if I query it because of the ID key).

View 3 Replies View Related

General :: Save Table Width (table View)

May 15, 2015

Is it somehow possible to save a table's width while in table view in A2003? I tried several things and can't find it on the internet.

View 10 Replies View Related

General :: Importing Data To A Table And Appending To Another Table

Aug 24, 2014

I have to import a file from an external website into a table (tableA) that I have established. The issue is that I don't need all that data, just specific ones (the website does not allow me to select the specific data to export). I created another table (tableB) to capture the data that I require for my report.

How do I take raw data from tableA to append to tableB the required fields that I want?

View 3 Replies View Related

General :: Automatically Fill A Table Using A List From Another Table

Jan 30, 2014

I have a table being filled everyday that contains the following:

ID
EntryDate
Ward_ID (linked to the Wards table)
Census

At present, the data encoder manually chooses the ward via drop-down list to identify the ward, and fill the census field. Since we have 20 wards, we find this exercise eating our precious time (since we have tons more of data to enter aside from the census). I'm wondering if there's a way to automatically list all the wards in the table in a specific date, so that the encoder would just proceed in filling the census per ward.

One idea thrown was to design the table like an excel sheet (each ward has its own column). Another idea was to make individual tables per ward and make a default value for the ward_id. However I think these two are not the right directions.

View 10 Replies View Related

General :: Update A Field In One Table From Another Table Via Forms

Apr 26, 2013

I'm trying to update one table's field, via a Form, with certain data from another existing table in my DB when I enter key data in this first form. Example:

Table Equipment ... Some columns... Year, Make, Model, LIcPlate, etc.

Table Fuel ... Some columns... Year, Make, Model, LicPlate, Fuel Dispensed, Milage, etc.

Form for Fuel has Year, Make, Model, LicPlate, Fuel Dispensed, Milage, etc. BTW, it will take Year, Make and Model to fully qualify the search/lookup as there may be more than one occurrence of a Year and Make in the Equipment table, so Model is necessary to fully qualify. . Yes, something like VIN would be a simpler lookup but remembering a VIN is much harder than entering a Year, Make and Model.

In a Form over Table Fuel, I want to have the LicPlate field (possibly other fields as well) automatically updated from Equipment Table when I enter the Year, Make and Model in that form.

I'm assuming the solution involves creating VB code, of some such, via an Event (AfterUpdate) or some such built through the LicPlate field in the Fuel form. A mass Update via SQL is not appropriate.

View 2 Replies View Related

General :: Using Checkbox Form From One Table To Populate Another Table

Dec 11, 2013

1. I have a table which lists all of the equipment we use in our company and would like to use it as a template in a form so that users can select a checkmark if the equipment is being used that day. The checked items would then be used to populate another table which records all of the equipment the user has selected. I thought the checkmark method would be best so that the user can scroll through the list of equipment and select multiple pieces for the day. The reason I don't use a multi-value field is so that the user can also enter quantity and hours of equipment used in the same table when they scroll through the list.

2. Once all of the equipment pieces have been checked, I would like the user to be able to click a review button which would navigate to the next form with all of the selections for the day. This new form will have the option to go back to the first form if any corrections need to be made. And also have the option to submit the results.

3. Once the user is finished with their selections, the user can then select Submit which will finalize the recorded equipment table and clear the checkboxes and any inputs from the equipment template table (without modifying anything) so that it can be used for the next day and so forth.

I am using access 2013...

View 3 Replies View Related

General :: Linked Table Manager Looking For Old Table Name

Jun 20, 2014

I have a database that is used in our office. It is split with the backend stored on a network share.

I need to make some updates, and to do maintenance I usually make a copy of the frontend/backend to my desktop, and use the linked table manager to switch to using the local copy of the backend so I don't mess up the main data. All good so far.

however, I recently added a new table, and originally called it "overRides", I then decided that "adjustments" was a more suitable name and changed it.

Now whenever I try to switch from the main backend to my local copy I get a message when relinking "adjustments" that Access cannot find the object "overRides" and to make sure it exists and the name is spelled correctly...

I have been just deleting the linked table and reimporting "adjustments" but this issue keeps coming back and it's driving me nuts!

How can I make Access forget that this table used to be called "overRides"?

View 6 Replies View Related

General :: How To Create New Table To Be In Back End Table

Sep 30, 2013

I split my db to front-end and back-end. 20 users are using the database. But now I have the problem: In my admin front-end db I created a new table and some reports to the table, but this new table I have only in my front-end db and it doesnot appeares in back-end db - so that other users has no data in hte report for the new table. How I can create new table to be in back-and table too?

View 5 Replies View Related

General :: How To Add New Records Into A Table From Another Table

Oct 9, 2013

I would like to know how to add new records into a table from another table.

I have 2 tables A & B.

A is the main file and if customers wanted to add new data into table A and if he clicks on add records in table A then table B needs to open. So that they want to add records in Table B. Later we will update table A from B.

I used macros to do it but it's not fine.

View 1 Replies View Related

Search A Table

Sep 15, 2006

Apologies if this has been covered lots before, I searched and couldn't find anything. I am very new to this side of Access so simple instructions would be appreciated. I'll try to explain it as clearly as I can also.

I have a table with a bunch of fields detailing a job going through our factory.

There are hundreds of these records, so the user must be able to search to view only the ones they want to see.

So I created a form with some combo boxes/text boxes, each labelled for a different field, so they can choose PO number, customer name, supplier name, out date OR job status, and view all the records with a certain criteria attatched to one of those fields.

Problem is, I want them to be able to search for all jobs from a certain supplier AND a certain outdate. Or any combination of those 5 fields, maybe filling in all of them, or 4 or 3 or 2 or just 1. At the moment they can search by one of them, then press the button, and I have a different query for each one.

Have I explained that well enough? Please ask if I need to make something clearer. Hope somebody can help.

View 1 Replies View Related

Populating Table After Search On Another

Jan 8, 2008

Hi, Im trying to, upon the click of a forms button, search the records in one table for all records matching a certain number. I then want to update another table with all these records...but am stuck in the coding. This is what i have so far...

Set db = CurrentDb()
Set rs = db.OpenRecordset("tblAllInfo", dbOpenDynaset)

With rs
.MoveFirst
Do Until .EOF
If .Fields(1).Value Is 1 Then

event_num = .Fields(1).Value
Sport = .Fields(2).Value
team = .Fields(3).Value
Date = .Fields(4).Value
Time = .Fields(5).Value

rs.Update

Set rs = db.OpenRecordset("tblCurrentEvent", dbOpenDynaset)
rs.AddNew
rs![Event_No] = event_num
rs![Sport] = sport
rs![Team_Player] = team
rs![Date] = Date
rs![Time] = Time
DoCmd.OpenForm "frmInfo" 'whose record source is tblCurrentEvent

But I really need to be updating the latter table within the loop but dont know how to do that without resetting the loop pointer?? Or would it be better to create a form for tblAllInfo. Any help would be appreciated! Tania smile

View 9 Replies View Related

Search All Field In The Table

Jan 25, 2007

Hi everybody,
How I can set a query to search in all table fields. In my table I have around 48 fields and I want to search for particular value from combo box if this value exists in any of those fields.

View 2 Replies View Related

How Do I Search On A Keyword Within My Table??

Dec 22, 2007

Hello all, once again I would very much appreciate anyones help on what may be quite a simple issue,, my problem (or one of!!) is as follows:
I have a table that contains approx 3k records I wan to run a query that allows me to select a certain number of fields with a group. From this I mean, I have all records grouped by discipline, firstly its easy for me to determine the discipline I require (I do this in the design view by adding the discipline number in the criteria row.) next I want to find a certain number of the records that are within my chosen discipline,, the records I wan to see all contain the word ‘alignment’. I tried entering ‘alignment’ on the criteria row but that didn’t get me anything,, the field that contains the word alignment also has many other words listed…
Please help
Many thanks
Jon

View 3 Replies View Related

Advanced Search More Than 1 Table

Apr 15, 2008

Hi,

I'm a newbie (I know nothing in VBA & SQL but I'm learning) and I've a database of 10 tables. I want to make a query & form to search through these tables and display results(in a form & report) according to the search criteria.

example of my request is attached..

I can PM you my real database if you need it.

Help is appreciated

View 1 Replies View Related

How To Search Record From 2 Different Table?

Nov 4, 2006

I have 2 table in ms access (Table A and table B).I am doing a search function which able to search the record on this 2 different table. how to do that? how to set the source?

Here is the coding for me to search record just only from Table A but i would like to make it search on Table B as well.. :confused:
Private Sub btnSearch_Click()

Me.frmsubTableA.Form.RecordSource = "SELECT * FROM TableAQuery1 " & BuildFilter

' Requery the subform
Me.frmsubTableA.Requery
End Sub

View 3 Replies View Related

Forms :: How To Search Through A Table

May 27, 2014

How can I search through a table and if the record on a main form has certain words it will save a note in a record on another table.

View 3 Replies View Related







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