Solved

Access timer event

Posted on 2011-03-09
4
332 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 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 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

635 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