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

    Re: Access (2003)

    It isn't clear to me exactly what you mean. You say you want to build a popup calendar and then that you have 2 forms that have calendar controls on them. Do I understand that you have built 2 popup calendar forms but they aren't behaving the way you want, or are you saying something else? And which calendar control are you using (there are several)?
    Charlotte

  2. #2
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problems with popup calendar (Access 2003)

    Subject edited by HansV to aid in future searches ("Access" wasn't very specific)

    I am stuck...probably overlooking the obvious, as usual, but I have a form to be used to enter vacation requests. I want to build a pop up calendar that will show up when I try to put in a date for vacation. Now, I have 2 fields in my table...one for start date and one for end date, as this database will be used to track all dates requested off, and have built a form for the time off request. I have 2 forms build that have calendar controls on them...my problem right now is that when i (the cursor) enter the control and the calendar form pops up, it doesn't go away. I know that means i have my macro in the wrong event. And, I can't remember how to tell the control on the request form that the value that should show there is equal to the date I clicked on in the calendar pop up...I have been able to do that in the past and am totally drawing a blank as to what I did and what I am missing now...I've been staring at this and we all know how that goes...[img]/forums/images/smilies/wink.gif[/img] I tried using just a date and time picker, but I keep getting an error message that says it can't use what was selected if the check box property is set to false. Like I said, I am probably missing the most simple of steps, my brain is just so worn out on this Sunday night, I needed to call in the cavalry <img src=/S/smile.gif border=0 alt=smile width=15 height=15> Any help would be greatly appreciated!!!!!!!!!!!!!!!!!!!!

  3. #3
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2003)

    Yes, I already have 2 forms with calendar controls on them. I am using calendar control 11.0. I didn't know any other way to get a pop up calendar other than to build an unbound form with just a calendar control on it...and since i have 2 different dates I am asking for with the time off request, I built 2 forms for the calendars...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Access (2003)

    It should be possible to use only one popup form for both dates. Or put the calendar on the form itself. The attached demo shows how to simulate a dropdown calendar. There are two combo boxes, one for start date and one for end dat, but only one calendar control.

    If you prefer a popup calendar, see <post#=254,241>post 254,241</post#>.

  5. #5
    New Lounger
    Join Date
    Mar 2006
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access (2003)

    THANK YOU THANK YOU THANK!!!

    I have now already used that code in like 4 other databases!! You rock!!

Posting Permissions

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