Backroads Data
backroad at idir.net
Tue Jul 15 09:23:17 CDT 2003
Hi all -
In Access97, I've used the pop-up calender / date-selector from Access97 Developer's Handbook (pp. 488-491) extensively throughout an application. I've had reports from various users that the calendar will quit working intermittantly for a while, then start to work again.
By "not working", they mean the calendar form appears, they can navigate to any date, but when selecting a date the system fails to update the date field (text box on the form) with the newly selected date. It will be in this state for a while, then will begin working properly again.
Below is the code I'm using to call the calendar and update the date field. Has anyone had any similar experience, or have any ideas what might be happening? TIA.
Private Sub dateStart_DblClick(Cancel As Integer)
Dim dateNew As Variant
Let dateNew = adhDoCalendar(Me.dateStart) 'get user's selected date
If IsNull(dateNew) Then 'user cancelled calendar form
Exit Sub
Else
Me.dateStart = CDate(dateNew)
End If
End Sub
Best Regards,
Julie Schwalm
Backroads Data
www.backroadsdata.com
785-594-6807
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030715/cdfa3684/attachment.html>