G Guest Sep 4, 2007 #1 Is it possible to create a function to compile all VBA, all modules? I remember in access 97 it was possible. Thanks
Is it possible to create a function to compile all VBA, all modules? I remember in access 97 it was possible. Thanks
J John W. Vinson Sep 4, 2007 #2 Is it possible to create a function to compile all VBA, all modules? Click to expand... In Access 2000 and later, the entire VBA Project is compiled when you compile anything. It's all one unitary thing. I'll routinely add the "Compile Project" button to the VBA editor toolbar, just to avoid having to use Debug... Compile from the menu. John W. Vinson [MVP]
Is it possible to create a function to compile all VBA, all modules? Click to expand... In Access 2000 and later, the entire VBA Project is compiled when you compile anything. It's all one unitary thing. I'll routinely add the "Compile Project" button to the VBA editor toolbar, just to avoid having to use Debug... Compile from the menu. John W. Vinson [MVP]
S Stuart McCall Sep 4, 2007 #3 JCP said: Is it possible to create a function to compile all VBA, all modules? I remember in access 97 it was possible. Click to expand... DoCmd.RunCommand acCmdCompileAllModules ought to do it.
JCP said: Is it possible to create a function to compile all VBA, all modules? I remember in access 97 it was possible. Click to expand... DoCmd.RunCommand acCmdCompileAllModules ought to do it.
