I have 4 spreadsheets that are filled by 4 different users.
I am not an expert in Access but I created a Database and linked all of
these 4 spreadsheets into table section. (I Have: CA1, CA2, CA3 and CA4)
Now I am trying unsuccessfully to merge these 4 tables in order to create

What is best practice? Either to
1) Register one record for each date or
2) Register one record with from and to date?
Let's look at an example. If I register vacation for several persons,

Hi, this is a bit complicated but I'm hoping someone out there has an idea of
whether it can be done or not.
I am designing a database to track all publications that are received at the
scientific labs where I work. On this database, the following information is

Hiya,
I have a database that is going to be used for a car garage ideally
what id like to do is to have a table customers
with fields .. tblCustomers

I hant to manually enter cost on some of my data.
I have changed the "have microsoft calculate" and my view still will not let
me enter.
In view with Act Cost - how do I get the cells to open up for input?

I have succeeded in splitting a database. (I am actually
working on a "test run copy" to insure that I am safe. My back-end contains
my tables and my front-end forms etc have "linked" icons preceding them.
Regarding the relinking code:

I have two databases that do essentially the same thing.  Database 1 has its
main table linked to a very large database.  Database 2 has its main table
linked to a different large database.  These two databases contain
essentially the same information (but not entirely) with ...

Does anyone know how to create a macro that will automatically backup copy
of the .mdb that you are working in at the click of a control button on form?
If not in a macro any other way would be ok too. I would like my customers to
be able to click on a button in the mdb or "even" ...

I would like to place an overdue display in the header of the
frmUniformOrders, something like the one for possible duplicate in the
Contacts db.
I think I would have to place a date ordered text box in the form and

I would like to create a non-primary key, but unique composite index.
I know that I can create a unique index using index no diplicate
property of table and set primary key to set my compsite key.
I am not sure, does Access support unique composite index?

I have a report run where I select the records based on the date a service
was performed.  My query asks for a range with a start and end date on this
field.  How can I show this range on my report?

Is there any way to attach an Outlook email to an Access record?
The text fields on the form I created aren't long enough for the amount of
information we need, so I'd like to be able to somehow attach pertinent
emails to the record (drag and drop? import?) that can then just be ...

I have a report that I have set up to be e-mails.  I can place information
into the SUBJECT field and I can place text in the body of the e-mail but I
need to be able to use different fonts, font sizes, bold, highlights, etc.  
Is there a way to do this?

At the moment i have three tables with the following columns:
Supplier table:
Vendor number (primary key)
Name

What is the difference between the command
docmd.save
and
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70