I have a table (tblVAS) that contains a field called VAS (Value Added
Servies).  This field is imported from an AS/400 and the filed contains
several codes that relate to Value Added Services.  The problem is that
they are not ALWAYS seperated with a space, but sometimes are.

UPDATE T1
SET T1.F1 =
(SELECT T2.FA
from T2

I want to use the caption property for fields in a recordset as a condition
in a loop. That is, I only want to consider those fields which have
captions:
For each fld in RecordsetName.Fields

Thanks in advance to anyone on this... I have a central (Access 2003)
database that I need to import about 10 tables from other databases
(also Access 2003). Unfortunately they all have the table with an
identical name (Orders). Due to the complexity of each database I can't

....as always, with support for MS Acess and other DBs.
Altova Version 2007 provides numerous new features and updates,
including a revolutionary new WSDL editor in XMLSpy®, the ability to
use Web services as sources, targets, or functions in MapForce® data

I've got the program working fine, it sends email when it needs to and
all and it sends it with the proper subject, body and to the proper
email address.
The one last thing is that every time it needs to send an email, I get

Please excuse me that this is probably a bit of a newbie question..
I am creating a series of reports, each of which takes its data from a
different query into the database to display a different range of
results, to compile into a multiple-page document.

I was recently given the task of entering huge amounts of data into a
complex, pre-existing Access database and then using SPSS to access
said data for later statistical analysis.  I managed learn the
difference between the FE database and the BE database, as well as how

I'm starting a new project. A Personnel System. I have considered
opening a single bound form to the main employee table. The user can
scroll the records to any individual. I would like to have a tab
control at the top of the form which would allow the user to select

Ha!  Now THIS  should truly be the final piece.
I've recieved an email, I've sent a reply depending on the subject, but
now I also want to prevent certain emails I've sent from being stored
in my Sent box.

For all my apps in A97 and A2003, I write VBA code that constructs SQL
statements for MS Jet.  I'm encountering something really odd.  I won't
post the SQL, but describe the behaviour to see if anyone has
encountered this.

i would like to know how can we ensure that a user fill in each field
in a form?
How do we create a warning message of a sort" Please fill in the
details"

I have a form(frmResultsDisplay) that displays the status of an
equipment. Based on the status whether "Pending" or "Approved", i want
to restrict the user. What i mean here is if the status is pending, i
want to restrict the user to continue to next level and if status is

How can I filter my database in Multiple way, I mean that I wana to
filter st. like this:
sm* *th* *er
Please Help me on this matter

I have a (Main) form named : Stocks_Main
and a Subform in that named: Stocks_Data
The Subform is a continuous form
There is a field in the subform called QTY_IN