Solved

Access timer event

Posted on 2011-03-09
4
317 Views
Last Modified: 2012-05-11
Looking for some guidance in the right direction.

I have a form that runs through a three step process:

1) scan user badge
2) scan asset tag
3) confirm or reject with a message

Once step 3 is fired.  I want the user to be able to continue scanning more assets (they are all ready loaded in the system) with no delay.

The issue is if they walk away I want to be able to automatically reset the scanner after N seconds.

So I can start a timer on step 3 for the clear screen procedure but if they scan in the textbox I need to kill the timer.  This is where I am struggling.

Hope that is clear.

Thanks for the help
0
Comment
Question by:skillilea
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 35087302
you can apply the concept discuss here

How to detect User Idle Time or Inactivity in Access
http://support.microsoft.com/?kbid=210297
0
 
LVL 57
ID: 35087335
<<I need to kill the timer.  >>

  Not sure I follow, but a form timer can be killed by setting the interval to 0.

JimD.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 35087359
"but if they scan in the textbox I need to kill the timer"

You can control the Timer Interval in code by using

    Me.TimerInterval = 0  '  stop the Timer ...
or some non-zero value to start the timer.

mx
0
 

Author Closing Comment

by:skillilea
ID: 35124194
Thanks experts!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question