S
SurveyorinVA via AccessMonster.com
I still am not sure if I am doing this correctly. If I wanted to use this
TempVars.Add(Name,Value)
If I am correct the Name is going to be a String variable that can be called
from any VBA code, query, etc... until I Remove it with the TempVars.
RemoveAll.
So for example, if I want to use the variable MyText, and load the
string data from myWorld into it, I would declare myWorld as a String and
myText as a String, or would I only declare myWorld?
Dim myWorld as String
Dim myText
TempVars.Add(myText,myWorld)
or
Dim myWorld as String
TempVars.Add("myText",myWorld) or
once I declare it, I would call upon it from anywhere (until cleared) by
using:
TempVar![myText]
When I do this, I get an error saying TempVar![myText] = <object required>.
Any further information you have would be greatly appreciated.
Thank you again for the information,
CF
TempVars.Add(Name,Value)
If I am correct the Name is going to be a String variable that can be called
from any VBA code, query, etc... until I Remove it with the TempVars.
RemoveAll.
So for example, if I want to use the variable MyText, and load the
string data from myWorld into it, I would declare myWorld as a String and
myText as a String, or would I only declare myWorld?
Dim myWorld as String
Dim myText
TempVars.Add(myText,myWorld)
or
Dim myWorld as String
TempVars.Add("myText",myWorld) or
once I declare it, I would call upon it from anywhere (until cleared) by
using:
TempVar![myText]
When I do this, I get an error saying TempVar![myText] = <object required>.
Any further information you have would be greatly appreciated.
Thank you again for the information,
CF