tempvar issue

[Jen0dorf]

Hi



In my database I use temporary variables and they work perfectly - I use them to set up search criteria via a form text box

However had an issue reported by a user, so I went to my test pc and installed Access 2013 runtime and loaded my database.

When I use the database the tempVar is setup perfectly and results are displayed as I expected.

I have a button on the results form to "search Again" the button does the following

1. Closes the results form
2. Deletes the tempvar
3. Loads the search form

On my development machine it all works perfectly no problems at all BUT when I run the database on my test machine with a runtime version when I close the form I get the error message:

The Command or action removeTempVar is not available . You may be in a readonly or an unconverted earlierversion of ... or The type of action the object refers to is not in the current view...

I am at as loss as to why I only get this with the runtime version.

Do I need to remove a tempvar prior to creating a new variable with the same name? I did it to be tidy

Or does this show another issue

thanks

Ian

[davegri]

Here's a workaround. In step 2, set the value of the tempvars!whatever = vbnullstring

In all other code, before using the tempvar, first check if len(tempvars!whatever & vbnullstring) = 0 then ( do nothing, exit sub, else whatever )

You do not need to remove tempvars to assign a different value. In fact you never really need to originally ADD the tempvar.

[Jen0dorf]

Hi

thanks for the info.

cheers

Ian