TIA for your help:
Noticed that Access 2002 automatically truncates trailing
spaces in data upon entry.  Is this an option and if so
where is the option set?

I have a database for files stored on CD and I am trying to link two tables
called Media Resources and File Info.
Media Resources has the following fields
ID

Currently, I have a spreadsheet that contains the data below (*****).    At
this time though, I would like to convert all the sample data into
MS-Access.
More background info:

I have two tables (previously created by someone else.
Both tables have a field call RecNO that should be common to both tables
on a one to many relationship.
Apparently there are RecNO entries in the 'many' that are not in the

I have a table which is indexed to prevent duplicate
entries.  How can I pop up my own custom message box
rather than the standard Access message when the user has
entered a duplicate entry? I have created a macro with my

This is going to sound really stupid, but I cannot get
percentages to enter in my access table. I cannot put in
95%, or .95, or any decimal or percent lower than 100. It
either changes to 9500.00%, or changes to 0, or 1. What

Im making a client management database and need a little help. The goal of
this database is to be able to pull up a specific client and display the
client information, below that you will see all the related projects for the
specific client. You can then open the projects ...

I need to save a record into two tables at once, so that the one record can be deleted when it is finished, but the other can remain in the system in order to calculate revenue.
If anyone could help me, then i would be veryu grateful

Using AXP, why can't I have the default value of a field
for new records be CurrentUser()?  It can be Now() or Date
().
Help???!!!

Hi, I am creating a database for my office.  Our current invoice numbering system is like this: INV23-123  The first INV is set for every record, the 23 is a short form for 2003, and the 123 is the invoice number.  How can I put the current year (I can put INV2003-123 if that's ...

I have a form which is not bound to a table.  The form
contains several calculated fields.  I want to write code
to make the calculated values of each field write over to
a specific unbound table at the click of a button and

Is it possible to set up a database to stor photos with a description?

I am working on a project for school that is asking me to create a database
to use as a grocery list.  I have been given few parameters but it is really
throwing me.  I've been asked to create a db to capture and report the fol
info:

I have a database that is a library of CD's  A table
called Volumes has each CD listed and where it is located:
ID; CD Name; Location.  ID is formatted as an Autonumber,
CD Name is formatted as text and each value is unique;

Have created a form and I seem to be stuck.
I need to create a drop down box:
                              form: City
                         sub form: NY