I am trying to develop a program in MS Access 2003 and I need to enable the
formatting tools in the runtime environment so they will be enabled when the
program is distributed to users who do not have Access on their pc's.
The ones I need are Font/Fore Color, Bold, Underline, ...

using a table such as:
Country  V1     V2     V3     V4
C1         P1     P2      P3     P4
C2         P1     P2     P3      P4

I'm having difficulty suppressing warnings when I export data to excel. The
excel file has a macro in it that i need and i would like to remove to
warning prompt i get each time i export.  Below is the code i'm using.  
Thanks for your help

Okay, I am feeling stupid here, I have a complex/dynamic record source that
combines information from 3 tables into a dual crosstab based on records
contained within a fourth table... to make a long story short here is the
just of the record source... I will go into my question ...

Seemed like the WHERE clause flaked as if it wasn’t' there at all; every
record in the table was updated.
Does any one know what went wrong? Here is the code:
Dim rst As New adodb.Recordset

I'm getting the following error message "Run time error 429 - ActiveX
component can't create object". The following is the command it fails on:
Set mclsFO = New FileObject
Does anyone have any idea what this message means?

When transfering data in from excel is there a way to refer to a specific
sheet and not a specific range.  The excel file I want to import from has
several worksheets and I do not want to have the user set a named range as
the range changes.  I just want to be able to say the ...

I need some assistance
I am creating a database, where
1) the user will upload text file on a table (have a upload form)
2) Whatever data is on that table, it will have to spit out in excel form,

hi, how can i get the value from a listbox and put the value showed in th
msgbox.
thanks

i'm trying to copy the values from one listbox to the textbox, how can i do
this?
the listbox just show one value. i have to use listbox because it is the
value from an SQL statement.

Hello world (;>)...
I am searching for a code fragment to add Tables to the relationship Windows
with the help of VBA.
I know how to add realations with VBA, I know the way to show them in the

I have optional library. It will be used only in some cases. So that I
don't include this library in my setup package. But if this library is
missing on destination PC, it will cause the serious problem (for example, I
can not even open a recordset using DAO).

I'm trying to run a program from Access that will run a batch file to
download a file using FTP.  I'm having a little difficulty because the batch
file completes before I'm connected to the site where the download will come
from.  Any suggestions?  Thanks.

I have years of VBA programming experience with Access and I used to insert
statements like "on error goto labelx", or "on error resume next", etc.
this is a very simple piece of code:
Sub TestA()

I'm trying to save off my debug info to a file, but don't know how. It's to
print the RecordSource property of every form in the database, which I can
do to the immediates window fine, but the thing scrolls too much and I lose
the first few lines.