Solved

Access timer event

Posted on 2011-03-09
4
325 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

735 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