LarryE
Active member
- Local time
- Today, 01:17
- Joined
- Aug 18, 2021
- Messages
- 562
You come in here and tell us you have an error out problem. You give us partial code and just assume we know things we can't possibly know and call one of us "cowboy". Not a good start. People come into this forum with every level of experience you can imagine. We can't possibly know what level of experience everyone has. That's the reason we ask for ALL the code to begin with. OK?
When you open the recordset try moving to the last record and then the first record BEFORE the Do Until rs.EOF statement. So:
That gives ACCESS the recordset number apparently. I heard you needed to do this many years ago. I don't know if that's the problem, but you can try it.
When you open the recordset try moving to the last record and then the first record BEFORE the Do Until rs.EOF statement. So:
Code:
rs.MoveLast
rs.MoveFirst
Do Until rs.EOF
That gives ACCESS the recordset number apparently. I heard you needed to do this many years ago. I don't know if that's the problem, but you can try it.
Last edited: