I have 2 tables. Table1 has Zip Codes from many cities, also table1 has
a field(yes/no) that says "houston". Table2 has zip codes from houston
city. I want to be able tu run table2 against table1 to compare
zipcodes and if table1 has a zipcode that match table2, i want to

I have a series of reports that are sent at at various times of the
month. Each report has to be sent out either by a set date or in some
case on a set day of the week. These details are recorded in two tables
(Report details and Reports sent)

I have a form with a sub form set up.
My form has information on an individual
My sub form has information about each time that individual i
searched.

Using Access 2000
I have created a  control panel which opens mazimized on_load.
Some of the forms its command buttons control are small.  I open them
on_load

I am a rather new user of Access and am having trouble understanding th
use of formulas or as I believe access is calling them expressions.
I have fields called expiration date, status, and sign status, that al
depend on each other for their value. I want to create

I am having a major problem..a newbie!!!  I have designed a table and
when I attempt to save it I get an window with the message "Could not
find field 'TempField*0....when I check help I get  that I have
encountered error 3799...but doesn't tell me how to fix the

Easy question I am sure...I am a very newbie...
When I clear the relationships window, does it delete the
relationships?
I ask because when I saved the relationships window, it never asked me

I have a field that contains a date (say Dte_1) I would like to
introduce a calculated field that would give the date of the last day
of that month. So if
Dte_1= 11/11/2006 then new field would be 30/11/2006

I have an orders table that I have the customerID field with a one to many
relationship to the CustomerID (primary key) field in a customer table.  I
want to be able to enter a new order by choosing the customer by name from a
drop down menu.  I do not want to choose a customer ...

I'm using Access 2000 (XP pro) & have a number of reports with graphics
(check boxes, text boxes) that don't export to Word. I want to send the
reports as email attachments to non-Access users (can't use snap files). Is
there an easy way to change the check boxes in all the ...

i am having a problem with labels causing a flickering effect on forms
that contain tab control.
only labels that are not associated with a textbox.
these labels also have hyperlink property option in the properties

Hi. I am pleased to discover the recurring database developed by Duane Hookam
and hope to successfully adapt it to bookings for a new conference and
community centre I am volunteering at. I have read the threads on two
questions posted by Kelly S and downloaded the sample ...

I am mail merging 1000+ records to print postcards.  There are  4 postcards
per 8.5 x 11 sheet.  When printing publisher sends two pages of the print job
at a time to the printer.  So the printer fills with 250 print jobs (2 pages
each or 8 postcards total).  Publisher also (here ...

I have an "Import Specification" that needs editing but I am unable to
find it.
Where do I look for it please?
Thanks,

I am creating a client database for my business.  Each of my clients has
their own database of clients.  I need to keep their database of clients for
each of them.   Is it possible to creat a contact within a contact