This is a copy from the post below - This "could" be against the forum rules
but I think it's too important not to have it's own thread so sorry if I
offend anyone.
But if there is a security risk with sending e mails from access it should

I am a beginner with Access. I have taken one course and have gone through my
textbooks and I am still lost.  My employer needs a database for reporting
lines keyed by operators, etc.  I need help.  I can create my initial table
by importing the data from our ordering system no ...

I am currently viewing my e-mail through Access, and would like to view
attachments too.  Any way to do this without going into Outlook?
Thanx

What do this error message mean?

Whenever I compacted and repaired the database, I have underlines on all of
my names, i.e. tables, forms, reports.  What's up with this?
Thanks!

Can anybody help me in clarifying :
1) What is a pivottable ?
2) When do we use it ? examples would be useful
Thanks in advance

Hi, I Have a real simple question, I have a check box on my form that the
user ticks if required, I have a bit of code running to turn the label colour
of the check box blue if true, is there a way of making the label text turn
blue and then red and then blue etc etc so it looks ...

I have a spreadsheet that is linked to an access database.  I have a
sum of the duration event in my spreadsheet equal to the following:
37:29:14.  This is in the following Special Format: [h]:mm;ss.
After it is imported into Access, my format is changed to the

In Access 97, I can assign a bound control (to a linked table) a value
in the Form_Open event with no problem. I'm creating a new record when
I open the form.
Me.master_id.SetFocus

I have a form "Navigation" with a button "Administration". The "Navigation"
form opens maximized however when I click on the "Administration" button the
"Navigation" form restores when the "Password" form pops up. I would like
the "Navigation" form to remain maximised when the ...

I have a report where, in the footer, I need three totals:
Total Employee Amt
Total Spouse Amt
Grand Total Amt

Using Access XP. The main back end file (There are 5 BE files ) contains the
table tblStudentInformation with over 40 fields already, ALL the FE files use
some of the fields in this table, I need to add 12 more fields but I know it
is not good to have too many fields in a table. ...

I have the following (from this newsgroup) which acts as a password box :-
Private Sub Administration_Click()
   Dim strPasswd
   strPasswd = InputBox("Enter Password", "Restricted Form")

I am about to compress and repair an Access 2007 BE database for the first
time after its first three weeks of use that saw it grow from 20 megs to 35
megs.  Is it required or advisable to compress and repair the 30 FE databases
that link to the BE?

I am trying to delete duplicate imported records in a table. I have done the
find duplicate query wizard. But what I am trying to do is make a Delete
Query that will go through the table and delete duplicate records.
How do I do this?