I am using office 2003, just upgraded from 2000. In 2000 the code below
worked fine for the CC in outlook. In 2003 it doesnt find the names unless i
click in the cc box in outlook and change something. I have also tried typing
in the actual email address with no success.

I’m just exploring the possibilities of VBA in Access and I ran into a couple
of problems. I hope that one of you has a solution.
Problem:
I have to import text files with a ; as a delimiter, into access every

I am using the following code to relink the oracle tables during my
application startup
  With CurrentDb
       TableDefs.Append _

I have a table "Student". The primary key is combination of telephone and
sequence number.
I have a form to entry all students infomation. It has about 30 fields to
capture information. Some of bound are bound and some are unbound field.  As

Hello all of you VBA oracles out there...
I am creating a script that appends excel files to an exisiting table.  I
have the basic import code working fine, I just need to fine tune it to track
which input file any particular record was added with.

How do I set an array variable to a function?
Here is a sample of my code:
Dim testWS as new clsws_activeinsurance
Dim temp() as struct_mapitem

How can I get the Zero to be Null or Empty or Text? CompletedDate  is a Text
Field
I thought "" or "Not updated" would get it but error's out
DoCmd.RunSQL "update tblPayrollCompletion set CompletedDate = 0"

Field F in a table contains any one of the names of the fields in a table.
For example:
ID    F
3    MyFieldName

I have an access file with linked tables to an odbc database and I'm looking
for a way to backup these tables to local tables. Is there a vba procedure
that will accomplish this task?
Thanks

Hi, I'm trying to email a table (Tbl_Test) but continually get the error
message -
Run-time error '2302'
Microsodt Access can't save the output data to the file you've selected.

I wish to export a query to excel via "TransferSpreadsheet":
DoCmd.TransferSpreadsheet acExport, 8, "Queryname", "H:
\Office2000\Access\Test2.xls", True, "
With this code I could only export tables, not queries. The error message

I am the new user of VB.
Normally, when users change/add/delete the data in the sub form, the data in
the original table get updated straight away.  To prevent users change the
data by accident in the sub form, I want to add a Command Button with a

I need to add a command button in the Sub Form, prompt the users , "Are you
sure you want to save the changes?"  if the answer is yes, then update.   I
want to do the same for deletion.  however, instead of deleting the record, I
want to keep the record but flag for deletion.

I am trying to create a new module in my access DB.  I'm having trouble
getting anything done (saving, pasting code, etc.).  I think my problem is
due to some old forms that are persistent in my database.  I can't seem to
get rid of them for some reason. They are contained inside ...

I have read every message I could find on this subject but I must be missing
something.  I am having trouble requerying data to a combo box.  I have it
set up as a value list but keep getting an error.  
Here is my statement for adding to the combo box