Using SQL to retrieve a formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pruetta - 24 Aug 2005 15:46 GMT

I am wondering if there is a way in VBA to extract and use a formula that is
stored in an access table. I have tried and the formula comes in as a string
and it will not work properly. Is there a specific command in VBA that will
allow you to SQL the formula and have it work properly inside of you code?

Thanks,

Signature

pruetta

Reply to this Message

Klatuu - 24 Aug 2005 16:07 GMT

The EVAL function will do that.
strFormula = "((5 * 3)/3) + 100"
Foo = Eval(strFormula)

> I am wondering if there is a way in VBA to extract and use a formula that is
> stored in an access table. I have tried and the formula comes in as a string
> and it will not work properly. Is there a specific command in VBA that will
> allow you to SQL the formula and have it work properly inside of you code?
>
> Thanks,

Reply to this Message

pruetta - 24 Aug 2005 17:11 GMT

Klatuu,

Thanks. I should have given an example with the formula I am wanting to
retrieve from Access.

Ex. "A + B - 180"

Where A & B are variable that have been set earlier in the code.

Thanks,

pruetta

Signature

pruetta

> The EVAL function will do that.
> strFormula = "((5 * 3)/3) + 100"
[quoted text clipped - 6 lines]
> >
> > Thanks,

Reply to this Message

Klatuu - 24 Aug 2005 17:25 GMT

You can reference control values in a form or report, but not variables, sorry.

> Klatuu,
>
[quoted text clipped - 19 lines]
> > >
> > > Thanks,

Reply to this Message