Web Development

Ask something
Discussion Locked

ActiveX Date and Time Picker in Access

0 helpful
6 replies

by jayyemi

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

6 replies

by salgado.m

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

Any workaround?

Thanks!

by stuart.woodhead

I got round this issue with

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

might be useful.

This discussion is closed to new replies.