Recent content by mlupini
-
M
Question evaluate a string to make an expression
SELECT Slots.RackName, Slots.SlotID, Slots.PartID, _ Parts.BaseI, _ IIf([Slots].[PartID]=25, _ [RackName] & ':I', _ [RackName] & ':' & [SlotID] & ':I') _ AS BaseITag FROM Parts _ INNER JOIN Slots _ ON... -
M
Question evaluate a string to make an expression
I want to enter calculated field formulas in a table then use the result in a query. I've done a lot of searches and it appears you cannot do this. -
M
Question evaluate a string to make an expression
This returns the correct value Debug.Print [myTable]![myField] Why does this result in an error? Debug.Print Eval("[myTable]![myField]")