Sdmarshall73
Programmer
I'm developing a database with intermediate VB programming skills. A table is used to store expressions in one field using custom identifiers. These expressions are read by some code I have in a module that will replace these identifiers with values from a form and run the expressions using the eval() function. These expressions will be input or edited in these fields via a form.
It is important to construct these 'expressions' correctly with the proper identifiers so they can be identified by the code and run correctly. The ideal way to do that would be to launch the expression builder from the form and construct these expressions with these custom defined identifiers but I have not figured out a way to launch the builder from form view. I use the code DoCmd.RunCommand acCmdInvokeBuilder but I'm getting a 'Command isn't available now' error and there's nothing I tried that makes it available.
I've also tried adding the QueryBuilder menu item to a custom ribbon and menu and setting the property to visible or enable without success.
Is this any at all possible? What's a workaround? How do I simulate the environment in which the builder is available?
Thanks for any help.
It is important to construct these 'expressions' correctly with the proper identifiers so they can be identified by the code and run correctly. The ideal way to do that would be to launch the expression builder from the form and construct these expressions with these custom defined identifiers but I have not figured out a way to launch the builder from form view. I use the code DoCmd.RunCommand acCmdInvokeBuilder but I'm getting a 'Command isn't available now' error and there's nothing I tried that makes it available.
I've also tried adding the QueryBuilder menu item to a custom ribbon and menu and setting the property to visible or enable without success.
Is this any at all possible? What's a workaround? How do I simulate the environment in which the builder is available?
Thanks for any help.
