ActiveX Calender Help

[007stuart]

I am looking to use on a form Calender Control 10 to allow a date to be selected.

Is is possible to configure the calender to invalidate selection of a date that is in the past?

 

[Mr. B]

I would suggest that you not use the Active X control at all but rather take a look at this link:
http://allenbrowne.com/ser-51.html

Try using this form for selecting a date. It is very easy to implement, just follow the instructions.

 

[missinglinq]

IF there's any chance that your db will be used with a different version of Access than the one you're developing it in, heeding the good doctor's advice would be wise. If you still want to use the ActiveX Calendar, code something like this will do it

Private Sub ActiveX_Calendar_AfterUpdate()
 If Me.ActiveX_Calendar < Date Then
  MsgBox "You cannot pick a date in the past! Try again!"
 Else
  'Code here to assign your date to your textbox
 End If
End Sub

 

[Mr. B]

missinglinq,

I have heard lots of horror stories about folk who have tried to use the ActiveX Calendar control and just had major issues with transfering their database form the development machine to other users.

I use the one that I posted the link to all the time and never have any issues with it. That is why I reccommended it here.

Thanks for the backup.

 

[billie66]

I would suggest that you not use the Active X control at all but rather take a look at this link:
http://allenbrowne.com/ser-51.html

Try using this form for selecting a date. It is very easy to implement, just follow the instructions.

Fantastic stuff thanks

 

[missinglinq]

When you're having a problem Allen's site is always a good place to start looking for an answer.