As much of a PITA as it is to have to go change the
subdatasheet name property to "none" for any table that I
want to open in less than 5 seconds in a database that
has linked tables, now with Office 2003, it won't even

One of my marketers had previously used a dbase which had what sounds to be unlimited memo fields for notes and/or comments.  Apparently it automatically generated an ID corresponding with the ClientID.
I would like to set up a contact/memo entry form where relevant comments ...

Is it possible to have duplicate fields in a table?  Here
is what I need. Below is the field names.
Control Box--# units--Terminal Facility--# units--Monitor--
# units, etc.

I have a table with 2 colums, column 1 is Customer name
and 2 is partnumber. A costumer name may appear more then
once is this tabel so there is a possibility for
redundency error. I want to create a reference table with

I'm trying to use a Visual Basic code to design a field
that is a result of two concatenated fields. Someone
suggested that I use something like this:
New Grant ID= FullGrant Number & ""Right(CAN,4) to bring

I have a database with 4 tables. Three of them have one
to one relationships with the main table. However I have
a form that inputs data into the tables together linking
them with a primary key. My problem however is that

I'm using Access 2002 at work and have set up a database
to control the documents within our company.  The idea is
to assign a 4 digit number to the document and a revision
number.  I initially set it up with a composite key of doc

I have three number fields (pitch, width and thickness)in
a table (access 2000) that are all rounding up. I have set
the decimal places to 2 decimal places and tried the
format set to 'fixed', 'standard', 'general number',  etc

I am currently using a database to information storage and use a separate program for scheduling
Eventually I would like to combine the two by creating a database that can act as a scheduling program als
I have caregivers doing home care with clients and need to schedule their in ...

I have a database for inventory.  I'm trying to get a Qty.
on hand total on the form.  What it has to equal to is all
records that aren't checked as Sold.  so......  Qty on
hand = all records not sold.  

How do you create an input mask for a field which will have a ca
registration that will have two letters, then two numbers and the
three letters? For example, AB22 ABC
-----------------------------------------------

I'm trying to design a simple local knowledge base
database for my office who handle lots of phone queries
and would love to be able to use the ms one as a template
(ha!)

I have a text field containing consecutive numbers.
I want to add the same prefix to each record in that field .
( i.e. Column contains numbers 1 -  2000.  And I want to add
Agp-   in front of every existing number in that column.)

Could such a thing be designed in Access?

I have discovered that the wizard on my Access program
doesn't work.  I'm wondering if maybe it's not supposed to
work on the professional version, or if it is supposed to,
how I can get it to work and if there's something I can or