I have an app that's created in 2003.  I'm trying to make a runtime of
it.  It works just fine on my computer but not on machines that don't
have 2003.  The error message says "Your database or project contains a
missing or broken reference to the file EXCEL.EXE' ver 1.5  To ensure

I am working with a record in a table that was imported and the data is one
field filled with information.   I need to parse out the data into 80
characters (80 characters = 1 line of information).  Sometimes a control
character is accidently sent across.   Is there a function ...

I was wondering if someone could help me. I just wrote a rather length VB
script that takes a table does a bunch of queries, modifies the data, and
exports the new data to excel. I justed added a form so all my boss has to do
is push a few buttons to run the code... However, my ...

I have a table that shows the following information
intJobControlID
JobControlName
Defect

I need vb code to open any type of windows standard dialog box... example
openfile,save, etc....

I have a folder on the desktop with serval hundred files in it.  If I make a
table in Access called FolderNames with one field called Names, is there some
code that I could run that would import the name of every file name from that
folder in that table?

What Libaray do I need to reference in order to use Database and
TableDef data types in VBA as shown in the example below?
Thanks for any help anyone can provide,
Conan Kelly

I'm using the calculate working day code from the access web website.  I want
to know how to implement the code so that it will return 0 when only one date
is passed as a parameter.
Here is the code

Access 2003.
I have competed the development of my application but i have smalll details
to fix, among :
- how can i change the name of the Access Windows to the name of the

I'm creating export functionality. The names of the exported files are set. I
do, however, want the user to specify the directory where the file should be
saved. How do I create a control that will allow the user to select only the
directory where the file should be saved?

I've setup VB script to export query results to a file.  If the query output
is null or has no records, I would like to provide the user with a message
rather than export an empty file.
Also, I would like to detect if there are empty values for a particular

I want to loop through a recordset and capture the value in a field.  There
could be as many as 18 records.....  do I declare strValue1, strValue2..
etc., or can I declare a value as I go along..... I have Friday head and am
lost.

I’m using Access 2003
The following code is called from a button on a userform.
The routine calls the CommonFileOpenSave box, prompting the user to search
and select a file on the network/local drive.

I'm using VBA 6.3 to write code for an action button on an Access form. When
pressed, the code formats an outlook mail message using "with mailoutlook".
The email forms just fine except for the sender address, I can't find any way
except using sendkeys for this. As I'm sure you ...

I am not the best a VBA so a little help would be welcome.
I would like to search for Last Name's across 5 different forms from a main
menu (Front end) form. The forms have no relationships assigned. I would like
the search result to list the forms that contain the correct result ...