Running VBA code stored in a table.

[Boreas]

Anyone got any suggestions for running VBA code from a table ??

 

[namliam]

Pfff ... why would you want to run VBA from a table?

Anyway, you could write code that creates a module and writes the code from the table to the module.
Then execute the function/sub contained within...

But Why ?

BR

 

[Boreas]

Thank you for your response.

I am trying to create an Access program that collects code examples.

That is to say, multiple users can enter code examples into one Access database. Then other users can query the Access tool for examples to help solve problems they are working on.

I would like the users of the program to also see an example of how the code runs. That is to say, they can query code, then hit a button to run an example of what the code does.

The only way I can figure doing this is to store the code in a table and run it from there. I followed your suggestion and got it to work. The problem I am having now, is that when other people have the Access tool open on another computer, it locks everyone into the tool when you run the code from the table. Any suggestions?

 

[namliam]

Run the code in a new DB...

But for a lot of code you need tables and or fields and stuff....

If ppl are coding them selves can they not copy paste the code themselves into a new db and test it there?

BR