Issue:
I have a table with trailer# , exit date, etc..
Once an exit date is entered I would like for the record to be moved to
another table or deleted all together.

There are few handful of us left but I'm trying to use the SendObject
to send an email using non-MS email applications.  Anyone know where to
start?
JG

How can i run a macro without the alerts to be shown. for example, when
running a delete macro, the messages "You are about to run a delete query
that.." ,and then "You are about to delete X rows" are shown.
Thanks,

Hello all I am trying to set up an automated task to run a macro in Access.
Looking at this forum..I need to put somethingl ike;
"C:\Tm.MDB" /x "SendMail"   in the tasktab of Scheduler where SendMail is
the name of a macro.  For some reason..I can get Access to open..but I can

I need a macro to import all tables in a database on my hard drive into
another database so I always have up to date information. The path name to
the database I need to import from is
c:\mitchell1\manager\series1\mdb\smcore32.mdb and I need to import all tables

I want to run a macro overnight that contains action queries. The problem is
how do I turn the confirmation message off. I have used
Tools_Options_Edit/find tab_Action Queries. The issue is that the queries use
data from tables hosted in America. Access help states that this is ...

I've got a query which displays contact information.
In the Address field....there is sometimes a "#" symbol (e.g.  145 Oak Street
#7).
I've got a Macro which will export the results of that query to XLS.  It uses

I'm having a problem with running a macro in a subform.  It works very
smoothly when I open the subform itself separately from the main form.
However, when I run it in the main form, I receive the following error:
Microsoft Access can't find the form referred to in a macro ...

I imported a text document (PA_Match_Test) into Access that contains one
field that has the street name, thoroughfare, and post directional.  I need
for this to be separated into the Street Name field, Thoroughfare field and
the Post Directional field.  I created a table called ...

I'm trying to construct a macro that will open any query in a database.  I
see that I can use the 'OpenQuery' action to open a specfic query by
supplying the name of the query as an argument.  Is there a way to set up a
macro so that when it runs, the user is presented with a ...

I'm running confused here between Marcro's, SQL, and VB.  I want to do enough
to get dangerous, but, I don't see myself as a Geek.  I really don't know
where to start to get myself in the position to write conditional macro's,
SQL, or VB.  Is there any help other then 2 semesters ...

is it possible to insert the now() function within the subject line of the
macro editor sendobject function?

I have 5 forms that come from 5 different queries. I would like to export the
data from the forms to the same excel file, as 5 separate worksheets.
Right now, i have a macro that runs:
OutputTo  -- and this takes care of the first form

I would like to sequentially print 3 reports that take their parameters from
a query returning three ids (parameters).
I used to do this in PDOX and it seemed much easier than in Access.
Thanks

I have created a database that forwards reports to various individuals via
Lotus Notes Mail.  It would work with any mail client.  Now, once that user
receives the report through the email, I have inserted a hyperlink so that
when they click they go directly to the database.  ...