Web Development

General discussion

Gravatar
0 Votes
Locked

ActiveX Date and Time Picker in Access

By jayyemi ·
I discovered that when you are programming in Access 2000 and you made use of Microsoft Date & Time picker ActiveX within the tab control it gives out the error message (Runtime error '-2147352567(0020009)' DTPicker returned the error: An error occured in a call to the windows Date and Time picker control).

Incase you have more than 2 one tab control on the form, the DTpicker ActiveX control will work but the ones in the other tab control won't work and brings out the above error message whenever you want to write the content of the control into a table or storing the control date using Now() to refresh the control.

Any assistance from anyone.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

gravatar
Collapse -

ActiveX Date and Time Picker in Access

by jayyemi In reply to ActiveX Date and Time Pic ...

Point value changed by question poster.

gravatar
Collapse -

ActiveX Date and Time Picker in Access

by jayyemi In reply to ActiveX Date and Time Pic ...

Very Urgent please

gravatar
Collapse -

ActiveX Date and Time Picker in Access

by jayyemi In reply to ActiveX Date and Time Pic ...

Point value changed by question poster.

gravatar
Collapse -

by salgado.m In reply to ActiveX Date and Time Pic ...

Same problem here. DT Picker and Tab control don' go along nicely...

Any workaround?

Thanks!

gravatar
Collapse -

by info In reply to ActiveX Date and Time Pic ...

Consider using XE Date Control
It is much better than DTPicker
http://www.xe-soft.com/xedate.asp

gravatar
Collapse -

by stuart.woodhead In reply to

I got round this issue with

tabControl.Pages(1).SetFocus
datePicker = Now()
tabControl.Pages(0).SetFocus

might be useful.

Back to Web Development Forum

Start or search

Related Discussions

Related Forums