I have and employee db that contains hiring info, etc. and then an accrual db
which handles payroll info, vac hours, etc.  I want the person using the the
accrual db to pull the employees from the other db.  I've done that through
lookup table, but it's not working right and i know ...

I have created a database and it wasnt until we started
entering data that I realised I had a many to many
relationship between 2 tables - selection table and
employeedetails table. (I know this is bad planning but

I am trying to modify the design of a database that was
copied from the original.  Can the replication flag be
turned off or, how can I move the database to a new
computer?

I have a Service Inquiry form and a Client Care form. Both of these forms have subforms in common.  
I am finding that the folks in the office who have scroll balls on their mouse can scroll to more than one sub-form.  It moves them down a record and then they can't find the data ...

I am using Access 2000
I created a Db with 2 Tables.  One for equipment
information and one for calibrations that have been done
on the equipment. (One to Many based on serial # field)  I

I would like to know if it is possible to have a
autonumber field work to produce the following. I would
like the autonumber to grab the initals of the user from
a text box and add a number sequence to it. Any code

I have created a database that, at one time, had 1 long
table (approaching 200 fields).  I subsequently broke
that table into 3 smaller tables (the largest table still
contains approx. 140 fields).

I am creating a file tracking database and would like to
use our file numbering system, but have it autonumber.  
For example, our filing system uses the current year and
then a four digit number starting at one such as

I'm trying to create a database that keeps track of our
clients.
What I need help on is a questionaire that is filled out
by am employee about a client.  There is about 25 question

I'm trying to create a database that keeps track of our
clients.
What I need help on is a questionaire that is filled out
by am employee about a client.  There is about 25 question

Can you please help me to customize a field in Access 2000
table?  
I want a customized auto-numbering feature in an Access
2000 Table.  The number should have 7-digits and the first

I am creating an equipment tracking db.
Equipment can be checked in and out from the storage location (could be many
times per day/month/year). I want to maintain a historical record of all
uses of this equipment.

Does anyone know of a way of making a certain number of
records in a given access table read-only?  I have thought
of creating a key field for locking the record (yes / no),
and then making a form that only allows you to pull in

I have a fairly simple database that acts as an annual
seal register.
It uses an autonumber record to generate the seal number.
In creating the new database for 2004, I have copied the

I would like to find all the queries that have used a
particular table.  Is there any tool that will accomplish
this?  Thank you for your help.