Prev: DSum doesn't work on other PCs
Next: Multi-field query calculations
From: John Spencer on 12 Apr 2010 08:22
One way to do what you want is to use an AUTOEXEC macro.

Create a new macro
== Enter SendMessage as Macro Name
== Enter a condition of
Day(Date()) In (24,25,26,27)
== Enter MsgBox as the Action
== At the bottom enter the action arguments - your choice here.
== Save the Macro as AutoExec

Now whenever the database is opened on the specified dates the message will
pop up.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JohnW wrote:
> John S.
>
> We need the macro to run when they have the database open on those days; it
> is a reminder message on something they should be doing at the end of the
> month. We are using Access 2003. I am not sure about VBA functions being
> "allowed". I have used some VB coding in the program but I am certainly not
> good with and don't always understand some of the coding that you guys have
> suggested for me even when it works.
>
> Hope this helps. Thanks.
From: JohnW on 14 Apr 2010 19:11
Thanks John, this worked great.
--
JCW


"John Spencer" wrote:

> One way to do what you want is to use an AUTOEXEC macro.
>
> Create a new macro
> == Enter SendMessage as Macro Name
> == Enter a condition of
> Day(Date()) In (24,25,26,27)
> == Enter MsgBox as the Action
> == At the bottom enter the action arguments - your choice here.
> == Save the Macro as AutoExec
>
> Now whenever the database is opened on the specified dates the message will
> pop up.
>
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
>
> JohnW wrote:
> > John S.
> >
> > We need the macro to run when they have the database open on those days; it
> > is a reminder message on something they should be doing at the end of the
> > month. We are using Access 2003. I am not sure about VBA functions being
> > "allowed". I have used some VB coding in the program but I am certainly not
> > good with and don't always understand some of the coding that you guys have
> > suggested for me even when it works.
> >
> > Hope this helps. Thanks.
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: DSum doesn't work on other PCs
Next: Multi-field query calculations