Hey Accessers!
Why can't we access in Access one of our most needed ingredients - the variables? I urgently need something like Eval("NameOfVariable") describing the name of a variable. Is there any way?
I've been looking a lot, because things like Recordset.Properties("NameOfProperty") works, Eval("NameOfFunction") works, but is Access able to access its own recordsets and its functions, but hides its variables?
Please give me a hint!
Example:
Sub test()
Dim a(100) As Long
' this works (function):
MsgBox Eval("Func1()")
' any way, something like this works??:
a(0) = 27
MsgBox Eval("a(0)")
End Sub
Function Func1() As Long
Func1 = 27
End Function
Why can't we access in Access one of our most needed ingredients - the variables? I urgently need something like Eval("NameOfVariable") describing the name of a variable. Is there any way?
I've been looking a lot, because things like Recordset.Properties("NameOfProperty") works, Eval("NameOfFunction") works, but is Access able to access its own recordsets and its functions, but hides its variables?
Please give me a hint!
Example:
Sub test()
Dim a(100) As Long
' this works (function):
MsgBox Eval("Func1()")
' any way, something like this works??:
a(0) = 27
MsgBox Eval("a(0)")
End Sub
Function Func1() As Long
Func1 = 27
End Function
