Due to the character limitations of the built in Access Macro email function
I need to create a procedure but I am not familiar with Access that well
enough to do it.
Here is what I need to do.

Hello.  I have a dillemma and I'm not seeing the way to work it so I seek the
thoughts of the group.  I need to allow for attachments to a project, the
project version, the project version task, any task notes, and so on.  What I
thought of doing is having one table ...

I am using Access 2007, and have a form with a text box that a user is to
enter their User Name in.  A check is performed on the After_Update Event of
the text box and if the user name is not found in the BE, an error message is
displayed and the text box is to gain focus and the ...

I have a combo box that look up patient’s names. If the patient’s name is on
the list and chosen it fills in the corresponding boxes. This function work
fine, but if the patient is not listed I would like the ability to add the
patient name to the table. I have added the ...

i tried working on these syntax for decompiling:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"D:\2008-06-11\mydb.mdb"  /decompile  /wrkgrp /user adminUSR /pwd "123"
"D:\2008-06-11\mywrkgrp.mdw"

I've got the below field in a table, and placed on a form as a text box.
I've got a pushbutton that OnFocus fires some VBA code, the first step is
        Me.CalculatingMessage = "Calculating Score"
The calculating routine takes about 3 seconds, and at the end of the routine

I have to design a contacts/relationships database comprising lists of
individuals who can belong to a variety of organsiatiosn/committees,
each in different capacities eg President of 1 committee, Chairmain of
another, simple member of another. I envisage 3 tables:

A couple questions that I don't know where to post.  
1.  I want to create a combo box that is not active until a combo box before
it is choosen.  For example.  Combo box 1 contains departments.  If you
choose the department "Food and Beverage" I want the next combo box to become

I have a field in my table that I set it in text format and set to one
character in length.  I would like that field to automatically update to show
a "Y" or "N".   We'll call this fieldname YESNO
I also have a field in my table that is in Date/Time format.  We'll call

I use this for populate a listbox
Me.Lista69.RowSource = "select idvenda,codigo,produto,qtd,unit,total from
tbvenda WHERE nvenda like " & nven & " "
Me.Lista69.Requery

When I try and use a field on a form that is a calculated value the value is
not calculated until the controll has focus.
It is only affecting controlls bound to calculated values(those startign
with "=", so:

I have a main form where users can search for a record if there is no record
it prompts the user to enter a new record. If the user selects yes a form
opens for them to enter the new record. What I want to do is have it so that
the form opens to the new record. Here is my code. ...

Repost from earlier this week:
I have a combo box used for selecting the client record the user wants to
work with.  I have autoexpand set to Yes.  When you begin typing, the combo
automatically drops down to make several selections visible at once.  Once

Could someone take a look at my code and see what I am missing.  My quest is
to have the data I retrieve through my DLookUp code to also write this
information to the table my form is based on.  The information I am pulling
in is a device type from an asset table and putting it ...

Private Sub SAVEForm_Click()
On Error GoTo Err_CloseForm_Click
   If IsNull(Vehicle) Then
       MsgBox "Must Select Vehicle for Entry before saving", vbOKOnly,