dear all, dibawah ini source untuk report, dan koneksinya langsung ke database, kalo mau menggunakan ODBC cara ubahnya gimana ya.......
Private Sub isButton1_Click() With Form1.crFaktur .DataFiles(0) = App.Path & "\database.mdb" .ReportFileName = App.Path & "\Report\LapFaktur.rpt" .RetrieveDataFiles .UserName = "admin" .Password = "password" & Chr(10) & "password" .SelectionFormula = "{PENJUALAN.NoNota}='" & Me.Combo1.Text & "'" If Me.Option3.Value = True Then .Destination = crptToWindow Else .Destination = crptToPrinter End If .Action = 1 .PageZoom (89) End With End Sub terima kasih [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[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/