I'd like to run a query via
   docmd.RunSQL("Delete * from tableX")
and would like to suppress all the prompts.
Can this be done?

I'm trying to run an expression called Mod_Kill_Old_Rtfs () useing the
RunCode Action in a Macro.  I can run the expression directly from the
design view of the module with no problem.  However, when I try to run it as
part of a macro I receive the following error:

I woul;d like to have buttons on an Access form that open
speific Excel files, even if possible to open at named
ranges. I can add a button to Open Excel but that is the
default. I know how to add hyperlinks also.

I m not sure if this is the right place for my query?
I am a studrnt and  I am doing an assignment in which I have to import data
into Excel worksheet.Now this data needs to be appended to the existing data.
The problem is that Data that i am importing is only 10 fields and the

I have a list box that shows the account balance in a statement form.  I want
the form to bring up the record that I select on the list box.  The list box
is displayed on the form at all times.  I want the properties to bring up
that record when the selection in the list box is ...

I am trying to create a macro that e-mails information from a form to a
specified recipient included on the form. The macro currently attaches the
form to the e-mail but I can not figure out how to populate the "To" line
with the recipient listed on the form.

I'm using an existing Function in an Access file as a template to
write a Function for my database and for some reason VB doesn't
recognize something.
I copied the beginning part...

I am new to this and I need anyone's help. I have three
columns. In this example column one has a date of
02/23/05, column two has a date of 03/01/05.  I need to
have column three automatically fill in the total number

I am using A97 & Windows 2000.
I have four macros that each contains about 40 'Open Report' commands, each
with a particular 'condition', and with the View parameter for each set to
Print.

Is it possible to have a schedule job for a specific macro?
Any information is great appreciated?
Souris,

I have a form that is filter to show all records for a
specific date that is entered into a table.  I would like
the date to update to the current date upon opening the
database and then be able to select a new date there

I want to change the value of a special field of each
record in a endless form provided by a query.
There are 3 fields for each record, for example:
UserID, Password und ProjectID.

Please can someone tell me how to by creating a macro run a designated macro
in another database??
10x

Is there a way to have add an automatic update to a field (Date/Time) in a
table when any edit or change is made to the existing fields in the table.
When someone goes into an existing table to make a change to any field, the
field Date/Time will be updated with the Date andTime. ...

I am having a hard time getting a macro to run a query for me, does anyone
have any helpers?