code stored in table

[SunWuKung]

Is it possible to store multiple statements or whole subs in a record and later execute the stored code from the application?

 

[dcx693]

You could probably store some of the code within your tables and reference that info from a module. Assuming you could do this through some VBA gymnastics, why would you want to?

 

[raskew]

Take a look at this article on the Access Web: http://www.mvps.org/access/queries/qry0014.htm

 

[llkhoutx]

Raskew - Thanks for the article.

 

[SunWuKung]

Thanks Raskew, that was a very useful link.

dcx693 - I need to create wizards and a wizard creator in my application that would guide the user through the steps the user needs to carry out certain functionalities.
OK. I made sure from the beginning that I have my functionalities in separate forms so I can create a table with a sequence of forms. Than I can have a wizard go through the records and open the forms one after the other, but in some cases I might need to do conditional things between the opening of two forms which are dependent on the wizard that opens those forms. I thought that it would be good if you could see what the wizard was doing just by looking at the table that stored the steps. So I thought of a table like:

OpenForm FormName1
OpenForm FormName2
OpenForm FormName3
DoCode "Sub ............... End Sub"
OpenForm FormName4

I guess it would be simpler to store only the name of the sub. But I thought that storing the actual procedure there would make it better organised and documented.

 

[dcx693]

I've created wizard-like forms for users also, but I've almost always used the tab-based form approach. Usually, the tabs in the form follow a logical progression. Everything is nicely compartmentalized all the logic and the objects are stored together.

Why do you want your functionality spread across different forms?

 

[SunWuKung]

My project is about prototyping an internet application so I need to keep the interface very light and separate the functionalities of the application as much as possibble.

I think having the functionalities on different form could have an advantage even with the wizards as ideally it would make it possible for administrative level users to build wizards from within the application and not just use the ones built by IT.