We run a small outbound call centre with around 20 agents.
usually there will be 10-15 indevidual projects on the go, each contained in
it's own Access 97 DB.
All Access DB's on held on a single Win 2000 PDC Server.

I have been successful in using automation from within
Access to set an appointment in Outlook in my own
calender.  How do I set an Outlook appointment in other
calenders within my orgaization?

Access 2003 and a VB Module
I am trying to refer to a field name in a recordset (i.e. rst!fieldname =
"some text") for the purpose of writing data to that field(s) for a newley
created record in a table. The wrinkle to this is that I'm trying to variably

I would like to fromat a control in the following way
="this is a " & format("TEST","bold")& "the word test
should appear in bold"
what I want is a control on a form where the word TEST (

I recently took over a database that I am in the process of normalizing.  I
would like to update a foreign key in one table based on the primary key of
another.  The tables and fields are:
tblTraineeInformation         tblTraineeList

This is similar to discussions already posted in the forum, but I don't
believe any have addressed this specific point (my apologies, however, if it
is being rehashed):
Each record in my report may or may not have text in a field called

I'm using the following code to open Excel and a file(s).  The user can then
run another query which would again call the procedure containing this code
and I end up with another session of Excel open.  I would like to check for
an open Excel session and use that session if it is ...

I cannot forward or reply to an e mail , a message appear runtime error !
Program: C:\ Program Files \ Internet Explorer \ i explore . exe
abnormal program termination .
I couldn't figure out what's the problems , Please help me figuring out

I'm using the following code to open a session of Excel and file(s).  The
user can then return to the form and run another query which calls this
procedure again and is opening another session of Excel.  I end up with
several Excel sessions being open.  I'd like to be able to ...

I have 2 subs
AddPatient_Click()
Search_Click()
I have a boolean, searchbool, in the Search_Click that is set to true at

What code can I use to find out if a VB reference already exists?

I have a VB program accessing non-indexed tables (by primary key). I'm using
the RECORDSET.OPEN / RECORDSET.FIND syntax, coupled with RECORDSET.MOVENEXT.
I would like to be able to stop the quesry when the last record with my
specified value is found. How can I do that when the ...

Helllo,
Is it possible to convert a Query or Table into an XML file from code using
DAO?
-TFTH

The following code uses CurrentProject.Path to create a string used to set a
reference to another mdb. The procedure works fine except when there are
spaces in the path or file name. How can I make it work if spaces exist?
strPath = CurrentProject.Path

   i have a table named Board with the field names; SerialNumber,
Description,Status,Department,Qty and I want to update it using a recordset
with the data in my form.
help me pls.