Are there any techniques I can use to simplify (and or shorten) the
following code please?
It all works but it is rather ungainly.
Thanks in Advance,

Hope somebody can help I am using the below code in Access 97 (Not my Fault
Work wont Upgrade) to export the Query Export Data into the Message area of
an E-Mail in HTML Format. At the minute this is coming through as an
attachment to Plain Text.

I am trying to have a text box called
NumberOfRemainingPlaces, which is an unbound control, do
the
following calculation:

This is just not working for me.  What I have is this:
Private Sub cboSales_Type_AfterUpdate()
If cboSales_Type = "TRP" Then
Dim dbanum As DAO.Database

on the how to use, Module: which the difference among using Module and
Module of Class? When should I use an or other?

Since re-linking my tables to SQL Server, I've been getting a runtime 3061
error: Too few parameters. Expected 3.
The code is stopping at the db.execute line straight after the SQL string is
constructed in VBA.

Anybody use the Windows Media Player
Control in Access for playing mp3 files?
I am trying to play an mp3 file using the
Windows Media Player Control on a form.

I'm helping a person who is used to working in Excel, create a database. The
data entry form is a continuous form, which is what she wants, and each
record has 10 fields.  Since she will probably have at least 10 records at
one time that she enters that will have the same date, ...

I have an Access 97 front end which has just been linked to back end tables
in SQL Server 2000.
When trying to use the following code behind a text box before_update event,
I get a runtime error 62506, stating that there is a data type mismatch in

I have a table called Orders that is used to log orders.  The order can be
either sale_typeA or sale_typeB.  So one field in the table is called
Sale_type and is used to specify the type of sale; either A or B.  There is
a second field, Number, that gives that order a number.  ...

I would like to use Allen Browne's LimitToList code to add text from a
combobox.  However, I don't understand how to add the text when there are
three fields in the table, and I need the other two fields to automatically
have their values added in this event.  ie.  I would like ...

When someone files their application we enter it into an Access form with
their name and other pertinent information.  It is okay to have multiple
records with that person but I want a pop-up screen or something to flag that
this person has been here before and may possibly be a ...

I have programed a snpshot report to be sent by e-amil automatically if a
certain value is chosen in a combo box.  This works fine on our local
computers.  But we get the message
"Microsoft Access can't open the mail session"

I have a listbox on a form that I can select multiple values from, and place
them into a unbound field on the same form.
How do I pass these multiple values to the table?
Thanks

I have an Access database in XP and am trying to duplicate a record on a form with a query.  There are several records showing from the query, I have place a control button to duplicate the record showing and create a new record. The record has an autonum key and when I try ...