Thank you all for your reply.
I am beginner in access VBA, as for the cursor type I have declared recordset as following
Dim precn As ADODB.Connectio n
Set precn = CurrentProject. Connection
Dim prers As New ADODB.Recordset
prers.ActiveCon nection = precn
prers.CursorTyp e = adOpenDynamic
prers.LockType = adLockOptimisti c
-Actually It is simple credit based sales and purchase system;...
naeem ayub
Last Activity: Oct 12 '10, 03:14 PM
Joined: Aug 15 '10
Location:
-
naeem ayub started a topic Movefirst not working nested loops,, movefirst is not working so that loop can restarin AccessMovefirst not working nested loops,, movefirst is not working so that loop can restar
...Code:Do While Not rss.EOF Do While Not prers.EOF If rss.Fields(0).Value = prers.Fields(1).Value Then ///match found some action.............. If Not rss.EOF Then rss.MoveNext prers.MoveFirst Else If Not prers.EOF Then prers.MoveNext /match not found, reched with against another prers value End If Loop prers.MoveFirst
No activity results to display
Leave a comment: