Date picker trouble "RipperT" <rippert<nospam>[ at ]comcast.net> 28.09.2006 01:33:21 I am using the Microsoft Date and Time Picker Control 6.0 (SP4) with MS Access 2002 (SP2) and it is not working. I am using the below code which works fine until I replace the txtDate textbox with the date picker named DTPicker9. Then, the On No Data event fires in the report. Using the same criteria, except with a Date Picker instead of a text box. Dim stDocName As String stDocName = "rptInCount" DoCmd.OpenReport stDocName, acViewPreview, , _ "(qryIncount.CountDate = Forms![frmSelectIncountTime]![txtDate]) " _ & "and (qryIncount.CountTime = Forms![frmSelectIncountTime]![cboCountTime])" I'm fuzzy on the version #'s and service packs. Are they the trouble? Many thanx, Ripper

RE: Date picker trouble VanmaN 28.09.2006 07:41:03 I would instead of the Date & Time picker use the Calendar Control 10 unless you need to pick a specific time as well. Calendar Control only allows for a date selection. Create the Calendar control on your form. Add the folowing code under your Form's on load event. Private Sub Form_Load() Me.Calendar0.Value = Date End Sub Also add the following sub: Private Sub Calendar0_Click() Me.txtDate = Me.Calendar0 End Sub When you select a date on the Calendar, the txtDate will be updated with the selected date and your code should work without any modification to it. NOTE: Calendar Control is not part of Office but not part of the Default installation and you might need to install it from your Office CD. "RipperT [ at ]comcast.net>" wrote: [Quoted Text] > I am using the Microsoft Date and Time Picker Control 6.0 (SP4) with MS > Access 2002 (SP2) and it is not working. I am using the below code which > works fine until I replace the txtDate textbox with the date picker named > DTPicker9. Then, the On No Data event fires in the report. Using the same > criteria, except with a Date Picker instead of a text box. > > Dim stDocName As String > > stDocName = "rptInCount" > DoCmd.OpenReport stDocName, acViewPreview, , _ > "(qryIncount.CountDate = > Forms![frmSelectIncountTime]![txtDate]) " _ > & "and (qryIncount.CountTime = > Forms![frmSelectIncountTime]![cboCountTime])" > > I'm fuzzy on the version #'s and service packs. Are they the trouble? > > Many thanx, > > Ripper > > >

Re: Date picker trouble pietlinden[ at ]hotmail.com 28.09.2006 13:54:51 Personally, I'd skip the OCX nonsense altogether and use Ken Getz's one from the Developer's Handbook or one like it. The problems the ActiveX garbage creates just isn't worth the hassle. Sure the DTPicker is small, but totally inconvenient if you're trying to distribute your app. Although Ken's code at least used to erase the date in your field if you cancelled closed the calendar without choosing a date. (I think I fixed it by setting the calendar function's return value to default to the existing value).

Re: Date picker trouble "RipperT" <rippert<nospam>[ at ]comcast.net> 28.09.2006 19:16:00 I appreciate the responses. The calendar control feature worked nicely, but it is not installed on all of the machines on our network and I don't have time or resources to make it so. So, if anyone has had experience with the ActiveX Date picker and can offer some ideas about how to make it work, I would be most appreciative. If not, then I'll go with one of the 3rd party offerings. Many thanx. R <pietlinden[ at ]hotmail.com> wrote in message news:1159451691.361618.276550[ at ]e3g2000cwe.googlegroups.com... [Quoted Text] > Personally, I'd skip the OCX nonsense altogether and use Ken Getz's one > from the Developer's Handbook or one like it. The problems the ActiveX > garbage creates just isn't worth the hassle. Sure the DTPicker is > small, but totally inconvenient if you're trying to distribute your > app. Although Ken's code at least used to erase the date in your field > if you cancelled closed the calendar without choosing a date. (I think > I fixed it by setting the calendar function's return value to default > to the existing value). >