belum bisa mas sumiyanto, keluar error sbb: "Method or data member not found" dan Me.datDeliveryDate diblok karena setelah Me. tidak muncul list datDeliveryDate.
regards, CW ----- Original Message ----- From: "Sumiyanto -" <[email protected]> To: [email protected] Date: 30 Maret 2010 09:34 Subject: Filter Report > > Coba di revisi : > > DoCmd.OpenReport stDocName, acPreview, , "Delivery Date = '" & > Me.datDeliveryDate & "'" > > Sumiyanto > > > From: Cecep W <[email protected]> > To: [email protected] > Sent: Tue, March 30, 2010 6:59:48 AM > Subject: [belajar-access] Filter Report > > > > hallo pakar access semua, > > saya membuat report dengan nama "CultureDeliveryRpt 2" dan didalam report > tsb ada field "Delivery Date" kemudian akan saya buka report tsb > menggunakan VBA sbb: > > Private Sub CmdCultureDelivery_ Click() > On Error GoTo Err_CmdCultureDeliv ery_Click > > Dim stDocName As String > Dim datDeliveryDate As Date > > stDocName = "CultureDeliveryRpt 2" > datDeliveryDate = InputBox("Masukan tangal Delivey Date") > DoCmd.OpenReport stDocName, acPreview, , "Delivery Date = '" & > datDeliveryDate & "'" > > Exit_CmdCultureDeli very_Click: > Exit Sub > > Err_CmdCultureDeliv ery_Click: > MsgBox Err.Description > Resume Exit_CmdCultureDeli very_Click > > End Sub > > setelah diklik muncul inputbox kemudian saya masukan tanggal 25/02/2010 > tapi report-nya tidak terbuka malah keluar error sbb: > > Syntax arror (missing operator) in query expression '(Delivery Date = > '25/03/2010' )' > > kenapa ya? > > > ------------------------------------ SPAM IS PROHIBITEDYahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-access/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
