Programmatically access the reset button in VBE

Thinh

Registered User.
Local time
Today, 01:16
Joined
Dec 20, 2006
Messages
114
Does anyone know how to programmatically access the reset button in VBE.
The reason for this is i have a query that uses a function. the query does what it suppose to do but when run it again the number keep increase instead of starting over. The number also start changes when you resize the windows. What i have found out is if you click the Reset Button in VBE the values will be reset every time. So if i have a stopping criteria in the function that would utilized the reset button in VBE i will be able to get the same values every time i run the query

Thanks in advance
 
Last edited:
Thinh,

What number? What does the function do?

If the function uses the Rnd() function, then you might be referring to
Randomize as the "Reset Button".

Maybe even the REMOVAL of a Randomize statement.

Need more info,
Wayne
 

Users who are viewing this thread

Back
Top Bottom