Same DTPicker control different result?

[rgao]

Hi, there

Recently I have a problem with Active control-Date&Time Picker.I put two DTPickers in a form,(by default I want them display current date) but when this form is opened,one show current date, another one just show the date when I designed this form,it can not display the current date,why they have different result? I checked the property of them, everything is same,and I try to put code "me![date1].value=date" on form-open event, but got error message: this property is read only.Do you guys have any idea about it? Thanks in advance.

rgao

 

[pdtit]

Hey,

I use the DTPicker on one of my forms as well.
When placing them on the form and checking in view-mode, I also discovered they always show the date they have been placed on the form the first time.

RightClick on the DTPicker Control / Properties / enter the following in the ControlSource :
=Date()

When the form opens, it shows the current date in the DTPICKER Control

I hope this helps.

PdtIt

 

[rgao]

thanks
rgao

 

[danvlas]

That is wrong...sooooo wrong that it makes the date picker useless...or replaceable by a simple calculated text box showing the current date...it won't allow you to select another date...but maybe you can do it through Control Panel and change the system date... or run a batch file to do it from Access...or use the correct solution:

Private Sub Form_Load()
Me("date1&quot = Date
'or Me![date1].Value = Date
End Sub

works perfectly.

You can't use the Open event to set the value for this object. But Load is OK...

Good luck folks...

Daniel Vlas
Systems Consultant
danvlas@yahoo.com