Let's say my access database is created with forms,
tables, reports etc.  It is working great in MS Access
but now I'm ready for transfer it to a really application
that is w/o using MS access anymore but to view the

I'm improving on an existing database (previously in Excel) and moving it to Access.  Many of the columns are referencing numbers which are in feet and inches.  I'm sure there's a number format which will support such a type of data but have been completely unable to find it or ...

created a database firstly tables then queries then templated forms, now i have added more fields to the form but when i try to retreive that info back on the template at a later date the info doesnt appear and on checking the table i find that the info was never saved.
how do i ...

I need to revise the structure of a data base application
that I have developed, so that the application can
be "validated".   One part is that I need a way
to "freeze" initial data entered by user (this is medical

I've had a look around in some of the questions here and especially the ones from Tina, Allan and Rebecca - but I'm a bit stuck; I need a little sparring and couching! I am trying to create a database with a lot of contact information for the 732 members of the European ...

I am having trouble setting up a form.  I would like to be able to pick out a payroll number and in another part of the form have the persons name appear.  I have the payroll number as a combo box and the picking works fine but I cannot seem to make it show the name after I have ...

I am not new to access but I am having some problems with a design of my own.
Can some one explain the basics behind on how to generate a database where there is a "tblCustomers", "tblProducts" and "tblInvoices".  I don't need to know how to make the tables!! I just kind of get ...

I am creating a form using a calander and trying to link
the date back to the table in the database.  the problem
I'm having is access is creating a time for the entry on
the table after I select short date in the format for the

My apologies if i am posting this question in a wrong
place. If so please advice me.
I have two table. First one is main table. If any record
is deleted from this table using a form, the record will

I'm fixing an existing database.  The primary key is a numerical field, consecutive, and the owners would like the next number in line to auto-populate in that field when they enter a new record.
I'm pretty sure this is achieved via default value, but haven't been able to find ...

I am trying to track sales for a C-store. There are 12 departments, some are taxable some are not. how can i go about creating a table or two where when pulled by a form the calculations should already know if it is taxable or not.
right now i have 2 tables
TblDeptInfo:

Way back on 2002-11-20 05:46:06 PST (was searching Google groups for a
similar answer), Duane posted the following reply to a question about
Documenter:
++++++++++++++++++++++++++++++++++++++++++++++

I have an order entry database that I created. When
entering an order I need the unit price of the item to
bring up a default value from the products table AND I
need to be able to change the unit price for that

Thanks for your assistance Tina.  I don't think I
explained myself enough.  With what I have read about
many to many relationships, it stated that you had to set
up a combined primary key with the primary keys from the

I want to have a table full of people.  when they are
deceased i would record that.  
how could i set it up so that as soon as someone is
deceased, they move automatically from the normal table to