Timer event

[jonwentz]

Hi all,

I know i posted this in another thread but i think it goes here

I am wondering if there is a way to save a record in this manner.

When the user opens the form wait 1 second and then save.

But I would like it to do this only once. I have tried the “on timer” but it keeps saving the record every second.

Thanks in advance
Jon

 

[selenau837]

Hi all,

I know i posted this in another thread but i think it goes here

I am wondering if there is a way to save a record in this manner.

When the user opens the form wait 1 second and then save.

But I would like it to do this only once. I have tried the “on timer” but it keeps saving the record every second.

Thanks in advance
Jon

I'm not sure if there is another way, but here is a work around.

Perhaps place an invisiable check box labled save. Once the form has saved the first time, make that box true. Every second it will try and save, however do an if statment to check to see if that box is true. If it is, do nothing.

*shrugs* Just an idea.

 

[selenau837]

Never mind, I see Rural Guy answered it in the other one. Told you there was a way to do it.

 

[jonwentz]

But i didnt get an answer

he said to set it to 0

 

[selenau837]

But i didnt get an answer

he said to set it to 0

He's good, give him time he will come back to you.

Also, do a F1 in access to get a help file to see how to set the timer event back to zero.