Want to use MCConCtl.DTpicker to update "WeekEnding" field.

[plang99]

I have a field on a form called ActiveXCtl42 to choose the date and I want it to update a field called "WeekEnding".

The choose date field is using MCConCtl.DTpicker.

"WeekEnding" is a date field.

I used the code:
Private Sub ActiveXCtl42_LostFocus()
[WeekEnd] = ActiveXCt142
[WeekBegin] = [WeekEnd] - 6
End Sub
It does update the field but the date is always: "31-Dec-99".

 

[gusbrunston]

Hi:

I don't know how "MCConCtl.DTpicker" works but ...

In Access2000, I use MS' ActiveX Calendar. That control is bound to the field, "TransactionDate". I have a text box that is also bound to "TransactionDate". Selecting the date from the Calendar control populates the text box. No code in either control. I turn the calendar control on and off with a command button.

Maybe all you need to do is to bind the calendar control and the text box to the same field "WeekEnding".

Hope this is helpful. Gus Brunston An old PICKer, using Access2000.

 

[plang99]

I used instead CCRPDateTimePicker.ocx as it came as an EXE and it registered itself and it showed up in Access. Used similiar code as above.