How do I combine all the information from a Database that has several link
tables into one query that will show everything? The fields in the tables are
the same and are arranged in the same order I just need to put everything  in
one place so it can update as information is ...

I have an append query that copies records from table 1 in Db1 to table 2 in
Db2.  The records originate peridically from another program, and are sent to
Db1 which is in a secure location, and then I append them to an identical
talbe in a database in another location where ...

I need to assign a 'child ID' number to a record based on two pieces of
information.  I have used a variation of the code below to assign a number
but now I'm having problems with it (giving me run time 2001 error).  The
number needs to be assigned sequentially based on the ...

I am a very new Access user, so I hope I manage to explain what I need...!
I am trying to build a database to record details of students attending
various classes for a dance school. I have tables as follows:
Student personal details

Hey guys,
Can you help me out with the following report?  This thing is giving me the
flux.
The below are the column titles along with their function.

Hi there, I am a new access database user and hoping someone can help me with
this problem.
I have a lookup table which I have a number of records, however, in order
for it to be linked to a data table I have to re-create the lookup table with

I need to know how to "household" a database using Access (or maybe merge
purge would be a better term?)
Basically what I've got is a list of people with their names, addresses and
other info.  I want to merge any enteries with a duplicate addresses and save

I have office 2007 and when trying to configure a DSN I am getting a message
that the ODBC driver could not be found. Using Windows Vista Ultimate 64
bits.
Where would I find the latest driver for ms access?

I have developed an employee database which includes private info.  I want
users at various PC's to be able to easily access the Next-of-Kin query only
(ie in a crisis situation) but I don't want everyone to have access to the
entire database.

I have seen several Excel templates for a personal budget but thought an
Access database would work better. Does anyone have an opinion on this or a
template they would like to share. I'm not advanced in Access by any means,
but can get around pretty well.

I'm new to Accesss (20 years in another 4GL db app), and am wondering where
the actual save/commit is done in a simple Access db. I'm used to an
environment where the user initiates and edit/new cycle, then does either a
Save or Cancel. The "hot commit" that Access appears to use ...

How can I link a sub menu Tab (in a combo box) to open a subform?
Example:
In the Combo Box, I have - Age, - Gender, - Country
And I want the Age Form to open as a SUBFORM when I click on the -Age (in

I created a form based on a query based on several tables.  Wrong terminology
I know but you get the idea.  The form is of course to serve as a way to
input data.  It has been working as I have been creating the db until today
when I tried to add some combo boxes and check boxes.  ...

I have designed a data base which I wish to install on 5 remote computers.
My idea is to link the Backend (Tables).  My question is if i change any
reports/mailing labels etc on the server data Base, do I then have to change
the design on each of the remotes.

I am building a database of Attorneys for a small law firm. The objective is
to be able to find attorneys by their practice areas. So I created look up
column with multiple values. What can I do so that some one can search the
records using only the values I entered for the look ...