Start and End Date in DatePicker |
Post Reply |
Author | |
vollweise
Groupie Joined: 25 February 2010 Location: Germany Status: Offline Points: 14 |
Post Options
Thanks(0)
Posted: 01 April 2011 at 2:56am |
How can I start date and end date
the date picker with VB or VBA query Private Sub DatePicker2_SelectionChanged () MsgBox start date MsgBox end date End Sub |
|
Michael Ricklefs
|
|
SuperMario
Admin Group Joined: 14 February 2004 Status: Offline Points: 18057 |
Post Options
Thanks(0)
|
If you allow non-continuous selection then you will need to refine your query, each selection is know as a block. Here is code assuming 1 continuous block:
Private Sub wndDatePicker_SelectionChanged() If wndDatePicker.Selection.BlocksCount = 1 Then Debug.Print wndDatePicker.Selection.Blocks(0).DateBegin Debug.Print wndDatePicker.Selection.Blocks(0).DateEnd End If End Sub |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |