Is it possible to copy prompted parameter to several queries run by
the macro?
Meaning...
I have three macros that update the same table in different ways but

I have a macro which publishes a set of reports to Word once the user has
finished, by running a macro on close of the form used to update.
Each time I get a dialog box that asks me if I want to replace the existing
Word file, which of course I do.

I am using the requery and refresh commands to update the the results of a
subform.  i am getting an error message that the command or action 'requery'
is not available now.  this command is working in other databases i am using
now, but not this current one.

Is there a code that I can use to sent a sms
John

I have a macro that uses transferspreadsheet to import an
excel file into the database.  In my filename, I currently
have "c:\sales.xls". I would like to let the user choose
the file.

I have a successful make table query but need to disable
all pop up windows that ask for confirmations of
overwriting the current table.  I want the query to always
overwrite the output table but without asking for permission.

I'm using the Weekday function to produce the day of the week (integer); I
want to convert the integer to a string, for example, 1="Sunday." The
function is working but I'm getting a type mismatch error. Help!

I have 15 queries set up for 15 various products in one
database, so that when I run the query it asks me to put
in the beginning and start date for when the product was
sold.  Is there any way to run a macro, so that it

I have designed some macros that have created two specific challenges for me.
1.  The first is a an import function.  Aside from having the end-user
selecting the file to import, all prompts for the import function will always
be answered the same way.  How do I set up the macro ...

I want to create a macro that upon closing the database
will automatically compact the database.  Can anyone help?
Thanks!

I am using Access 2002 and trying to open a file in MS
Word with the following in the command line:
"C:\Program Files\Microsoft Office\Office10
\WINWORD.EXE": "C:\Temp\cve.txt"

I am in the process of creating a macro to export
table into a file, it is asking me for specification
name. What is this and how can I create one?
Thank you,

I have a database that automatically exports data to excel. I want to format
this data in excel automatically through a macro in access. How do I get
access to allow me to do this?
I don't want to do anything complicated, just things like increase the row

I am looking a macro function to eliminate the special
characters like "[", square boxes....is there a way do
it...actually i having text field...which contains such
characters...actually they were imported from excel...

I have a macro set to run 10 queries, is there a way to
set the macro to where it runs all the queries with the
same criteria. Example if I wanted to use between [please
enter starting date] and [please enter ending date] for