Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Coding (A2K)

    I have a form with a CboSample Date where I am using a pop-up ActiveX calendar on the mouse down event, however surfing the web I located a calendar, built as a form, that would be more to my liking.

    My problem is I lack the expertise in VBA to make this form calendar function in the same manner as the ActiveX calendar.

    Any help or a direction for good instructional reading would be greatly appreciated.

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

    Re: VBA Coding (A2K)

    Without more specifics it is impossible to give you any useful suggestions. You haven't indicated which calendar control you want to emulate or how the form you found differs in its behavior from the activex control.
    Charlotte

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Coding (A2K)

    Hi Jeff

    If your still searchng try the following:

    HTH

    John

    ====================

    Popups Database. (29KB ZIP File)

    http://easyweb.easynet.co.uk/~trevor/AccFA...oads.htm#popups

    A small mdb containing a few popup forms that you can call up from your forms to add functionality and ease of use to your applications.

    For text boxes you can use the Zoom box, like [Shift]+F2 but bigger and with customisable font & font size / style selection.

    For numeric fields, there's a calculator that will return the result straight to your field.

    And lastly, for dates there's the calendar, just like the OCX one that ships with the ADT but uses no OCX.
    This is my favorite Popup.mdb, works similar to calendar in Quicken.

    It also includes a calculator and text/memo zoom box

    I like it because mouse is not needed, keyboard works as follows: (see step 7)

  4. #4
    Star Lounger
    Join Date
    Sep 2003
    Location
    Ocean Gate, New Jersey, USA
    Posts
    55
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Coding (A2K)

    Charlotte And John

    Thank you for the reply's.

    John this worked great!

Posting Permissions

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