Evaluating expression stored in string variable

[alang777]

How can Access/VBA evaluate a variable containing an expression string as an expression rather than as a string?

E.g.,

varExpr = "1 + 1"

How do I evaluate the contents of varExpr to get 2 instead of "1 + 1"?

Dlookup() requires a domain, and Access has no equivalent of Excel's Indirect()... Also, I've tried ByVal versus ByRef but it doesn't help. I need something like RunExpression(strExpr) if it exists!!

The bigger context is constructing SQL strings with "parameter" variables or tokens where the parameter tokens are replaced by the value of my own functions such as CurrentFiscalMonth() (e.g, "200709") or ThisMonday() (e.g., #9/17/2007#).

Thanks in advance for any hints

 

[PHV]

Have a look at Eval

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MajP]

http://msdn2.microsoft.com/en-us/library/aa172212(office.11).aspx

 

[alang777]

That's it!!

I've needed Eval() before but never knew the trick!

Thanks MajP! A blessing upon you and your family!