Module Frank Situmorang 12/5/2008 7:51:02 AM Hello, I am relatively new to do access, I started it as my hobby. VBA is triggerred to act by event procedure, my question is how about the module, what and when it starts to act. If someone put the name of the module as he wants says: Public Sub LanguageControls(), how does it work. Thanks in advance for enlightening me. -- H. Frank Situmorang

Re: Module "Allen Browne" <AllenBrowne[ at ]SeeSig.Invalid> 12/5/2008 8:15:49 AM Frank, you can run a procedure (Sub or Function), not a module. Any executable code in a module must be in a procedure. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Frank Situmorang" <hfsitumo2001[ at ]yahoo.com> wrote in message news:BB01E706-81A4-4999-B724-D1AC42BE519D[ at ]microsoft.com... [Quoted Text] > Hello, > > I am relatively new to do access, I started it as my hobby. VBA is > triggerred to act by event procedure, my question is how about the module, > what and when it starts to act. If someone put the name of the module as > he > wants says: Public Sub LanguageControls(), how does it work. > > Thanks in advance for enlightening me. > -- > H. Frank Situmorang

Re: Module Frank Situmorang 12/5/2008 9:34:11 AM Thanks Allen, I understand now, I have seen it that module is called from the form control forms and maybe reports. -- H. Frank Situmorang "Allen Browne" wrote: [Quoted Text] > Frank, you can run a procedure (Sub or Function), not a module. > > Any executable code in a module must be in a procedure. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. > > "Frank Situmorang" <hfsitumo2001[ at ]yahoo.com> wrote in message > news:BB01E706-81A4-4999-B724-D1AC42BE519D[ at ]microsoft.com... > > Hello, > > > > I am relatively new to do access, I started it as my hobby. VBA is > > triggerred to act by event procedure, my question is how about the module, > > what and when it starts to act. If someone put the name of the module as > > he > > wants says: Public Sub LanguageControls(), how does it work. > > > > Thanks in advance for enlightening me. > > -- > > H. Frank Situmorang > >