use vba to create new code module in access 2007

[scott w t]

i can't remember how to create a new standard or class code module using vba.
i did it a long time ago, so i know it's possible. can anyone help?

 

[Alex Dybenko]

Hi,
you can use:

DoCmd.RunCommand acCmdNewObjectModule

or

Application.VBE.VBProjects(1).VBComponents.Add vbext_ct_StdModule

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[scott w t]

thanks. that's what i was looking for.

Hi,
you can use:

DoCmd.RunCommand acCmdNewObjectModule

or

Application.VBE.VBProjects(1).VBComponents.Add vbext_ct_StdModule

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com