 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / November 2007Code for first of the month
I want create code that will call a function on the first day of each month. Any help? Hi, you could try: If DateSerial(Year(Date),Month(Date),1) = Date Then 'execute your code End If HTH Good luck  SignatureOli-S Admin Specialist & Computer Science Major @ UMD - Go Terps - :) http://www.oli-s.de > I want create code that will call a function on the first day of each month. > Any help? > Hi, > you could try: > > If DateSerial(Year(Date),Month(Date),1) = Date Then > 'execute your code > End If Wouldn't If Day(Date) = 1 Then ' ... be simpler? SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Thanks everyone... > > Hi, > > you could try: [quoted text clipped - 9 lines] > > be simpler? >I want create code that will call a function on the first day of each month. >Any help? Dirk's solution is simplest as long as you can guarantee that the _calling_ code will run (at least once) on the first day (which may not be a working day) of every month. If what you really want is to ensure that your function is called on the first occasion on which the application and/or calling code runs in each new month, which is rather different (and somewhat more probable in most business applications), you will have to be more creative. In this case, you will need to save the current month value, either in a Table, or in the Registry, each time the program runs, and compare the new current month with the saved value on startup to determine if you are in a new month. Please respond to the Newsgroup, so that others may benefit from the exchange. Peter R. Fletcher what if the database is never shutdown? will the code still execute? my dilemma... I need to create a supervisory log for my clients. The log table has the following fields date, checkbox and notes. now for the tricky part... one log is weekly and should be generated every monday. i have a similar log that will be run on the first of each month. so i need a record auto generated every Monday of the week and another generated on the first of every month... these will be in two separate tables. .. also possible to auto email to the client??? from there i will email that record w/access 2007 to the client so they can fill out the rest of the information. then i can append the record back the DB and create a report. suggestions please and thanks in advance. >>I want create code that will call a function on the first day of each month. >>Any help? [quoted text clipped - 13 lines] >Please respond to the Newsgroup, so that others may benefit from the exchange. >Peter R. Fletcher Signaturebrandon |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.