Solved

DTPicker doesn't fire change event

Posted on 2001-07-02
15
1,309 Views
Last Modified: 2010-08-05
Hello Experts.

I'm developing with vb6 (SP3).
I have a DTPicker-Control included in MSCOMCT2.OCX (v.6.00.8418)

placed on a Form.

Code to reproduce behaviour:

Private Sub DTPicker1_Change()
    MsgBox "Date changed !"
End Sub


Private Sub Form_Load()
    DTPicker1.Value = "21.04.1997"
    DTPicker1.Value = "02.02.2000"
End Sub

... but no MsgBox appears !

 
0
Comment
Question by:VK
  • 6
  • 3
  • 2
  • +3
15 Comments
 
LVL 43

Expert Comment

by:TimCottee
ID: 6244938
It would appear that this event is only fired when the control's value is changed by the control itself and not through code!
0
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 6244953
Hi VK,

Try to modify the

Private Sub Form_Load()
   DTPicker1.Value = "21.04.1997"
   DTPicker1.Value = "02.02.2000"
End Sub

to

Private Sub Form_Load()
   DTPicker1.Value = "21/04/1997" 'Or "21-04-1997"
   DTPicker1.Value = "02/02/2000" 'Or "02-02-2000"
End Sub

And try again.

The sub

Private Sub DTPicker1_Change()
   MsgBox "Date changed !"
End Sub

is tested ok.
0
 
LVL 50

Expert Comment

by:Ryan Chong
ID: 6244976
Hi,

in your Form_load()

change

DTPicker1.Value = "21.04.1997"

to

DTPicker1.Value = CDate("21-04-1997")
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Expert Comment

by:Onkar
ID: 6245012
Hi,

When you assign vlue to DTPicker change event will not fire. Once you select a date from the DTPicker then it fires change event "DTPicker1_Change"

Onkar
0
 
LVL 6

Author Comment

by:VK
ID: 6245046
I know that the event fires when i change the value of the DTPicker from GUI, but i have to do it from code. Calling
Call DTpicker1_Change is not elegant.
0
 
LVL 6

Author Comment

by:VK
ID: 6245054
I know that the event fires when i change the value of the DTPicker from GUI, but i have to do it from code. Calling
Call DTpicker1_Change is not elegant.
0
 
LVL 6

Author Comment

by:VK
ID: 6245063
I know that the event fires when i change the value of the DTPicker from GUI, but i have to do it from code. Calling
Call DTpicker1_Change is not elegant.
0
 
LVL 6

Author Comment

by:VK
ID: 6245071
Thanks for so much reply, but

DTPicker1.Value = CDate("21-04-1997")

AND

DTPicker1.Value = "21/04/1997" 'Or "21-04-1997"
DTPicker1.Value = "02/02/2000" 'Or "02-02-2000"

doesn't work !

It's not a formatting problem i think !

0
 
LVL 3

Accepted Solution

by:
nigelrowe earned 50 total points
ID: 6245130
Event Change()
    Member of MSComCtl2.DTPicker
    Occurs when the user selects a new date or changes a date in the edit portion of the control.

(VB object browser)
0
 
LVL 6

Author Comment

by:VK
ID: 6245154
It's not the solution, but it is the best answer describing the reason why.

Ty
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 6245164
VK, sometimes we have to take the inelegant solution when there is no alternative. In this case I think that there is no alternative as the only way I have found to get the change event to fire is by using the GUI control itself. Even the CCRP date time picker control which in some ways is a better control exhibits the same behaviour in respect of the change event when the value is set in code.

I guess you will just have to call the change event in code (or perhaps a nicer solution would be to move the code from the change event to a seperate sub/function and call this directly - and from the change event sub as well).
0
 
LVL 3

Expert Comment

by:nigelrowe
ID: 6245306
Yes, not much of a solution was it? Tim Coffee is right, you don't seem to have much of a choice here. Cheers and good luck.
0
 
LVL 28

Expert Comment

by:AzraSound
ID: 6245380
one lump of sugar or two Tim Coffee?
0
 
LVL 43

Expert Comment

by:TimCottee
ID: 6245434
Two please and a shot of Irish Whiskey as well thanks Azra!
0
 
LVL 6

Author Comment

by:VK
ID: 6247451
Ty TimCottee and AzraSound for the good resonance. Next time if i'm unsure whom to give the points Tim would get them :-).

Cu
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question