TempVars

  • Thread starter SurveyorinVA via AccessMonster.com
  • Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TempVars 3
Macro help 0
Seaching an excel sheet 1
Change a report to a query 1
Variable question 2
HELP NEEDED WITH REPORT 1
Using InStr on form control 4
Blank Report 2

Top