Dear friends,
In an application handling books, I have a field, Data Type=Number(Single),
in the tblCategories table holding the Category number, related to tblBooks.
It’s a two-level list, manually created. The descreptions in level one are

I am trying to eliminate the MS Access Default Error Message for [Required
Field} in a table and create my own when checking for Null or Empty Values in
a "Text" field.
This is what I have tried without success:

Are Primary keys needed in child tables?
How important is having a defined primary key in child tables?  
Here is my dilemma; I have 35 groups running around come desert country.  I
having them send updates to a central database with something like XML files

I have been setting up a simple database and now I know
that everything is working OK, I would like to clean up
the tables so that the PK numbers start out fresh.  My
tables are all empty and I have removed all the

In AccessI can't get the tools option to turn orange, to activate it.

I need to build a roster for my choir as well as track the members attendance
by rehearsal dates, ministry dates as well as pull number the of absences,
late arrivals etc.  I'm just learning access, but know some excel.  Any
suggestions?

Many times when I create relations between tables, and saves it, when I
reopen the relationships view, everything there is messed up.
Sometimes tables are even "run" outside the screen edges. I can only see the
relation line, and can't reach those tables.

I have an 'accounts' table with the 'accountnumber' as the primary key.  I
have several other tables such as 'transfers', 'systematic plans', 'loans'
etc. with the 'accountnumber' field set as a lookup column in each of these
tables.  When I open the 'accounts' table in datasheet ...

It would be nice to see Access with the ability to have special text effects
like Word has.  I have been trying to make my Access Database stand out a
little with something snazzy.  I tried to making a word document with the
special text effects and then linked the document in my ...

I've been developing a DB in Access 2003 and have been saving it under the
2000 file format. My deployment enviroment runs Access 97; I thought I would
simply use the convert Database command. It's not working! It gives me a
invalid data type error; the ensuing message tells me ...

I have 2 tables, one containing information about the staff of an office
(names, address, tel, etc.), and the other one containing their salary
history (StaffID, salary, date of salary modification). The 2 tables are
related by the field StaffID. Salaries for each staff are not ...

I've noticed that the hyperlink datatype defaults as a web hyperlink.  Can
that default be changed to an e-mail hyperlink where it would add "mailto:"?
Thank you in advance for your help,
Ellen

Assuming no special code, just plain jane stuff.
Will a set of tables and forms created in Access 2000 work ok in
Access 2002 or 2003
I'm trying to create some templates and I only have 2000 here.

I am trying to create a database of  school information.  I have tables for
the school name, campus address billing address...  95% of schools only have
1 campus and billing address but some do have more than 1 address.  It seems
like a waste to make all of the address fields 1 ...

I have put together a water quality database. I have one table that shows
alls the characteristics of my water quality stations (name, location,
description, lat, long etc...). For example one station name (or ID) was PR-1.
Another table that is linked to the station table through ...