Hollis,Virginia
HollisVJ at pgdp.usec.com
Fri Jun 11 06:19:07 CDT 2004
I have been using the below code to count the number of hits on a form. I
installed A2003 yesterday & receive an error on RS.Edit. In A2K I added a
reference to DAO 3.6 & the code would work. But in 2003 this is not listed
in the references.
What can I change the code to so it will work correctly?
Virginia
********************
Public Function CountThisForm(frm As Form) As Boolean
Dim db As Database
Dim RS As Recordset
Dim SQL As String
Set db = CurrentDb
SQL = "Select * FROM tblCounter Where FormName = """ & frm.Name & """;"
Set RS = db.OpenRecordset(SQL, dbOpenDynaset)
If RS.RecordCount > 0 Then
RS.Edit
RS!HitCount = RS!HitCount + 1
RS.Update
Else
RS.AddNew
RS!FormName = frm.Name
RS!HitCount = 1
End If
RS.Close
Set RS = Nothing
End Function