Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ActiveX Calendar Control (Access 2000)

    I am attaching a sample db...if someone could take a look at it, I would appreciate it.

    The problem....if I open frmSelectDate normally, it works just fine. However, if I open frmSelectDate using frmCode and Selecting either Employee or Benefits, I can't make a DAY selection from the calendar.

    FYI...I have OpenArgs in the OnOpen event of frmSelectDate.

    I would sure appreciate it if someone could provide the solution.

    Hair is almost gone....lol

    Thanks
    Attached Files Attached Files
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Calendar Control (Access 2000)

    Roberta,

    In you code you open your form Readonly.
    Remove Readonly and you can select a day.

    Hope this is what you want.
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Calendar Control (Access 2000)

    Francois,

    I checked the properties for ReadOnly and they are Enabled=yes and Locked=No.

    I also checked to see if they were changing if the form was opened via a control button, but they are still correct.

    That doesn't seem to be the problem.

    Any other suggestion?
    Thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Calendar Control (Access 2000)

    Roberta,

    In the code of the form frmCode for Command7_Click event you have a line :
    DoCmd.OpenForm "frmSelectDate", acNormal, , , acReadOnly, , "Employee"
    and for Command8_Click event :
    DoCmd.OpenForm "frmSelectDate", acNormal, , , acReadOnly, , "EmployeeBenefits"

    These two lines should be :
    for Command7_Click
    DoCmd.OpenForm "frmSelectDate", acNormal, , , , , "Employee"
    and for Command8_Click
    DoCmd.OpenForm "frmSelectDate", acNormal, , , , , "EmployeeBenefits"

    If you are not familiar with VBA, open you frmCode in design mode and press ALT+F11, you will see the code and be able to modify it.
    Francois

  5. #5
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ActiveX Calendar Control (Access 2000)

    Francois,

    Thank you so much...duh...I feel soooooo dumb...It works perfectly now.
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

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