Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Calendar Control (VBA/Access/97,2K)

    I'm just venturing into the Access-VBA arena and see a need for a pop up calendar allowing the user to select a date. Having found the example at <!post=post 316461,316461>post 316461<!/post> I am now looking for method to programmatically set the default date some nominal number of days in the future. Any guidance will be greatly appreciated.
    Regards
    Don

  2. #2
    3 Star Lounger
    Join Date
    Apr 2004
    Location
    Boston, Massachusetts, USA
    Posts
    389
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calendar Control (VBA/Access/97,2K)

    I've never used VBA with Access (I've barely used Access), but in Word you can do something like this with the Calendar Control:
    <pre>Private Sub UserForm_Activate()
    Me.Calendar1.Value = DateAdd("m", 6, Date)
    End Sub
    </pre>


  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Control (VBA/Access/97,2K)

    Thank you Andrew
    That is exactly what I'm after.
    Regards
    Don

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Control (VBA/Access/97,2K)

    Don,

    Please post your questions about Access, VBA or otherwise, in the Access forum. Access VBA is significantly different from the rest of Microsoft Office, and you can't use Access to its full potential without doing some programming. While some of us, notably Hans, also visit this board, your answers are more likely to be Access-specific in the Access board.
    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Calendar Control (VBA/Access/97,2K)

    Thank you for the guidance Charlotte; but you have also managed to instill some trepidation. Apparently the learning curve is going to be steeper than I expected. Oh well; knowledge should never be considered a burden.
    Thanks again.
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •