When using Input Mask on Access 97 does anyone know if you
can input your own "Error Message"

Good morning.  I am new to Access databases and to date I
have done a considerable amount of research and reading
but am unable to ensure the steps I am taking in the set
up of the tables will work as I design the forms and

I need to track contracts our company has with other
companies. I thought I would create a table that would
contain CompanyInfo such as CompanyName,Address,Phone,
etc. and another table with ContractInfo:CompanyName,

Hello, I am trying to run a total [page]*[quantity] count:
Totals: (Sum(([tbl_GovTrack]![Quantity]*[tbl_GovTrack]![Pages])))
This returns the [Page]*[Quantity] to Totals
My [datestamp] has the following:

I am having problem in choosing options from the Access
documentor. The above message error message. I am using
Access 2000 on a network.
Thanks ,

I know how to make a column prevent duplicate values with
an index; however, I have a column where many values are
null which is OK, but I can't use an index to prevent
duplicate entries because it will only allow me one

I have what a believe to be a fairly obvious use for
access. i.e a company contact list where the user can add
some data to each user and company.
Basically, unlike the standard microsoft template, that

I have a DB that performs aircraft maintenance data
analysis.
It runs dozens of very complex queries on roughly 700 000
records.  I used the performance analyzer to determine

I am new to Access programming.  My problem is I have a combo box that adds a new record to the underlying bound table.  When I enter a new record I get "The text you entered isn't an item in the list.  Select an item from the list, or enter text that matches one of the listed ...

I have a database that has linked tables to another
database.  I have an absolute path set right now, but
will be distrubuting to customers.  Can the linked tables
be set with a relative path so it doesn't matter where

I remember from Access 97 that there was a 200,000 row
limitation for a Access table.  Does any know what the
row limitation is for Access XP (2002), or where
Microsoft post that type of information?

I'm sure this will be easy for you folks to sort out and I would be
grateful for some help:
I work in a lab and I need to use Access to store some data.  So, for
a particualr lab experiment event I want to store the following data

Please excuse my poor explanation in advance, I am a self taught Access user
with no programming background.
I am re-designing tables within my company's mailing list database.
Currently we have separate tables for  tblDomestic_Contacts (with a one to

Hi;
Have been searching for an answer to these two questions for some time.
Need to limit a sub-form, (displayed as datasheet), to 1 record only, and in
another form need to limit the table it's based on to 5 records.

I've been running and modifying 2 Access 97 databases for
some years now. The application consists of a forms
database and a data database.  Current size of the forms
db is about 6Meg. after compacting & repairing.  Access