William Benson
vbacreations at gmail.com
Fri Jan 27 21:07:25 CST 2012
Too much pain medicine today. Not that this is my brand (Valium) but here is a joke. Latin singular : Valium Latin plural when < 3 Valiums Latin plural when >=3. Vyehyeh On Jan 27, 2012 10:03 PM, "William Benson" <vbacreations at gmail.com> wrote: > Skip the part about sticking it I'm a standard module. That of course > would be developers job. Done before they choose the function (like from a > dropdown or a menu) which I would have code that inserts that selected proc > in the table of procs to be run. > On Jan 27, 2012 9:59 PM, "William Benson" <vbacreations at gmail.com> wrote: > >> Yep. >> >> But hopefully you don't advocate the same table driven approach. It was >> purely for fun and you can be sure that a programmer will hate it (they >> would rather read code). >> >> However I found it somewhat Demystifying for the user because I can >> actually show them a list of programs that will run under a filtered set of >> parameters. And also if they want to add a new function they can add the >> procname to the table, stick that in a standard module.... and I will take >> care of the rest. >> On Jan 27, 2012 9:52 PM, "Stuart McLachlan" <stuart at lexacorp.com.pg> >> wrote: >> >>> See my other post. I must have thought of application.run at the same >>> time as you were >>> drafting this. GMTA :-) >>> >>> -- >>> Stuart >>> >>> On 27 Jan 2012 at 21:48, William Benson wrote: >>> >>> > I have sometimes put proc names in a table. Run the code required for a >>> > particular value from a group of records selected from the table. I >>> also >>> > added refernce to vba extensibility to the project so that I could >>> loop vbe >>> > components to verify that " "& procname & ")" could be found in the >>> code >>> > project. >>> > >>> > I was just kinda playing around- no real advantage - but I enjoyed >>> > selecting a list of required procs in a recordset according to some >>> > parameters then looping the recordset to call the needed functions in >>> > required sequence, by name using either evaluate() or application.run >>> -- >>> Stuart McLachlan >>> >>> Ph: +675 340 4392 >>> Mob: +675 7100 2028 >>> Web: http://www.lexacorp.com.pg >>> >>> -- >>> AccessD mailing list >>> AccessD at databaseadvisors.com >>> http://databaseadvisors.com/mailman/listinfo/accessd >>> Website: http://www.databaseadvisors.com >>> >>