I have an error: number 2293 - which is "
Microsoft Office Access can't send this e-mail message. Before attempting to
send an e-mail message from Microsoft Office Access, resolve the problem
identified in the previous message, or configure your computer to send and

I need to add and save a new record to 2 tables related by the field
CompanyID using SQL.  CompanyID is an auto-number (and increments) in Table1
but not in Table2. I can add a new record to Table1 but not sure how to save
the same information (CompanyID) to Table2.

I have a database  in which I'm trying to allow a person with master access
to go in and approve or reject commitment requests entered by users of a
department.
I have a button on the form that I want the coordinator to click which will

I am trying to us Date() in the following Access 2000 code:
Private Sub cboStatus_AfterUpdate()
 If Me.cboStatus = "Closed" Then
   Me!txtDateCompleted = Date()

I am using Access 2002 on Windows XP.  I have a strange problem!, need your
expert advise.  I have written a Module to manipulate data and write into
another table.  The module is compiled and work fine when I run the code in
debug mode. However, when the same code run on ...

I have a textbox on my Form bound to memo type field in a table.
Additionally, I have a cmdbutton that runs query based on the current form
contents that also checks null values of all textboxes in my Form.  Now, I'm
adding records through the Form, the * appears on the left side ...

How can I check to see if another form is open? I basically want to pass data
only if the form to receive data is indeed opened.
thanks in advance. Samantha

How can I select an item in a combo box using VBA. I know what the bound
value should be but don't know what row that bound value is in the combo box.
Basically, I added a new item to the combo box and want to show the newly
added item after a requery.  Is there a way to do this? ...