I want to run an access macro when openning access file (.mdb file). Do
anybody know how to achieve this?
Thanks!
Raymond Ou

I have the following code: Find '--- in the code for my question.
Private Sub CmdUpdUtilFld_Click()
   ' Create adodb recordset, connection and command here
   Dim rs As ADODB.Recordset

I'm trying to change the field type in a table from text to number using VBA
code.
Any help is much appreciated...Rgds Chris

I'm trying to create a button on a form that closes the form when you click
it.  However, I can't seem to get it to work.  From what I can tell I should
be able to put one of these commands in my onclick event for the button:
unload me

I'm trying to write a macro in Access 2002 that opens the open file dialog
box.  The example I found in the online help doesn't work for me, I get an
error when I try to use it.
The example has me define a variable as a FileDialog type like this:

I created a Macro for a Conditional Expression.  The form is named 'Flag Time
Frame'.  I would like it to setvalue using a checkbox if the dates in the
"Answer" column are 45 days or old.
My condition is:  [Forms]![Flag Time

Acess 97
At the beginning of a macro, I would like a dialog box to appear with a
question : Are you sure that you want to execute this macro ? and two
buttons Yes and No.

I try the following module to close the Excel, but it didn't work. I am using
a simplified Chinses version, does it make any difference? It is a module I
found in here.
Public Function CloseMyExcel()

I have a query that each time it is run it will require a parameter to be
input.
Is there a way to have a mesgbox give instructions (I have that part) and
then have the macro 'pause' while the user puts the correct parameter in -

how to temporarily disable confirm record change during macro

I¹m a very basic user of macros. I¹ve created a bunch of pages with profiles
of childrens characters (photos, character formatting, paragraph formatting
involved) and I want to build a macros using Word¹s insert file command for
each character and build a menu for it. I¹m fine with ...

Hi NG,
I'm trying to get below code to work:
Private Sub SetExcelPath_Click()
'Update an existing record.'

When I try to run a macro to output a report in snapshot format to a file I
get an error message "The report snapshot was not created because you don't
have enough free disk space for temporary work files."
I have more than enough disk space.

I am running a report that generates about 10 letters and I want each letter
to be filed as a separate document to a different location. Can I use the
"OutputTo" option and just put a field name in for the location?

Is there a way to program text file data imports into Access (either vba or a
macro?  Something like the transfer database macro, but for text files?
Thanks for your help ...