baby calendars revisited

  • Thread starter Thread starter goomba
  • Start date Start date
G

goomba

Thank you all for your help with that wonderful program
lebans.com; its perfect.

Now, I'm gonna throw a twist.... I would like to use this
on ALL fields that require a date input. Is there a way
to make this available for global usage or do I have to
code it for each and every input box?

Best Regards.
 
On your calendar form, put the following in the Click event or AfterUpdate
event of the calendar control:
Me.Visible = False

Also have a Close or Cancel button on the calendar form.

Put the following code at each textbox where you want to enter a date value:
DoCmd.OpenForm "MyCalendar",,,,,acDialog
If Not IsLoaded("NameOfCalendarForm") Then
Exit Sub
End If
Me!NameOfMyDateTextbox = Forms!NameOfCalendarForm!NameOfCalendar.Value
 
Good choice on using Sensei's calendar.

As the knight says to Indiana Jones in the Last Crusade, "You have chosen wisely."

To the best of my knowledge I believe you will have to add cod to each control you wish to pop up
his calendar. It actually does not take too long to just copy/paste and change the control name. I'm
not sure if a global usage would work with his calendar, but I'm sure he will prove me wrong.
:-)
 
Back
Top