I am trying to send an automated email from access, but nothing is being send
and I am getting no error messages.
Private Sub vac_Click()
   Dim strMessage As String 'Body of message

When my application is launched on not-Vista, the dialog looks as follows:
http://ourworld.compuserve.com/homepages/webspace/test/SDTM-RIGHT.jpg
When my application is launched on Vista, the dialog looks "squished up", as
follows:

Spinning my wheels here....
I have one table with 1,000+ records and each record has a (required)
status; active or inactive.  These records are stored in one table
called customers.  I have a form that displays the customers and would

I have an Access Database which I designed about 8 years ago with Access 97.  
I now have the task of converting it over to Access 2003.  In compiling the
code I am getting errors with this statement
Dim TORG12A As Database, ssMaxONE  As Snapshot

I have a subform which houses email addresses.
I created a command button on the main form to generate an individual email
for each of the recipients on the subform.
My problem is that it only creates the email for the 1st record on the

I am using Office 2003 (sp3) on Windows XP;
I would like to create an ID that prefixes some text at the beginning of the
value, so for example the unique ID might look like:  bk1; bk2; etc.
I came up with using an autonumber field along side a second column that

I need to modify data in a table, but I would like to create a backup of this
table everytime before I do so. Right now I am opening the table in an ADODB
recordset, opening and Excel workbook and then looping through each record
and populating the Excel worksheet. The table has ...

Once I have declared a variable, is there an easier way of entering the
variable name into code other than retyping it in every time?

Trying to perfect this a little more...
I've got this code that measures the length (in minutes) of a procedure.
Sub TimeLoop(strFncToCall As String)
On Error GoTo TimeLoop_Err

How can I loop through a directory and put into a table the file name of say
anything that begins with abc*.txt? I am using Access 2003.

Can someone fix this syntax?
       objXLSheet1.Range("2:2").FreezePanes = True

Can anyone tell me how I pass the button I have just clicked into function
that the OnClick event calls?
My Button calls a function with this setup:
"Function ButtonClicked(MyForm As Form, MyButton As CommandButton)..."

First off, I have 2 tables.   "Table A" and "Table B".  Both of these tables
have the exact data structure.  What i would like to do, if possible, is take
Table A and its contents based on a certain criteria of which records to
include, and OVERWRITE Table B with that? (but ...

I have been tasked with trying to find a way to programmatically add
subreports to a master report at runtime based on certain criteria
(subreports are already created).
Initially, we have been adding all the possible reports and hiding them if

I have used Albert Kallal's vbscript and it launches successfully when run
manually. (Thanks ALbert Kallal for the vbscript!)
Under server, won't go - runtime error 800a9d9f.
The script is on on a server that has access installed. The scheduler is on