Variables ?

[Mish_h]

Hi can anyone tell me if there is a way to store something in a variable for a particular amount of time or until an event occurs.

e.g. how would i store a value a user inputs into a textbox for say 5 minutes and then after 5 minutes the variable will become empty again ?

Thanks

 

[RuralGuy]

Maybe it would be helpful to explain *why* you need to do that.

 

[BrokenBiker]

I don't know exactly what you've got going on, but...

I needed something similar in our db. What I did was created a 'temp' table where info was sent. The next time the function was run, that table was emptied and then appended w/ the new info.

Hope that helps...

 

[Mish_h]

Variables

Well what id like to do.. (probably not the correct way)

I have a custom password form that allows access to three different forms. However if a user comes out of one form and wants to access another then they are prompted for the password again.

I would like to store the password if correct into a variable and when a form is accessed, if the variable has the password in it then the user goes straight through to the form. if the variable is empty then they are prompted for a password.

This is where i would like the variable to hold the value for only a certain amount of time e.g 5 mins. Then the user is prompted for a password again whether or not they got the password correct.

Thanks

 

[RuralGuy]

I would think that once a user has provided their credentials that you remember that until they log out.

 

[BrokenBiker]

Is your log-on form unbound? If it's tied to a table, for instance, you should be able to look back to the latest entry for the proper password. If you don't want to go through the trouble of looking for the latest entry, have the form created in such a manner that the user can't navigate through the records. Open the form to Edit and then just type over the pre-existing entry. You can hide the entry with asterisks ( or whatever) in either the table or the form so that the passwords are still 'secret'.

Does this make sense? If not, I'll explain it again later.