I am currently autonumbering a field in my table with the
format "03-0000".  The "03" was for year 2003 and the "-
0000" was the autonumbering.
My table is up to number 03-0151.  Now that it is 2004 I

 I'm trying to create a field that will automatically
update a "Date", as the result of adding three years to
the date in the first field. Can an expression be written
directly in the "Default Value" property, Or, should I

I have an access database (A) that is made up of linked tables from access
database (B). When I moved these databases to another server the links (URL)
are no longer correct. How do I correct this?
Thanks in advance

I am looking at an Access2000 database...the forms show
all 2500 records with all the information in the
fields...BUT I just opened all the tables for each form
and in the field names and in each record's field I see

I posted a few days ago about how to have a primary key
with say 3 letters and then numbers that autonumber. I
have 2 more questions about it.
1. How can I set the autonumber field to a custom start

i am having trouble with a acces database.....
here is what i want:
i have a asp page which updates 2 fields in the table
clients named height and width there is a third field

I am working with msde2k, but figure this problem could relate equally to
access and couldnt' find a dbdesign group for sql, which is why i'm
crossposting to these 2 groups.
I am working on an inventory type application db design.  We are tracking

I'm bulding a survey database. I have about 75 questions
(items) to which answers are mostly multiple choice
single selection (radio buttons). There is one item which
is a text box for entering user age (whole number), and

I use Access to track charges made on company credit
cards.  When I set up the tables, I considered linking
each card with a particular user, but then decided against
that because the cards can change hands as employees are

Hi Group,
Hope you can provide some assistance for me.
The problem is like this:
I basically want a relationship between constant information an

The Problem: I seem to be having trouble with Access 2002
assigning the same Autonumber (set for no duplicates)to
multiple entries in a multi-user environment.
I've had this database around for several months now, but

What caused the switchboard created in a database to be
inop once the database was copied from one computer to
another? using MS Access 2002 SP1 on the creating machine
and MS Access 2002 SP2 on receiving machine.

How do I format an auto number to display in 4 digits.  I want it to start at 0001 and go up from there.

I have multiple table the parent table holds customer info, the child table
holds out of state info.  Due to normalization I am breaking up the tables
because only 25% of my records have out of state info.  What I want to do is
to have the primary key from the parent table populate ...

can i manipulate a label in a form so that the text is
reading vertically from the bottom.?
I have found how to vertically orient the text but it is
180 degrees from what I want.