does any one know how i can make it so that when a number (15) is inserted into a field in column A, the corresponding field in
column B always enters the date that the certain #  was entered into column A.
or a good tutorial will help
im using access 2000 and the generel date/time ...

thank you
Is there any way to pervent displaying $ beside the number in table or a
form?
and use (Currency Data Type)?

I used the followinf equation in my date/time field default value
=IIf(Month(Date())>=7;DateSerial(Year(Date());7;1);DateSerial(-1+Year(Date()
);7;1))
this eqation worked fine, inspite of the function iif is not listed in the

I am dumbfounded why I get this error, becaue I have
designed databases before.
I have what seems to be three simple tables...
tblApplications

Please help me get started.  I need two forms.  Do I need
one or two tables?
Form one will include the primary key - ComplaintNo, which
is an auto number, and fields for the location of the

What i would like to be able to do is to customise the error messages that appear in Access.
For example when you create a Table and you specify that Required is set to True, if a user does not enter data into that field then a unfrendly error message appears.
How can i change ...

I have the following table:-
tblPatients
PatientID PK
Forename

This is probably a frequently asked question but I can't find an answer.  I
am working on a project that has many autonumber type fields used as primary
keys.  When I'm done entering test data I'd like to have the numbering start
over at 1 again. How can I reset autonumber fields?  ...

Access 2000 - I always include the autonumber ID field
when I create tables, and they always start with the
value of 22 instead of 1.  This occurs in existing
databases and brand new ones.  Is there an option

MS Access 2002 automatically creates an index when a foreign key (ie the primary key of another table) is added.  Is this necessary or (at least) in ones best interest in a linking table?
For example, do I need any index besides a Primary index in Table 3 below?
Table 1: Contacts
  ...

I can get "no duplicates" to wotk fine on an indexed
field but if I then create and input mask for that field
then it is possible to put in duplicates.
Thanks for any help...

Hey all, I think I'm on the right track but I'm missing something..
I've got 1 table called receive with a receiver number (not unique)
this table links to another table called purchase with a purchase
number (not unique).  I used a subform so that the receiver can enter

I have been trying unsuccessfully to create a menu where a
user could select more than one value.  However, each time
I create a menu, either list box or combo box, it will
only allow the user to select one.  I have 5 possible

What is maxium # of records per table Access 2000?

I am looking for a basic access templet that I can add questions to and have employees choose an answer A,B,C,D and, that will log there name in a report that I will need to print to see if the test was taken.  Thanks for any help you can give on a test style database.