Sorry I didn't have time to read all this code (or try it out) but something is obvious from the first few lines:
If your working with DAO you should dim/instantiate the recordset objects as DAO.Recordset as well otherwise Access can and does assumes ADO and your code will fail for a reason...
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.