Last Day Of The Month
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 302209 articles for 2.399 sec
Brendanpeek wrote: > ok cheers guess i need to rethink the whole thing. Make another MDB file (perhaps from a copy of your current one) and set it up so that all it does when you open it is run your functions and then closes itself. Set up your windows scheduler to open that file on the last day of each month. Use your current file for everything else you need to do. -- Rick Brandt     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Last Day Of The Month in microsoft.public.access.modulesdaovba
Author: Rick Brandt
Date: Sep 12, 2008 15:50

Please Refer to my second post. "John Spencer" wrote: 1) Does the database get opened every day of the month? 2) Do you want the code to only run once on the last day or does it have to run multiple times? I will assume ++ that the database is not running continuously ++ you only want to run KPICalStep1 once per period ++ that the database may not always be opened on
Show full article (0.48Kb) · Show article thread
OK got ya about the modules. i already have a swictboard which is always open and the event timer is used as well as the form open event, plus the Db never gets closed or opened, once i have finished designing the Db and open it, it will never be closed. "Chris O'C via AccessMonster.com" wrote: > Once you have a list of procedures you want to run only on the last day of > the month, create     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Last Day Of The Month in microsoft.public.access.modulesdaovba
Author: Brendanpeek
Date: Sep 12, 2008 10:16

1) Does the database get opened every day of the month? 2) Do you want the code to only run once on the last day or does it have to run multiple times? I will assume ++ that the database is not running continuously ++ you only want to run KPICalStep1 once per period ++ that the database may not always be opened on the last day of the month when the last day of the month falls on a weekend
Show full article (1.42Kb) · Show article thread
Interesting how many ways you can get to the same place: day(dateserial(2007,3,0)) returns 28 day(dateserial(2008,3,0)) returns 29 -- Dave Hargis, Microsoft Access MVP "Stuart McCall" wrote: > "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message > news:eUn1xSoiIHA.6092@TK2MSFTNGP06.phx.gbl... > > "MikeB" <m.byerleyATVerizonDottieNettie> wrote in message > > news     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Last Day Of The Month in microsoft.public.access.modulesdaovba
Author: Brendanpeek
Date: Sep 12, 2008 10:08

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:eUn1xSoiIHA.6092@TK2MSFTNGP06.phx.gbl... "MikeB" <m.byerleyATVerizonDottieNettie> wrote in message news:Ois6T5niIHA.1184@TK2MSFTNGP04.phx.gbl... "Alejandro" <Alejandro@discussions.microsoft.com> wrote in message news:34A88D61-8ABC-4179-B5F5-4396F343125D@microsoft.com... Hello there,
Show full article (1.55Kb) · Show article thread
"MikeB" <m.byerleyATVerizonDottieNettie> wrote in message news:Ois6T5niIHA.1184@TK2MSFTNGP04.phx.gbl... > >> "Alejandro" <Alejandro@discussions.microsoft.com> wrote in message >> news:34A88D61-8ABC-4179-B5F5-4396F343125D@microsoft.com... >>> Hello there, >>> >>> I would like to figure out the last day of a month, given a specific >>> month >>> and year. Not only would I like to know whether     

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Last Day Of The Month in microsoft.public.access.modulesdaovba
Author: John Spencer
Date: Sep 12, 2008 10:05

The last day of the month is: DateSerial(Year([MyDate]), Month([MyDate]) + 1, 0) Replace MyDate with the name of your date field. Access handles that correctly, even for December. If you just want the day number, add Day() around the expression. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather
Show full article (1.28Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for Last Day Of The Month in microsoft.public.access.modulesdaovba
Author: Brendanpeek
Date: Sep 12, 2008 09:22

Show full article (0.22Kb)
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Last Day Of The Month in microsoft.public.access.formscoding
Author: Klatuu
Date: Mar 20, 2008 07:33

Show full article (2.05Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Last Day Of The Month in microsoft.public.access.formscoding
Author: Stuart McCall
Date: Mar 20, 2008 05:37

Show full article (1.74Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Last Day Of The Month in microsoft.public.access.formscoding
Author: Douglas J. Steele
Date: Mar 20, 2008 05:19

Show full article (1.51Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Last Day Of The Month in microsoft.public.access.formscoding
Author: Allen Browne
Date: Mar 19, 2008 20:01

Show full article (0.91Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Last Day Of The Month in microsoft.public.access.formscoding
Author: Alejandro
Date: Mar 19, 2008 19:55

Show full article (0.33Kb)
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next