I'm returning to Access a couple of years after playing around with it
for personal use
and one non-profit org volunteer effort. But this time the stakes are
higher: DBs for my employer's paying clients.

I am a novice at acess and have a design where I set up 4 debit fields and 4
credit fields and a balance field.  Is there a way to have the balance field
total the debits and credits and update as a new entry is posted?

I have two tables, tblWorkRequest (Primary field WorkRequestID) and
tblWorkOrder (Primary field WorkOrderID).  A work order will not always have
a work request, the majority of work requests will have a Work Order as long
as the request is accepted.  It is a one to one ...

While creating my first database, I used lookup tables before I knew
better.  However, I can't figure out a way to remove them.
Layout:
static tblCounties - CountyCode, CountyName

I need to be able to enter a drawing number and have the description and
other data auto fill. It seems that everyone wants me to use a combobox but
there are hundreds of drawings so I don't want a drop down list to choose
from. I want to enter the number, move to the nex field ...

Using Access 2003. I am designing a database for a school. There has to be a
better way for the many names associated with one student. Dad, Mom, StepDad,
StepMom, All the granddads, gradmothers, stepgranddads, stepgrandmothers, and
the great grandparents, gardian, etc. There ...

I have a table that lists valid commodity types
   tTypes
       Name field
I have a table that lists valid manufacturers

Have another question. I've split most of my tables so that 90% of them
contain only 2-4 fields and then related them (tblCompetencies,
tblWardCompetencies, tblPersonnel, tblPersonnelCompetencies, etc).
Question: How many fields is too many to still remain normalized?

I've started a gardening database.  The main table is tblPlants, which has
fields such as GenusName, SpeciesName (those will make up the primary key),
CommonName, Lifecycle, Hardiness, Shape, BloomColor, MoisturePreference,
SoilPreference, LightPreference, etc.  

i have an input mask for a phone number.
suddenly only the first number types, and the other numbers dont get typed.
for example, i type in 604-888-8888
only the 6 types, and it is highlighted, and any other number i type is

It's possible to use a parameter at IN clause that take the name of a
database in a make table query that can be reused in the same front
end for different back end databases? Like this:
INSERT INTO table

My multiuser Access database has 40 users, consists of backend and frontend
files.  The backend mdb has 4 tables that contain the data.  We also have a
backend look-up mdb.  The complaint is slowness.  People aren't closing
properly and the system will then crash.  Would it make ...

Does anyone have an inventory template that includes Lot# and expiration dates?

I designed my database, did some testing and it has been working fine. My
manager would like to have the database open to everyone in the department.
This will mean that the pay rate needs to be kept hidden. The payrate has
been on a subform attached to the date so any changes in ...

I am a novice at Acess and have a design problem.  I have a header setup but
it only prints on the first page.  I need it to print on all pages.  Please
help.