How to use Timer to Save Record in Edit Mode

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Hi there! Using A02 on XP. Have been looking into the
Timer event. Found Idle Activity, Inactive Shutdown
something or other and think this could be what I need.

I have a problem with folks adding a record and walking
away with it still in edit mode (pencil) and meanwhile
someone else adds a record from their desk and tries to
close and BAM, can't save, record currently locked. Don't
want to close the DB, just save the record or maybe close
the form after a few minutes of inactivity. I could use
both for different situations. What direction do you think
would be best to take to accomplish this?

Would really appreciate any advice or help on this. Thanks
in advance for your time!
 
Had to add...I'm using the Microsoft Knowledge Base
Article and just want to alter one thing...Rather than
quit the application, I want to save any records currently
in edit mode on a specific form. Just need the magic
bullet to put in when IdleTimeDetected. Thanks!

http://support.microsoft.com/kb/q128814/
 
Instead of DoCmd.Quit (or whatever that part of the code says), I believe
you just need to put something like:
If Me.Dirty=True Then
Me.Dirty=False
End If
And it should save the record for you.
 
Thanks Mark! Wasn't sure what to use to make sure I only
catch a record 'in edit mode'. That does it! THX!
 
Back
Top