Ok I have already coded printing the attachments but I want to be able to
print the email also. Any ideas are greatly appreciated.  Thanks in advance.

I have the following code that I'm hoping to have generate an Excel
Spreadsheet based on a query that I have. When I run it as is, I get an error
saying that:
Microsoft Office Access can't save the data to the output file you've

I have 6 different databases that I want to reference in modules in a seventh
db. I know I can go in and add a reference to those dbs but when I do they
all have the same reference name so that the only one that's actually
referenced is the last one I added. It's really strange ...

I have a form with 12 text boxes each named "txtCapacity" & Jan - Dec (in
other words "txtCapacityJan", "txtCapacityFeb", "txtCapacityMar", etc.)
I'm using the code between the dashed lines to try to loop through the
textboxes and set the available work days for each month.  I'm ...

I am trying to use code to reference different queries as recordsets but
keep getting parameter errors.
I am using For Each Parameter in qdef.Parameters to retrieve each
Parameter.Name and storing them in an array.

Bob Barrows MVP in VBScripting suggested I ask this here so I apologize for
the borderline multipost in advance.
From a ".VBS" file I am running the following that Bob helped me with:
dim app

The subject probably expalins what I'm trying to achieve and failing with,
but I'll elaborate a wee bit.
I have a subform on a main form.  The subform diplays the contents of a
table.  Upon opening the main form, I want the code to add records to the

I have the following code written in Access 97. It stops dead in its' tracks
on the last line with an Error 5. Any help would be appreciated. What the
code is supposed to do is calculate the IRR for 10 years (13 periods per
year) for capital projects.

When creating a connection string to SQL Server, are the User ID and
Password parameters mandatory?  Does it depend on the server or a
property in VBA?

I'm trying to reset an option button back to false in Access 2003. I've tried
things like:
 Me!optTitle.Value = False
 optBlockTextTitle.Value = False

do anyone know how to put text qualifier to none and delimiter sepator to
comma with in docmd.transferText acExportDelim. this is urgent please anyone
with any idea how fix this problem.
thanks

I'm using Access 2003 with SP2.  I have created a database in which I need to
convert a number to the text equivalent, like on a check (although it isn't a
check writting application).
For example:  convert $659.54 to "Six hundred fifty nine and 54/100".

I have written some VB code attached to a button on a form that imports 2
tables from a another database, and appends any new values to equivalent
tables in the current database. Within the same code, I would like to create
a table that lists the number

I have an application where the data tables are on a server, and the
application runs on clients, with links to the data tables. The appl that
runs on the same machine as the data tables runs OK, but the others are
slower, especially at startup time. It seems that the slowdown at ...

I have a document management MS Access  database based on a downloadable
wizard (Arvin Meyer  1999).  I’ve modified it to list all files in a folder
that are .doc, .xls, .pdf, .pub.
I have check boxes for the user to select multiple files (there can be up to