The date functions built into VBA make it easy to perform calculations based on date arithmetic, such as finding the occurrence of a specific date within the current year. The VBA example in this download accompanies the Visual How To article Finding the Next Anniversary of a Given Date in Access 2010.

This download works with the following Office applications:

To install this download:

  1. Download the file by clicking the Download link (above) and saving the file to your hard drive.
  2. Double-click the AccessNextAnniversary_CODE.zip file on your hard disk drive to extract the file named AccessNextAnniversary.accdb.