run code from outside module

  • Thread starter Thread starter jeanne
  • Start date Start date
J

jeanne

I have several forms, each which have a button that
performs some data updates and calculations in private
sub procedures.

I would like to be able to "batch" run all these
procudures code from a button on another form. Can this
be done?
 
jeanne said:
I have several forms, each which have a button that
performs some data updates and calculations in private
sub procedures.

I would like to be able to "batch" run all these
procudures code from a button on another form. Can this
be done?
Click to expand...

Only if the procedures are changed from Private to Public, and the forms
are open at the time. If these conditions are met, then you can call
each procedure by prefixing it with a reference to the open form
containing it; e.g.,

Call Forms!MyForm1.cmdDoThis_Click
Call Forms!MyForm2.cmdDoThat_Click
' ...

Are these procedures that don't actually require the forms to be open?
If so, you could move the meat of the procedures into a standard module
and just call them from the command buttons on the forms, and also call
them from this other "batch" form without needing the original forms to
be open.
 
I would move each routine to a standard module. Then have
the form call the module in question.


Your batch button would call them in sequence.


Chris Nebinger
 
Thank you! That did it.
-----Original Message-----


Only if the procedures are changed from Private to Public, and the forms
are open at the time. If these conditions are met, then you can call
each procedure by prefixing it with a reference to the open form
containing it; e.g.,

Call Forms!MyForm1.cmdDoThis_Click
Call Forms!MyForm2.cmdDoThat_Click
' ...

Are these procedures that don't actually require the forms to be open?
If so, you could move the meat of the procedures into a standard module
and just call them from the command buttons on the forms, and also call
them from this other "batch" form without needing the original forms to
be open.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)


.
Click to expand...
 
Back
Top