keep getting the error message "The search key was not found in any record" after re working the VBA code when I run the Access 2003 database. Usually compacting and repairing makes it go away, but that is not working now. Any ideas?
when I run the VDB program...I'm sure its my fault...I found a
myRecordsetR.MoveNext
Wend
myRecordsetR.Close
Set myRecordsetR = Nothing
Set myConnectionR = Nothing
statement missing on something I was working on last night and that has solved the problem...but message still pops up when running other routines...fortunately the compact and repair statement usually fixes it although the routine is interrupted and must be run again....probably upsetting my tables.
WEND is the WHILE loop terminator - you are not showing us anything of use; there MUST be a WHILE statement above what you are pasting here (which will contain code that is doing something, but we cannot see it).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.