.. so I got this function http://www.datastrat.com/Code/MultipleEmail.txt 
from Arvin Meyer (thank you! :-) )
but how to make this work?
Now I understand I have to copy the code into the code of the form.

I am new to Access and need help creating an edit record form.  I've
got a table called Player with attributes like name, address, phone,
etc.  I've created an edit player form with a combo box that gets
populated with a list of all the players (run from a lookupplayer

I'm using the following routine to call UpdateDiary() - below:
   Private Sub Form_BeforeUpdate(Cancel As Integer)
       On Error GoTo Form_BeforeUpdate_Error
       Call UpdateDiary(Me!TenantCounter, "sfTenantDetailsOther")

This is baffling to me.  I'm using Access 2002.  If I create an
unbound form and put an unbound listbox on it (List0) and then add the
following code to the Form_Load event:
Private Sub Form_Load()

Someone please help before i start to cry.
I'm trying to export from Access to Excel, then create a new excel sheet with
a pivot table to display the data held in columns A:P. I get the error
message "Run Time error 91: Object variable or with block variable not set"

Hey everyone:
Probably an easy question but here it goes.  I have a continous form
where you update a quantity order field.  When you enter the quantity
ordered on a line and tab down to the next line it saves the record.

I am writing an inventory database and want to change / filter the
options shown by a Combo Box / Drop down list.
On a single form first the user is to select a "Hardware Item" (Radio,
Pod, Beacon etc - Approx 10 options) from a drop down list and then

I've searched this group and have not found any posts since 2001, so
I'm hoping that now there may be a better way.
I have a need to generate a report that looks like a outlook monthly
calendar view.  What I'm struggleing with is how do I get the first

Is there a way of seeing whether a form is open or not in access 2000
using visual basic coding, as i want to transfer data from one form to
two different ones depending on which one is open.
Can anyone help

I split my database into back end and front end, put the back end on
the server, and the front end installed in each PC. How ever, my user
said it is way slower than it was before the splitting. I research
this user group and did what MVPs suggested to have my main form tied

I know this is a very basic concept, and is probably posted in a
million other places, but I'm hoping to just get a quick response
here.
I have a form based off an Invoice table.

I have a single file Access database that was written in Access 2000, I
have had the MDE over a network of 3x PC’s for several years without any
problems. Now I am using Access 2003 but I have left the file in Access
2000 format, when I try to open the file over the network I get ...

The following gives a syntax error. I can't see what is wrong with it.
INSERT INTO tGuestsWaiting (Name, Number) VALUES ('TODD','2');
The table name is valid and Name and Number are string fields in the table.

I need 8 cards on one sheet of paper with data on both sides.
I tried this by using two subreports in my main report and use only
the top 8 records for the source. After printing a page i set a field
called PrintDate and print the next.

My mind has gone and for the life of me I can not remember this simple
task. Would someone help me remember. Here it is:
I have a form and the text boxes are locke on this form. I would like
a command (Event Procedure) to unlock the text boxes (Form).