I am trying to create a MS Access report using VBA to access data from a SQL
Server table and a DB2 table.  Both tables contain varchar data that I want
to appear on the report.  When I try linking the table, Access does not like
the DB2 varchar data.  The VBA method was ...

Is there a way to make sure that all handles Access may have acquired in its
various processes are released when the database is closed?

Hi.  I have a query, and I want to collect all of the email addresses from it
into one String at the push of a command button.  The query (and I need to
use the results from the query, rather than from a table), say TheQuery, has
many fields, one of which being "Email Address".  

I know little about Access…
A user asked me if there is something that can be done to stop the Editor
from opening when running any of the reports in an Access project.  All
reports run perfectly but the user is having to hit the F5 key once the

has anyone succeeded to fire up an Email with real html content by doing:
DoCmd.SendObject acSendNoObject, , acFormatHTML..........
what is the acFormatHTML option there for if SendObject dosnt turn on the
html option in the mail client ?

I built a form with a command button that open the FileDialog to retrieve
the path of a database to which I have to connect. Here is the code of the
button:
'Declare a variable as a FileDialog object.

Hello!  I'm using Access 2000 and need to be able to copy a table and rename
it all using code.  Anybody know how to do this?
Thanks for any help!
Brian

Server = SQL Server 2000sp3a
Client = Access 2000 SP3
I have a onClick event on a command button which runs a stored procedure.
docmd.runsql "exec sp_mySproc '" & me.cmbo1 & "', '" & me.cmbo2 & "'"

I keep getting a Run-time error 2501 "The OpenForm action was canceled" in
access 2003 when I use the Access.Application.11 to remotely open a form in
another Access database.
any suggestions?

In a form, I give the user the opportunity to e-mail the data from the form
to someone.  If they change their mind after the e-mail application opens,
they can cancel the application.  When they do this, I get the following
error:

I am considering writing and distributing a small Access app which links to
an SQL database through the internet and wonder how the application can set
up a DSN on the users machine and link the necessary tables.  Is there some
code that someone can give me to accomplish this?

i am using XP Professionel. In access i have used automation to open an
outlook page (e-mail) In the body of the message i would like to insert a
access record is this possible

Trying to develop a poor man's version of LiveLink or SharePoint.  I can
create a link to an external file and open the file from Access, but I cannot
seem to control if the file is opened read-only or read-write.  Ideas?  My
desire is to allow users to open and view a Word or ...

We just converted our 97 Access databases to Access 2003.  The project went
well with only some small code changes.  One that has become larger over time
is...
we import XML files into the databases.  In the 97 version, when the file

Is there any way to allow users to re-sequence items in a listbox by using
drag and drop, if so where could I find examples for Access 2003/VBA?  I have
a sequence number field that I use to sort the listbox and I would like to
enable the ability to change the sequence of an item ...