Skip Sleeper
asked on
Access 2010 64 bit Compile Error on DAO recordset, can't load DAO 3.6 library
Hi Experts,
Rey Obrero kindly gave me a loop that works perfectly on two computers in the sample database we shared. When I copy the code to the same form on the original database I get a compile error "user defined type not defined" at Dim rs AS DAO recordset. My research indicates that I'm missing the MS DAO 3.6 Object Library but I can't load it. I've tried the Mr. Fix It tool from MS without joy. Don't have a lot of enthusiasm for manually working with the registry but could if needed with good instructions. In the References list there are no missing items and VBA, Access 14.0 and VBA Extensibility objects are checked. I've included the sample database and the original for comparison. Any assistance would be greatly appreciated. Thanks!
Sample-Database-Loop-Solution.accdb
Menus.accdb
Rey Obrero kindly gave me a loop that works perfectly on two computers in the sample database we shared. When I copy the code to the same form on the original database I get a compile error "user defined type not defined" at Dim rs AS DAO recordset. My research indicates that I'm missing the MS DAO 3.6 Object Library but I can't load it. I've tried the Mr. Fix It tool from MS without joy. Don't have a lot of enthusiasm for manually working with the registry but could if needed with good instructions. In the References list there are no missing items and VBA, Access 14.0 and VBA Extensibility objects are checked. I've included the sample database and the original for comparison. Any assistance would be greatly appreciated. Thanks!
Sample-Database-Loop-Solution.accdb
Menus.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks for the solution and the advice on the field--much appreciated!
Thanks for the solution and the advice on the field--much appreciated!
Thanks, you're welcome.
Sincerely,
Ed