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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |