I have two tables, they contain:
Table1: ID1, Name1, Address1, Purchase1
Table2: ID2, Name2, Address2, Purchase2
I need a query which will show ID1, ID2, Name1, Address1 from Table1 and

That subject line will have Joe Celko apoplectic!!
Let's say I have this thing. Oh, I don't know, a car. No, a vehicle. Can we
agree that is an entity type?
Some attributes might be VIN, Fuel, Color.

I have a table with the following information: ID, Name, Address, Field4
In this table it happens to have duplicate records with identical Name and
Address but different content in Field4. I want to find how it is possible
to build a query which will remove records which have ...

Is there anyone who has some sound rules of thumb for using indexes.
I see that, for example, access automatically adds them to linked tables,
but I feel, they are probably of more use in text fields (for sorting
purposes), etc....

I have a network server with MySQL on it and I am trying to make
access update the information it has in its linked table on startup or
command.  I know nearly nothing about macros or modules.  I am
basically wanting to make sure that the data access is displaying is

I have a data entry form (access 2000) that also allows the user to add,
update, and delete records from the form.  The Delete action is carried out
in an event procedure and has the following code:
Private Sub Command28_Click()

I have two databases that I have been able to combine the two backends into
one and still have two different front ends. One front end is for creating
appointments and the other is for entering the quote information.
I tried to combine both front ends into one, but this seems to ...

I have (WH,OTHER, DRVER) in a field Pro_Code. I want to be able to calculate
how many "WH", "OTHER", and "DRVER" is in the field. At the report footer I
want it to look like this:
TOTAL WH = 9     TOTAL OTHER = 6    TOTAL DRVER = 8

Can anyone help me!
I'm trying to create an automatic printing process involving an Access
database, at present I have 9 different reports set out, what I want
is each report to print out using a PDF printer. I'm currently using

Could somebody please tell me if it is possible and if how?
I am wanting to do : Iif([DC]="*PE","Y","N")
In other word i want it to fine HZPE, AEPE, HEPE etc...
Les Stout

Can someone point me in the right direction please?
I need to use Access to e mail a variable report (in Word) to a number of individuals.
Their names are in a table called Associates, and their e mail addresses are in a field
called "E-Mail". I am not certain how to set this all ...

I have been and got Dev Ashish script Email for access 97
http://www.mvps.org/access/downloads/email.zip
My email program is Forte Agent
http://www.forteinc.com/agent/download.php

This is probably really simple, but I can't find a thread that
addresses it.  Is there any way to evaluate in code whether the
current state of the SetWarnings command is set to True or False?  I
have a Public Sub that I want to use from several areas of my

I have encountered a problem with the ldb file of a database. When
making changes to the backend databases I need exclusive access to make
changes. I usually do this at night when all users have left the premises,
but for the last couple of nights there are no users using the ...

How can VBA prevent the advisory popup "Outputting to ..." when using
Access 2002:
DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF ?
Set Warnings is ignored.