I am trying to generate an automatic email after a users enter a record via a
form.  I have the following code in the After Insert Event:
Private Sub Form_AfterInsert()
Set O = CreateObject("Outlook.Application")

I've run into an odd problem that I can't seem to find in any of the
archives. I'm using Access 2002 SP3 on Windows XP SP2.
I've got a table with an indexed text field, and the field may contain a
string that contains quotes (either single or double quotes). An example

Sorry if this has been asked and answered, but my two hours searching didn't
find it.
I have a main form that launches a popup form in datasheet view.  
I want to be able to have the user click on a specific row in a datasheet

My application is 1024 x 768 resolution. How can I change user's resolution
in code to match this and restore it back when user quit my application?

Is anyone aware of any Access based business accounts and inventory
software available that would suit Australia / New Zealand requirements
- GST etc?
I am looking for such to work with an existing Access97 service

I have a form where I enter a person’s first names. What I would like to do
is trim off anything after the first of multiple names e.g. Fred Jonathon,
loose the space and Jonathon so that only Fred is left.
Is this possible?

Hi. I have two GL tables that I need to map. One has "Our" key & desc - the
other has "their" key and description. I was hoping to do something where the
user selects a description  from "our" table and then the description "their"
table. I would then populate the key and ...

Yo People,  I want a check box on form that when checked will populate
shipping address fields with the records billing address text.  The forms
record source is a select query derived from my customers table.  The code in
the check box after update sub is affecting all records ...

I have form that allows users to enter data in a spread sheet format, bu I
save in a normalized format.
There are twenty columns. The user can select the column headings.  The
objects and fields are numerically ordered.

I'm trying to change the RowSource of a combo box on the OnLoad event. I
need to concatenate the "userLast" and "userFirst" fields into "userName" as
seen in my code below.
How do I deal with the needed quotes that combine the "userLast" and

Thanks in advance.
Have a table Called File_Names
In table is 250 excel table names Name = FN_Name = Name & FN_Path = Path.
What I want to do is read the Comment field (Of the File) and put it in

I want the user to be able to click on one specific row in a datasheet popup
and then return the entire row to the calling code for processing.  
Questions:
How does one identify the row the user has clicked on in the popup form?

i have 3 tables: table1,table2,table3
Can i copy the field "receiving date" from "table1" if status in
"table3"<>"closed" or"follow up" to a new record in "table2",by only one
click on a button on a form.

I writing following recordset, but everytime I'm getting error, actually not
working
can some one tell me pleaz whats wrong with this. Pleaz help me to fix this.
Dim StrSQL as String

Anybody have the experience where you open an Excel spreadsheet, process the
worksheets, then close it, only to find the PROCESS still running in Windows
Task Manager.  This causes a problem next time I run the process, as it locks
the spreadsheet I had opened originally.