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
since A2007 there was a change in the library name because the JET database engine was removed, the new one is called ACE and the library (which is normally by default already loaded) is "Microsoft
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses.
Navigate to the “Start Mail Merge” button in the Mailings tab:
Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels.
Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…