Can database timeout delete an autonum?

[ImJay]

I need to set a database timeout on a form if keys are idle for 10 minutes, and remove all fields in the current entry if it is incomplete, including the AUTONUM. Entry would be incomplete if SAVE button was not activated. I made it an autonum because it is the index key that connects the tables combined by query in this form.

SAVE button is designed to send an Email notification to the Coordinator that an activity has been entered that would require scope change if approved.

Thanks,
Imjay

 

[johnwm]

Welcome to Tek-Tips - please review faq222-2244 to see how to get the best from the forum.

For this question just set Form KeyPreview to True and reset your timer in the Form KeyUp event - if the timer runs out then delete the record

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'If we're supposed to work in Hex, why have we only got A fingers?'
Essex Steam UK for steam enthusiasts

 

[fredericofonseca]

But remember that if it is a autonum and someone else has created a new record then the autonum sequence will not be reset or reused.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[chiph]

You probably shouldn't be relying on autonum values anyway -- they're database keys, and shouldn't have any meaning to the user.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[ImJay]

Thanks, folks. I will put your advice to work for me. I agree that the use of autonum as the index key is problematic; however, the only other appropriate field may or may not be populated well into the process. The logical field to combine the tables is the work order number (WO.) At the outset though, I may only have a PMRQ number (preventive maintenance required) or a WR (work request number.) WO numbers are assigned during the planning process -- after they have been entered, projected change in scope has been calculated and they have been approved by all affected departments.

If anyone can provide a more effective method than the automatic tracking number, please share.

Imjay