Comments by Member 11757843

Member 11757843 26-Jun-15 3:03am View

how to send my table to you for checking ?

Member 11757843 26-Jun-15 2:59am View

when we use other table like(db.mdb) on this coding it is working.

but my table is not working (bank.mdb)

Member 11757843 11-Jun-15 5:30am View

Private Sub Command1_Click()
StartStg = DT_Start.Value
EndStg = DT_end.Value
lvw_recordsfound.ListItems.Clear

With db_employee
.RecordSource = "SELECT * FROM employee WHERE (((employee.Date) Between # " & StartStg & " # And # " & EndStg + " #)) "

rec_count = db_employee.recordset.RecordCount
If db_employee.recordset.RecordCount <> 0 Then
Populate_lvw_recordsfound

cmd_PreviewReport.Enabled = True
Else
cmd_PreviewReport.Enabled = False
End If
End With

error in line : rec_count = db_employee.recordset.RecordCount

run time error 91
objectt variable or with block variable not set

Member 11757843 11-Jun-15 5:26am View

databasename error showing

Member 11757843 11-Jun-15 5:26am View

db_employee.databasename = App.Path & "\bank.mdb"

Complie error showing
method or data member not found

Member 11757843 11-Jun-15 4:02am View

db_employee.Refresh

syntex error-in from clause
runtime error- 2147217900(80040e14)
method 'refresh' of obkect 'IAdodc' failed

Member 11757843 11-Jun-15 3:55am View

please reply

Member 11757843 11-Jun-15 3:47am View

thanks...

Member 11757843 11-Jun-15 3:45am View

If .recordset.RecordCount <> 0 Then

complie error
invalid or unqualified reference

Member 11757843 11-Jun-15 3:43am View

error showing again
on
rec_count = .recordset.RecordCount

error coming on recordset

complie error
invalid or unqualified reference

Comments by Member 11757843 (Top 10 by date)