Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access timer event

Posted on 2011-03-09
4
Medium Priority
?
343 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 1000 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 58
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 1000 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

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

916 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