What I have is 3 tables.
Transactions table
   Trans (autonumber)
   PaymentDate

IF the user doesnt complete a required field, then an error message displays,
which is not user friendly. I need to customise the error message to say
something like "You must complete the Surname field before this record can be
saved".

Why do I get an error of  "Method CurrentDb of object _application failed
when i try to use wizards in microsoft access on my computer?   This works on
other computers, but not on mine

Is there a way, when numeric characters are entered or
imported (via Excel) into a field in a table , to insert a
predetermined set of alpha characters in front of the
imported numeric characters?

I am working on a DB to store mileage and fuel records for
a trucking company.  The data would come from trip sheets
turned in by drivers with OD entries for crossing state
lines, fuel, and stops for load, unload, etc.  The Trip

How can I add an index to an existing field using VB?
Thanks!

Can you add/edit/delete relationships using VB in Access 2002?
Thanks!

I have a DOB field in a table, data type Date/Time, format mm/dd - I am not
storing the year, it is unimportant in my project.
The problem is that we have a few records with a DOB of 2/29, Leap Day.
Every time we enter this, Access changes it to 2/01, which is incorrect.

I have a magazine that has reader service cards and I want to collect the
data from those cards and send respondents via email, fax, or label the info
on each advertizer that they are interested or picked. Example Fall issue RS
#1 is Bound Tree, but that number will change in the ...

Our school is working on collecting information on grants and scholarship
money.  Is there a sample database design that we can use?   I am not very
good at starting from scratch.  If I have something to go by I can change it
to fit our needs.  

I see (belatedly) the value of a meaningless primary key, but I'm still
floundering a bit on how to make the user interface friendly.
If I have a meaningless primary key, how do I get my users to select it?
I am guessing that this has something to do with those two column lookup

In an access db is it possible to add vba code to provide customized
validation rules on a field ? For instance, say I I have an email field in a
record, and so I want to write some code to check that the field contains a
string of form string@string ? If so can anyone point me to ...

I am using Access 2002.  I am trying to eliminate duplicate records.  When I
try to copy and paste my table structure, I am getting an "Invalid Argument"
error.  I have actually been receiving this error in a few different places
with this database.  Could it have anything to do ...

I have a table called "Seminar Dates" which has a seminar ID as the primary key and then a column with the seminar date and another column with the time.
I have another table with people who are coming/have come to the seminars.  I have created a basic look up drop down box that ...

I'm new but have a basic knowledge of Access.  Here's my dilema - I have a
survey with several types of responses.  I can figure out the tables for
simple yes/no questions or "pick from the list".  My problem is setting up a
table for a question with multiple responses.  In this ...