I have a database that has personnel info in it - Table Name Is "T-Personnel
Data"
Now I need to create another data base for Training Records and would like
to capture certain Fields from my personnel Info Data base such as

trying to set up objectives for data entry clerks?

I need to create a parts database to be able to lookup parts for different
machines.  The problem I am having is trying to determine how to 'break-down'
the machines so that the parts can be found.  I want to be able to use a drop
down list to select a machine name, then an area ...

Does someone know the limitations around MS Access.   Number of users?  
Number of tables?   Size?  Thanks.  Jill

I would like to be able to highlight different records in my database. Does
anyone know how to change the color (font or fill) for individual records in
access?
Thanks very much!!

I’ve used a program very similar to Access, called Alpha Five, for many
years. I created a checkbook application in A5 that works great and now I
want to convert it over to Access 2000, but  I need some serious help. I have
lots of questions, let me start with the basics.

Good morning all.
We've had a large database up and running in the office for a good few years
now. currently on Access 2000.
We recently moved to XP and to add some of the additional design utilities

how do you create an auto number field in Access using DDL? the Auto things
it an Auto..!

i have a query which selects from my original table all with a price of zero.
this is then passed to a form to allow the user to enter a price.  after
this price has been entered,  i need to then be able to select from this 1st
query all with a price of greather than zero to ...

Customers may be physical and company persons. They have different data.
How to make the table Customers? Together or separately (one table or two
tables)?
Thanks

I have table.
Is there a way to add auto number field to table with vb code?

How can I set an autonumber to start at 500, rather than with 1?
Thanks!

im creating a database in school (university).  i have 4 tables. one table
has two primary keys.  each of those keys are seperate primary keys in other
tables.  first question is how do i show this as a relationship?  two, when i
run the report each event in the db has all 6 ...

Hi again,
I have a main table, Policies, which contains general
information pertaining to all policies regardless of their
type (i.e. LifePolicies, MotorPolicies, HouseholdPolicies)

I have an old database with a form to set report criteria.  It works fine in
Access 2002 and 97.  I have recently upgraded to Access 2003 and the macro is
failing on the "SetValue" Action.  The Active Arguments in 97 and 2002 were
Item: [Visible]