Run a macro on a specific date - JCW
in [Queries]
|
From: JohnW on 10 Apr 2010 18:51 I have a macro set up that runs a MsgBox that I need to run on some specific dates at the end of the month. I would like to run the macro on the 24th, 25th, 26th, and 27th of each month. Any suggestions on how to do this? Thanks -- JCW
From: John W. Vinson on 10 Apr 2010 19:54 On Sat, 10 Apr 2010 15:51:01 -0700, JohnW <JohnW(a)discussions.microsoft.com> wrote: >I have a macro set up that runs a MsgBox that I need to run on some specific >dates at the end of the month. I would like to run the macro on the 24th, >25th, 26th, and 27th of each month. > >Any suggestions on how to do this? Thanks Use Window Scheduler to launch Access, using the /x Macroname command line switch. -- John W. Vinson [MVP]
From: John Spencer on 11 Apr 2010 09:23 More details might help. Do you want to run the macro whenever the database is opened on those dates? Do you want to run the macro independently of the database being opened? Are you allowed to use VBA functions in your database? What version of Access are you using? John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County JohnW wrote: > I have a macro set up that runs a MsgBox that I need to run on some specific > dates at the end of the month. I would like to run the macro on the 24th, > 25th, 26th, and 27th of each month. > > Any suggestions on how to do this? Thanks
From: JohnW on 11 Apr 2010 17:28 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. -- JCW "John Spencer" wrote: > More details might help. > > Do you want to run the macro whenever the database is opened on those dates? > Do you want to run the macro independently of the database being opened? > Are you allowed to use VBA functions in your database? > What version of Access are you using? > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > JohnW wrote: > > I have a macro set up that runs a MsgBox that I need to run on some specific > > dates at the end of the month. I would like to run the macro on the 24th, > > 25th, 26th, and 27th of each month. > > > > Any suggestions on how to do this? Thanks > . >
From: JohnW on 11 Apr 2010 19:44
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. -- JCW "John Spencer" wrote: > More details might help. > > Do you want to run the macro whenever the database is opened on those dates? > Do you want to run the macro independently of the database being opened? > Are you allowed to use VBA functions in your database? > What version of Access are you using? > > John Spencer > Access MVP 2002-2005, 2007-2010 > The Hilltop Institute > University of Maryland Baltimore County > > JohnW wrote: > > I have a macro set up that runs a MsgBox that I need to run on some specific > > dates at the end of the month. I would like to run the macro on the 24th, > > 25th, 26th, and 27th of each month. > > > > Any suggestions on how to do this? Thanks > . > |