Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Calendar Control 11.0

Discussion in 'Information Technology' started by Claude Amyotte, Jul 28, 2006.

  1. Claude Amyotte

    Claude Amyotte
    Expand Collapse
    Guest

    Hi.

    I'm having trouble's setting the default value of the Calendar Control when
    it's unbound and the form is first opened. I want it to display the current
    date but nothing seems to work.

    For example:

    me.calendar1.value = Date ( I have this in the 'Open' event of the form )

    Anything would be helpful. Thank you.

    Claude.
     
  2. Loading...


  3. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello Claude.

    Claude Amyotte wrote:
    > I'm having trouble's setting the default value of the Calendar Control
    > when it's unbound and the form is first opened. I want it to display the
    > current date but nothing seems to work.
    >
    > For example:
    > Me.Calendar1.Value = Date (I have this in the 'Open' event of the form)


    Try this in the Load event.

    --
    Regards,
    Wolfgang
     
  4. Wolfgang Kais

    Wolfgang Kais
    Expand Collapse
    Guest

    Hello Claude.

    Claude Amyotte wrote:
    > I'm having trouble's setting the default value of the Calendar Control
    > when it's unbound and the form is first opened. I want it to display the
    > current date but nothing seems to work.
    >
    > For example:
    > Me.Calendar1.Value = Date (I have this in the 'Open' event of the form)


    Try this in the Load event.

    --
    Regards,
    Wolfgang
     
  5. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    Claude Amyotte <claudeamyotte@home.com> wrote:

    >I'm having trouble's setting the default value of the Calendar Control when
    >it's unbound and the form is first opened. I want it to display the current
    >date but nothing seems to work.


    In addition to Wolfgang's postings I'd suggest not using the Calendar
    Control at all.

    See the Calendar Tips page at my website
    http://www.granite.ab.ca/access/calendars.htm

    There could, likely will, be lots of version problems when you go to
    distribute the MSCal.OCX..

    One alternative is MonthCalendar is a completely API generated Month
    Calendar derived directly from the Common Control DLL. There are
    links to several downloadable calendar forms at my website. As these
    are forms you can also do anything with them you want.

    You can also use the calendar form which comes in the Access <insert
    your version here> Developers Handbook by Litwin/Getz/Gilbert,
    publisher Sybex www.developershandbook.com. These books are well
    worth spending money. Every time I open one I save the price of the
    book.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  6. IM4Jayhawks

    IM4Jayhawks
    Expand Collapse
    Guest

    Hi Tony,

    I tried your tip on A Pop-up Calendar for your Access Forms (1st link in
    your post). I noticed that in your first image that your form shows a
    "StartDate" and "EndDate." I followed your procedures for my Start Date
    field, even through the last section "What About Multiple Calendars?". My
    question is, do I follow the entire procedure again to set up my End Date
    field that I have on the same form?

    Thanks!

    "Tony Toews" wrote:

    > Claude Amyotte <claudeamyotte@home.com> wrote:
    >
    > >I'm having trouble's setting the default value of the Calendar Control when
    > >it's unbound and the form is first opened. I want it to display the current
    > >date but nothing seems to work.

    >
    > In addition to Wolfgang's postings I'd suggest not using the Calendar
    > Control at all.
    >
    > See the Calendar Tips page at my website
    > http://www.granite.ab.ca/access/calendars.htm
    >
    > There could, likely will, be lots of version problems when you go to
    > distribute the MSCal.OCX..
    >
    > One alternative is MonthCalendar is a completely API generated Month
    > Calendar derived directly from the Common Control DLL. There are
    > links to several downloadable calendar forms at my website. As these
    > are forms you can also do anything with them you want.
    >
    > You can also use the calendar form which comes in the Access <insert
    > your version here> Developers Handbook by Litwin/Getz/Gilbert,
    > publisher Sybex www.developershandbook.com. These books are well
    > worth spending money. Every time I open one I save the price of the
    > book.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >
     
  7. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    IM4Jayhawks <IM4Jayhawks@discussions.microsoft.com> wrote:

    >I tried your tip on A Pop-up Calendar for your Access Forms (1st link in
    >your post). I noticed that in your first image that your form shows a
    >"StartDate" and "EndDate." I followed your procedures for my Start Date
    >field, even through the last section "What About Multiple Calendars?". My
    >question is, do I follow the entire procedure again to set up my End Date
    >field that I have on the same form?


    Assuming that you used the MonthCalendar MDB from
    http://www.lebans.com/monthcalendar.htm the only steps you need to
    repeat for the second date are 7, 8 and 9.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
  8. IM4Jayhawks

    IM4Jayhawks
    Expand Collapse
    Guest

    > Assuming that you used the MonthCalendar MDB from
    > http://www.lebans.com/monthcalendar.htm the only steps you need to
    > repeat for the second date are 7, 8 and 9.


    No - I followed your instructions, which had me get the calendar from
    Access' Calendar Control.

    Thanks again.

    "Tony Toews" wrote:

    > IM4Jayhawks <IM4Jayhawks@discussions.microsoft.com> wrote:
    >
    > >I tried your tip on A Pop-up Calendar for your Access Forms (1st link in
    > >your post). I noticed that in your first image that your form shows a
    > >"StartDate" and "EndDate." I followed your procedures for my Start Date
    > >field, even through the last section "What About Multiple Calendars?". My
    > >question is, do I follow the entire procedure again to set up my End Date
    > >field that I have on the same form?

    >
    > Assuming that you used the MonthCalendar MDB from
    > http://www.lebans.com/monthcalendar.htm the only steps you need to
    > repeat for the second date are 7, 8 and 9.
    >
    > Tony
    > --
    > Tony Toews, Microsoft Access MVP
    > Please respond only in the newsgroups so that others can
    > read the entire thread of messages.
    > Microsoft Access Links, Hints, Tips & Accounting Systems at
    > http://www.granite.ab.ca/accsmstr.htm
    >
     

Share This Page