On Dec 1, 5:45*pm, "JLGWhiz" wrote:
As best I can tell, different folks worked on different applications and
each individual tailored the VBA software to their specific application.
You could just as easily wonder why they change the code from release to
release in Excel VBA. *Software engineers seem to have this feeling of
ownership about their work assignments and they don't like to give someone
else credit for any of their work, so they try to make everything look like
it is better by making it different. *But the real answer is probably that
they were too lazy to research to see if a procedure already existed for

I think I figured it out. Evidently Access VBA already contains
Recordset and Connection objects that are different from ActiveX Data
Objects. When I changed the declaration from Dim rst as Recordset to
Dim rst as ADODB.Recordset, the syntax changed to what I expected it
to be. So in other words there are 2 completely different
Recordset,etc objects.