I adding vehicle maintenance records into my database. I have created a table
for each maintenance record call Invoice. it contains an index,vehicle id,
date, mileage, provider, etc. Then I created another table for the details of
the maintenance. It contains the catagory of ...

I have a database that includes a "settings" table.  The settings table
should only have 1 record.  I have tried to design the form used to enter the
settings to not allow the user to create additional records but it sometimes
occurs.  One such way to "accidentally" add a record ...

I have been having a few problems with a database the past few weeks.  I have
about 12 users in this database on a daily basis.  I have a table with 11000
records, and an associated table with 23000 records that has an associated
table with 6000 records.  I am wondering if the ...

I've been learning about linked tables ( splitting my mdb's to front & back
end) and I remember reading some place that the record count property always
comes out -1.  I'm not sure if they meant actualcount -1 or the value -1.  I
use recordcount in decision making a couple of ...

How can I change the background colors or fonts in a Access message box?

I am completely new to Excel and have created a spreadsheet which background
should have no fill.  Unfortunately, part of the spreadsheet has a gray tone
and the other no fill...Please help.  I've tried changing the entire
spreadsheet to no fill

I am setting up an Inventory database where I want to post and track invoices
that come from a company with multiple products.  I will also need to do
weekly inventories that will keep track of begining inventory, purchases and
ending inventory then caculate those usages based on ...

Hey all,
i think i understand the concept of an invoice and invoice details table ok
but how do the payments and/or receipts fit into the design.
is there usually a payments table and receipt table all tied together by an

I have 3 tables which are in a many-many-many relationship:
tblMSDSs - a table of Material Safety Data Sheets which describe the
chemicals in a compound
tblSuppliers - a table of manufactureres of a product containing compounds

I have tblOrder with the fields OrderID, OrderDate & CustomerID.  I have
just made tblOrderDetails with the fields OrderDetailsID, OrderID, ItemNo,
Quantity.  My question is do I need the OrderDetailsID (autonumber) field?
are there any advantages to it?

I need to make a form for adding record to multiple tables. I used table
relationship but I'm not getting it right I think.. plz can somebody help me
with the tbl structure and tbl relationship? Should I be making a query?
+ Reservations

Is there a standard way to handle spouses with different last names in a
mailing list database?
Right now all names are in one table, with FirstName and LastName fields,
and the kludge solution is to have (for example) "Jane Smith and John" in the

Apologies if previously asked; I have looked, but not found a (probably
obvious) solution:
Problem: I want to set up a table in a database which lists all the fields
in the database so I can map them to a mnemonic, category code, etc.  For

I am having difficulty with normalizing data.  I am creating a client call
center database.  Currently, when a call comes in from a Client Contact, the
users enter information regarding the Member’s issue on a data entry form.  
The users can resolve certain issues themselves, but ...