We are in a customer service center environment and student reps have no
access to student database (for privacy reasons involving personal
information) and therefore will have to put callers on hold, get up, go to
lead rep, management, or staff to have info looked up. We use ...

Hi.  I have a form in Access and want to be able to click a button to open an
Email message in Outlook.
The message is used as 'stationery' and is in a standard format saved in
Outlook.

I am trying to work on a query that will give me the distance between two
geo-points.
My question is will this formula work 'as is' within Access or do I have to
make some alterations. The formula uses the 'Great Circle Distance'

I'm having a bit of trouble referring to a control in a subform within a tab
control.  Without the tab control, I would code it as Forms![Main
Form]![Subform control].Form![Control name].  
However, the subform control is within a 4 page tab control.  Each page has

In Access 2002, I have defined a table, tblAlumnus, I am trying to write a
module which will read sequentially through tblAlumnus, access the data by
the field names I have assigned to it and print lines in a report.
Doing this through queries is getting way too complicated.

Hello group,
I am attempting to make my database available on the Internet so that
users can simply work from the asp forms that were designed.  I do not
have IIS server on my desktop (which requires Win XP pro or win server

I have successfully created 2 recordsets in VBA and now I want to join them
in the code to create a 3rd, new recordset.  I have created an SQL statement
that would work if there was actually a query object created, but since
everything is "virtual" in the VBA code, how do I do ...

There is a feature in Access which allows one to open a database and by pass
all modules, all macros and the startup options.  All one has to do is hold
down the shift key when opening the database.  Is there a way to disable this
feature?

Office 2003 Pro.  What is the command to open a Word Document ( test.doc)
from inside Access?  The document is in the same folder as the database.
Have looked in the Help and KB files, no luck.
Please help.

I posted a question last week regarding printing multiple copies of a Word
document from Access.  I got the help I needed, but now have a different
problem relating to my code (please see below for original post containing
code).  

dim key long
key=1251205
key=key And &HFFFF
why is key is still equal to 1251205 ???

I have the following code:
Set m_objWord = New Word.Application
Set m_objDoc = m_objWord.Documents.Add(m_strDir & m_strTemp)
(populate bookmarks)

Is it possible to
a) change column width , b) change cell font size and color c) combine cells
of an Excel 2003 sheet from VBA Access 2003 code ?
Thanks for your attention.

I don't want the standard access menu bar showing when my application is in
production mode. I detect whether I'm in production mode by checking to see
if the Database window is turned on in the startup options. Here's the code I
am using:

I am using the following which is called in a cmdBtn sub
Private Sub SendEmail()
On Error GoTo Err_SendEmail
   Dim strEmail1 As String