2nd Post: Add-In Help

[Alastair MacFarlane]

Dear All,

I am creating an Access Add-in that would be preferrably
used in any version of Access, but most of my use for it
would be with Access 97/2000. I am capable of creating a
module with the code below:

DoCmd.RunCommand acCmdNewObjectModule

but how would you determine that the user of the add-in
already had a module open and add the code at the end of
the previous routines (using the module method
InsertLines) rather than, as the line above does, create a
new module?

Nice easy one?

Thanks again...

Alastair MacFarlane

 

[Peter De Baets]

Check application.modules.count for a value greater than 0.

Hope this helps,

Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com