Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Stargazer78
- Order by date
-
Why doesn't EOF work in VBA for Access 97
I didn't save the file before I tried running it again, I no longer get the error, but the button doesn't seem to do anything. It just stays with the current record.<br> <br> Same code as before, but no error pops up. It just doesn't do anything.- Stargazer78
- Post #5
- Forum: Microsoft: Access Other topics
-
Why doesn't EOF work in VBA for Access 97
Private Sub cmdNext_Click()<br> <br> Dim db As Database<br> Dim rst As Recordset<br> <br> Set db = CurrentDb<br> Set rst = db.OpenRecordset("people")<br> <br> If rst.EOF Then<br> rst.MoveFirst<br> Else<br> rst.MoveNext<br> End If<br> <br> End Sub<br> <br> The error I get is...- Stargazer78
- Post #3
- Forum: Microsoft: Access Other topics
-
Why doesn't EOF work in VBA for Access 97
Can anyone help me with some code for Access 97. I have a form that goes through records in a table called "people".<br> For some reason the EOF or BOF won't work like it does in Visual Basic 5. I have a previous button and a next button on my form and for some reason I can't get...- Stargazer78
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
