G
Guest
I have code which uses Randomize and the rnd() function. Sometimes this code
gets an error based on some other command in the code which is fine. I do an
error catch on this error. The problem is after the randomize and rnd() are
executed then the rest of the code runs and an error occurs. My msgbox pops
up stating the error, but what also happens is the database locks up. When I
remove the Randomize and rnd() function from the code, the database doesn't
lock up. So my question is how can I get around this with using Randomize
and not having the database lock up?
If anyone can make sense of what I'm asking, I would appreciate some help.
Thank you,
Sarah
gets an error based on some other command in the code which is fine. I do an
error catch on this error. The problem is after the randomize and rnd() are
executed then the rest of the code runs and an error occurs. My msgbox pops
up stating the error, but what also happens is the database locks up. When I
remove the Randomize and rnd() function from the code, the database doesn't
lock up. So my question is how can I get around this with using Randomize
and not having the database lock up?
If anyone can make sense of what I'm asking, I would appreciate some help.
Thank you,
Sarah