Date and Time Picker Control

[Frank]

I'm trying to use the Microsoft Date and Time Picker control and I receive
the following error...

"An error occured in a call to the windows date and time picker control".
Btw, I'm using Access 2002. I also get another error "Can't set value to
null when checkbox
property = false". If I set that property to True than I get a checkbox in
the controls inputbox which I do not want.

Some of the records that will use this field will not have data in it. Does
that create a problem???

In short, how can I get this control to work with out error?

Thanks in advance for all your help.

Frank

 

[Allen Browne]

Yes, it does create a problem. Last time I messed with it, the DT picker
could not handle Null. It is also subject to versioning problems, licensing
issues, ... all the stuff you expect with DLL hell.

Would pop-up calendar do? There's several out there, e.g.:
http://members.iinet.net.au/~allenbrowne/ser-51.html
That one is just an Access form that you import into your database, so it
has none of the DLL hell issues.

 

[Frank]

Allen,

That worked perfectly. I spent hours yesterday trying to fix the DT Picker
control but was having no luck. I looked through all the postings and
couldn't find a solution... unitl NOW! Thank you for this very simple fix.
I hope everyone can now benefit from this posting in the future. It
accomplishes the same functionality but w/ a different approach. Thanks
again.

Frank

 

[Frank]

Allen,

Can you control exactly where the calendar form appears? I have 3 fields on
my form that require date input. The first 2 are in the upper left portion
of the form, so the calendar box opens up relatively close to the date entry
field. However, on the lower right is another date input field. When I
press the button for date selection there, the calendar box appears way up
top, which makes it look unprofessional.

Question: For each calendar button click on the same form, can I designate
the exact location where I want the calendar box to appear for each button?
(i.e. When I press Button1, the calendar goes to position X,Y.... when I
press button 2 the calendar goes to position X,Y.... when I press button 3
the calendar goes to position X,Y). Any help is greatly appreciated. Thanks.

Frank

 

[Allen Browne]

Hi Frank

As you know, it's just a simple little Access form. You could add some
programming to manage where it pops up, using API calls to Windows. As it
is, that does not happen, but you're welcome to add that if you wish.

You can pass a caption for the title bar of the calendar though, so the user
is informed about which date they are selecting.