[AccessD] Set references via automation

Mark Simms marksimms at verizon.net
Sun Jan 1 12:34:53 CST 2012


Interestingly Charlotte I had to use the VBE.VBPROJECT object in Excel to
set references.
Excel 2010's VBE is exhibiting the same p-code corruption behavior as Access
2010.
So I had to create my own "eatbloat"....export all of the modules and forms,
delete em, recompile, close, open again, import all of the VBA source,
re-establish 12 references, recompile.


> To make it work in a 2002/2003 version, you had to reference the VBE
> library and use its methods because you can't use DAO or ADO and VBA to...




More information about the AccessD mailing list