A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

HELP WITH LITTLE PROBLEM



 
 
Thread Tools Display Modes
  #1  
Old August 25th, 2004, 06:24 AM
dk
external usenet poster
 
Posts: n/a
Default HELP WITH LITTLE PROBLEM

Hello everybody !
I need little help from You.
I have procedure to record log in and log out time. Everything goes fine
when user press custom button "close database".
The problem is that many users usualy use "x" button from windows to quit
application.
Is there any possibility to put some code ( call function XXX) on access
application quit or disable windows "x" button.
I find on newsgroups function "disable control box x" made by Calvin Smith,
but it works for forms, not for complete application.

Thank You for Your suggestions !




  #2  
Old August 25th, 2004, 08:34 AM
Nikos Yannacopoulos
external usenet poster
 
Posts: n/a
Default

You could take an alternative approach, i.e. leave the x button but make
sure the logoff code fires before the database is closed even if the user
closes it from the x button of the database window or the application
itself. The trick is to use the On Close event of a form that is open at all
times. If you have a switchboard, then you can use its On Close event. If
not, then you can simply create a dummy form that opens on database open and
is immediately hidden, solely for the purpose of using its On Close event to
fire the logoff code. The form (or switchboard) will always close when the
user closes the database or application, and fire the code.

HTH,
Nikos

"dk" wrote in message
...
Hello everybody !
I need little help from You.
I have procedure to record log in and log out time. Everything goes fine
when user press custom button "close database".
The problem is that many users usualy use "x" button from windows to quit
application.
Is there any possibility to put some code ( call function XXX) on access
application quit or disable windows "x" button.
I find on newsgroups function "disable control box x" made by Calvin

Smith,
but it works for forms, not for complete application.

Thank You for Your suggestions !






  #3  
Old August 25th, 2004, 10:55 AM
dk
external usenet poster
 
Posts: n/a
Default

THNX Nikos!
The idea with dummy form is excelent !
Dk
"Nikos Yannacopoulos" wrote in message
...
You could take an alternative approach, i.e. leave the x button but make
sure the logoff code fires before the database is closed even if the user
closes it from the x button of the database window or the application
itself. The trick is to use the On Close event of a form that is open at

all
times. If you have a switchboard, then you can use its On Close event. If
not, then you can simply create a dummy form that opens on database open

and
is immediately hidden, solely for the purpose of using its On Close event

to
fire the logoff code. The form (or switchboard) will always close when the
user closes the database or application, and fire the code.

HTH,
Nikos

"dk" wrote in message
...
Hello everybody !
I need little help from You.
I have procedure to record log in and log out time. Everything goes fine
when user press custom button "close database".
The problem is that many users usualy use "x" button from windows to

quit
application.
Is there any possibility to put some code ( call function XXX) on access
application quit or disable windows "x" button.
I find on newsgroups function "disable control box x" made by Calvin

Smith,
but it works for forms, not for complete application.

Thank You for Your suggestions !








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Big Problem. We need the fix Captain K Calendar 0 July 8th, 2004 04:50 PM
Passport Logout Problem Chen qiang New Users 0 May 4th, 2004 09:26 AM
Help Microsoft? WORD11.ADM File Problem Line 818? Dwight Hutchinson New Users 2 May 3rd, 2004 08:25 PM
Word 2000 footnote problem: footnotes consistently too high (again) Lori Formatting Long Documents 2 May 1st, 2004 07:15 PM


All times are GMT +1. The time now is 01:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.