Is there a way to auto quit a database (Acc2000) after a predetermined
period of inactivity? In other words if a user does not use the database
for, say, 5 minutes could this be recognised and auto quit the application.
Thanks in anticipation.
Chris
3  17053 
Here is a KB article on how to detect user inactivity. http://support.microsoft.com/default...b;en-us;210297
You then must decide how you want to handle a dirty record that the user
didn't finish entering. My recommendation is to issue an Undo to each open
form that is dirty before closing the database. Make sure the users are
aware that you are going to do this. I would also popup a form with a
countdown timer on it to give the user a chance to abort the shutdown.
--
Wayne Morgan
MS Access MVP
"Chris Youlden" <li***@spam3you lden.org> wrote in message
news:dd******** **@nwrdmz03.dmz .ncs.ea.ibs-infra.bt.com... Is there a way to auto quit a database (Acc2000) after a predetermined
period of inactivity? In other words if a user does not use the database
for, say, 5 minutes could this be recognised and auto quit the
application.
Thanks in anticipation.
Chris
Wayne Morgan wrote: Here is a KB article on how to detect user inactivity.
http://support.microsoft.com/default...b;en-us;210297
You then must decide how you want to handle a dirty record that the user
didn't finish entering. My recommendation is to issue an Undo to each open
form that is dirty before closing the database. Make sure the users are
aware that you are going to do this. I would also popup a form with a
countdown timer on it to give the user a chance to abort the shutdown.
Excellent, thanks. Just what I need.
Chris
Chris Youlden wrote: Wayne Morgan wrote:
Here is a KB article on how to detect user inactivity.
http://support.microsoft.com/default...b;en-us;210297
You then must decide how you want to handle a dirty record that the
user didn't finish entering. My recommendation is to issue an Undo to
each open form that is dirty before closing the database. Make sure
the users are aware that you are going to do this. I would also popup
a form with a countdown timer on it to give the user a chance to abort
the shutdown.
Excellent, thanks. Just what I need.
Chris
Also, if there is an active control, check the .text property otherwise
users would get logged out while editing a memo field!!! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bart Nessux |
last post by:
Hello,
Auditors want us to log out a user if the computer they are logged onto
has been unused/inactive for a set period of time. It's trivial to
logout the user, but we're having trouble telling if the system is
indeed inactive. If we could learn that information, then we'd need to
measure how long it has been like this so we can all the logout
function. How might this determination and measurement be approached?
We're using Python...
|
by: Prometheus Research |
last post by:
http://newyork.craigslist.org/eng/34043771.html
We need a JavaScript component which will auto-submit a form after a
set period has elapsed. The component must display a counter that
dynamically shows the minutes and seconds remaining before submission.
We have a fairly tight deadline (by 5PM EST, Friday, June 25); we are
using a "bounty" in the hope of getting a few good responses in a
hurry.
BOUNTY: $200 for first place, plus a $50...
|
by: Corepaul |
last post by:
I am new to Access 2000. My operating system is Windows 2000.
In the early stage of development I noticed something weird. On my form, I have
a Command Button named "btnAlbumUp". The first time that I reference this
button in VBA code, the Visual Basic Editor capitalizes the P changing
btnAlbumUp.SetFocus
to
|
by: Mr. Smith |
last post by:
Hello all,
My code can successfully open, write to, format and save several
worksheets in a workbook then save it by a given name, close and quit excel.
My problem is that if I try and do it again, Excel hangs. OR if I open
Excel again (say from a desktop icon) before I close Access, Excel
hangs. (this has happened for both 97 & 2000 for me)
I of course thought that I mustn't be unloading a variable properly.
|
by: PawelR |
last post by:
Hello Group,
To my apps user must logon.
How make auto logoff after any time when user is not active?
Please send me samples or link to samples.
Thx.
Pawel
| | |
by: Phil Latio |
last post by:
I have 2 virtually identical tables and wish to move data between them.
Basically one table is called "live_table" and the other is named
"suspended_table" and the only difference is that the primary key in the
"suspended_table" is an auto incremented integer where as "live_table"
primary key is just a standard integer.
Here's the life-cycle:
1. Record gets entered into "suspended_table"
2. Record checked and then inserted into...
|
by: Liam.M |
last post by:
Hey guys,
Forgive me if my question my be alittle silly, but I would very much
appreciate and assistance that could be given!
My situation is as follows:
I have created a Button, and set it's "On Click" Event proceedure to
Loop through my Database and find any records that fall within a
Certain Date...if a record is found...it then emails me that a record
|
by: john |
last post by:
Is it true that if I split my access database in backend and frontend and I
implement custom auto increment for the ID fields, that my database is ready
to be used in a multi-user environment? I found a zillion messages about
auto increment and read some of them but it's confusing. Can someone point
me to a simple custom auto increment example that I can download?
Thank you,
john
|
by: WEG |
last post by:
Larry Linson you're correct. I was using the wrong terminology. I meant
that the field in my form would search one table, then another, until it was
found.
In my particular situation, I deal with employee ID numbers. I have one
table that includes active employees and another that has inactive
employees. Right now I open up two different forms to perform two different
searches. I'd like one form that would search both tables.
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
