Can anyone tell me how to send an attachement using code in VBA.  I am aware
of the SendObject function however I am trying to output a report to Adobe
and email it to a distribution list.  I can't seem to get it right.

I am using Access 2003
I created a one to many form (Eye Test Entry Form) for recording eye tests
for our employees.  The basic employee information is on the top of the
screen and the eye test information (date of test, Passed or Failed, and Dr.

I have the following code in my project. It has been running niecely for some
time, but suddenly it would not work anymore. I have looked so much at it
that I feel I am becoming blind. Can someone help me see what is wrong:
This is the error message I get:

I have read and looked at all the answers/wed sites but non have provided an
answer to my problem.  I have 3 conditions. For each condition I would like
the text to be set to a colour - Date Only = Black, Surname Only = Red and
Both = Blue.  Two colours is simple Mod 2 etc.  But ...

What is the best way to make a reference to a field?
I see a . or a ! in the code samples.
What is the difference between:
me.itemName or me.[itemName]

I have a main form in which I put 4 tabs named Page1, Page2, Page3, and Page4
on the form. On each tab, I put 4 subforms named Subform1, Subform2,
Subform3, and Subform4 correspondingly. These 4 subforms have the same record
source, RS. I have 3 multiple primary keys, PK1, PK2, ...

I have 2 queries qryTotal_Production and
qryDowntime:
qryDowntime:
SELECT qryDowntimeUnion.Session, qryDowntimeUnion.Machine,

I'm fustrated: I have 2 combo boxes on a form.  I need to say if Combo Box #1
<> "EP" Then Combo Box #2 is not enabled.
If TR_PRODUCT <> "EP" Then
  TR_EPOCauseCode.Enabled = False

Is it possible to sort a list box by dragging a line up or down the list?
I have a form that has all the information about a single truck, and in the
list box, I have a line for each delivery that truck is scheduled to do. I
would like to sort this list box manually in order to ...

Doug wrote in this section (at 3/3/2006):
"If you're determined, though, you can write a function that can be used as
the RowSourceType for the listbox.
http://msdn.microsoft.com/library/en-us/vbaac11/html/acproRowSourceTypeFunctionP
arameters

Could you give me a suggestion on coding?  I have this field called
"Priority" user enters the priority number for each Project.  Once the
Project has the Priority number assinged other Projects cannot use this
number.  There is no range on Priority number.  Thank you in advance.

I have an Orders Subform that is based on a query with all of the information
form the tblOrderDetails and a formula to get the extended price of a product.
The Extended Price formula is
(tblOrderDetails.UnitPrice)*(Quantity)*(1-[Discount])

I have a database where I coded my forms to display a msg box I created when
deleting a record, instead of the standard access form by using the
setwarning = False for OnDelete action.
This works fine for single record forms, but where I have continuous record

I have a form and a subform for data entry. data entry is set only for the  
subform. When I try to print the newly entered data by printing the form
neither suform nor the data I entered would show up. Only the main form gets
printed.  I can print everything in the very same form ...

Hi,
I need to search for strings of text within a text.
The format of the text is:  "(abc)+(efg)"
What I need is to parse out the string within the parenthese only: