Embedded/nested? Variable

[tomro1]

Embedded/nested? Variable [Solved]

Hi All,

Is there some sort of internal variable or table that can be used to store temporary variables?

While running code you can obviously store data in variable, but once the code is done, the variable are dumped.

So I want to store some variable at some place in the vba or access that I can afterwards collect that variable again when I rerun my code.

Only way I know is to add it into a table, but is there some other, easier way?

 

[Addyman]

You might want to check out the TempVars object:

http://msdn.microsoft.com/en-us/library/bb257083(v=office.12)

It can be used like a variable but will hold it's value until you either delete it or close Access.

MS Access 2007 or above only I believe.

Very handy thing!!

 

[gemma-the-husky]

registry is really useful for some things since it survives a re-release of the front end

savesetting ... inserts into the registry
getsetting .... retrieves.

foolproof

 

[tomro1]

This is pretyy much the perfect solution that i needed.

Thanks alot Andyman!

The registry function is also very usefull, but in my case i do not have write permission on the registry.
But indeed a good thing to remember for the future!

Case closed I guess!