Here is my problem:
I am trying to clear the contents of a subform as follows:
Private Sub Cmd_ClPriceAprvl_Click()
On Error GoTo Err_Cmd_ClPriceAprvl_Click

I have a form 'FmMessages" and a form 'FmLeads'.
'FmMessages', through code, opens 'FmMessages" if it is not already
open.
It then sets focus on 'FmLeads' and runs the following code:

I've created a relatively simple MS Access database which allows users to
look up information based on a series of cascading combo boxes. There is some
VBA Code behind these boxes to limit rows in some of the boxes based on
inputs in the other boxes, but everything works fine on ...

I am running a query via an OLEDB connection from an HTML web page.
The syntax is:
db.execute("exec qryWebInsertPortal '" & strAssignmentGroup & "', '" &
strClientID & "', '" & strKeyWords & "', '" & strState & "', '" & strEmailSub

ferawe

Vendo piso en Madrid centro. en buen estado, 3 dormitorios Precio ,790000 euros..
Tfno: 91447867834
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de  Anuncios Gratis

Vendo piso en Madrid centro. en buen estado, 3 dormitorios Precio ,790000 euros..
Tfno: 91447867834
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de  Anuncios Gratis

I've got code in an Access 2007 database that allows users to send email from
within the application using Outlook (2007).  The code works fine in its
current state and even supports a rich text message so the user can be more
expressive.  Is there any way to create the message ...

I have been successfully using the following command to send an email to one
or more clients containing a access report formatted to RTF.
DoCmd.SendObject acSendReport, "Product Price Query (E-Fax)", acFormatRTF,
eFAXList, , , "Price List", , , False

I have several programs using Access 2K that loop through a record set in
order to generate Emails. They all work perfectly on my home computer
running XP home. They also worked on my former win 2K PC, But they fail
on my new laptop running XP Pro

I am new to Access, and I cannot seem to get the solution to these
issues:
I have 6 departments (A, B, C, D, E and F). Dept. A is alloted an
aggregate total of 1 hour per month for specific projects that are

I would like to send message to a particular IP Address the message at a
time, the details of my requirement is as below
My Form Name : SendMsgForm
Fields are :

If anyone can help please explain this in simple terms and where I have to
look I am not that good at codes and programming yet
I have a form that is set up in a tab control with 4 tabs (contacts,
registration, registration payement, contributions) I have populated the data

Okay, so after a while i realized a solution to what i need to do with Access
is Query By Form.
Im posting this to have sit over the weekend (Sorry), as i get off work in
an hour, so ill try to explain as best as possible in this one post so the

I have searched and search all day to find an answer to my query.
I am using MS Access to create a simple database. I have a data entry form
which has some required fields (set in table design). If the user doesn't
fill in the required fields and tries to close the form the first ...