Results 1 to 2 of 2
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672

    Calendar Question


    I have 2 fields on a form - start date & end date that are populated based off of a users selection on a calendar. The problem I have is that I have currently just been going into calendar properties to change the date of the calendar, but this is getting tedious. Is there a way to use vba to change the date on the calendar to whatever the current month is? (Example it's April 2014 so the calendar should be set to April 2014)

  2. #2
    jo15765's Avatar
    jo15765 is offline Expert
    Windows XP Access 2000
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    672
    Quote Originally Posted by jo15765 View Post
    I have 2 fields on a form - start date & end date that are populated based off of a users selection on a calendar. The problem I have is that I have currently just been going into calendar properties to change the date of the calendar, but this is getting tedious. Is there a way to use vba to change the date on the calendar to whatever the current month is? (Example it's April 2014 so the calendar should be set to April 2014)
    Haha - I figured it out. On the OnLoad() Event of the form, I added this code:
    Code:
    Me!Calendar.Today
    Where Calendar is the name of my calendar.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Question about ActiveX Calendar
    By Buakaw in forum Access
    Replies: 0
    Last Post: 03-01-2011, 02:59 AM
  2. Calendar example
    By pkstormy in forum Code Repository
    Replies: 1
    Last Post: 02-28-2011, 04:09 AM
  3. Calendar Birthday Question
    By kirklandwater123 in forum Access
    Replies: 4
    Last Post: 10-29-2010, 11:20 PM
  4. Calendar question in access 2007
    By DPG in forum Database Design
    Replies: 6
    Last Post: 10-06-2010, 11:22 AM
  5. Help with Calendar
    By alanl in forum Access
    Replies: 1
    Last Post: 03-15-2010, 08:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums