My Users Keep Accidentally Closing Access - Need Ideas

[mawcluster]

Hello.

I have a fairly complex database with a lot of charts, reports, forms etc.

My problem is that whenever someone chooses to maximize a Pivotchart, a report preview or other things, they usually click the big X button in the top right hand corner and close Access entirely. They don't think to click the smaller x button right below it.

This is frustrating when they just want to go back to the switchboard to performs some other task. They have to restart the database, log in...etc.

I know you can prevent forms and whatnot from being maximized, but I do want them to have that feature for a number of reasons... especially with my Pivotcharts. They are much clearer when expanded to full-size.

Is there a solution to this problem, or do my users just have to be more careful?

Thanks in advance

 

[KeithG]

Create an invisible form to open up when you switchboard opens. Put the below code in the invisble forms Unload event.

Private Sub Form_Unload(Cancel As Integer)
lngAnswer = MsgBox("Do you want to exit Microsoft Access?", vbYesNo)
If lngAnswer = 7 Then
Cancel = True
End If

End Sub


Now the user will prompted if the want to close the db.

 

[RuralGuy]

Or maybe this is what you were looking form. Enable/Disable The Control Box X Button

 

[Jakboi]

Create an invisible form to open up when you switchboard opens. Put the below code in the invisble forms Unload event.

Private Sub Form_Unload(Cancel As Integer)
lngAnswer = MsgBox("Do you want to exit Microsoft Access?", vbYesNo)
If lngAnswer = 7 Then
Cancel = True
End If

End Sub


Now the user will prompted if the want to close the db.

I really like the idea of bring prompted when exiting the database, however my lack of experience requires more detail. The database at "Enable/Disable The Control Box X Button" doesnt seem to open for me, anyone know where there might be some more information?

For this is all I need is the unload and load right or is there more? If thats it does anyone know what I need for it to load with switchboard...

Thanks.

 

[RuralGuy]

The database at "Enable/Disable The Control Box X Button" doesnt seem to open for me, anyone know where there might be some more information?

The database is in ac97 format. What version of Access are you using? It should try and convert it after you onlock the download and then try and load it. I don't think ghudson will mind if I upload his example in a 2K format and see if that works for you.

 

[The_Doc_Man]

You have only a few choices.

1. Disable the controls on the form's title bar.

2. Intercept the exit using VBA code in some form's OnExit routine.

3. Shoot the stupid users.

4. Let them wallow in their own misery until they learn better. One would think that after a few inconveniences they would learn.

5. If the stupid users are miserable managers who outrank you, return to step 3. The fewer stupid managers we have in this world, the better.

Sorry, I'm in the midst of a recovery period after having dealt with a stupid manager whose most endearing quality is that usually he doesn't DO anything so doesn't get in my way. But every now and then he wakes up... like today.

 

[RuralGuy]

Wow Doc,
It *has* to be Miller time!

 

[The_Doc_Man]

RuralGuy, the only cure for this disease is a long vacation. For me and the wife if possible. If not, then for the boss!

 

[RuralGuy]

You have *my* permission! Take the rest of the day off.

 

[JustinDB]

Imade my database comletly with VB and photoshop this is ideal. I made my own
menubalk with a close button of my own when clicking on this button a new screen appears. Asking if i want to close yes or no. It's as easy as that.

explaining this further is gonna take time so if you really want to make your database more advanced and better looking i suggest contacting me. I even know how to hide the acces screen so you only see the form your using. Also i can by making a admin login and a user login so when the user acces the database there options al minimum. there not allowed to see the tables forms and sutch the can;t even click the right mouse button.

 

[Jakboi]

You have only a few choices.

1. Disable the controls on the form's title bar.

2. Intercept the exit using VBA code in some form's OnExit routine.

3. Shoot the stupid users.

4. Let them wallow in their own misery until they learn better. One would think that after a few inconveniences they would learn.

5. If the stupid users are miserable managers who outrank you, return to step 3. The fewer stupid managers we have in this world, the better.

Sorry, I'm in the midst of a recovery period after having dealt with a stupid manager whose most endearing quality is that usually he doesn't DO anything so doesn't get in my way. But every now and then he wakes up... like today.

Thats great! ...

 

[Jakboi]

The database is in ac97 format. What version of Access are you using? It should try and convert it after you onlock the download and then try and load it. I don't think ghudson will mind if I upload his example in a 2K format and see if that works for you.

Hmmm...thanks now I can open it. I copied over the fTestCancelFromUnloadEvent to my switchboard, meaning the checkbox. I put the unload event in my switchboard.

However the checkbox does want to be checked. So I get prompted to check the box but it wont let me...sure its an easy fix...

Any ideas of what I forgot to do...

 

[RichardP1978]

I like the sound of number 3 Doc Man, that sounds great at the moment, havent worked out yet who the target is, the owner or my colleagues!

This is actually a helpful thread to me, so thanks, I have just used the hidden form method.

 

[RuralGuy]

I would have used the dDisableControlBoxX module to disable the Control Box X.

 

[CraigDolphin]

3. Shoot the stupid users.

4. Let them wallow in their own misery until they learn better. One would think that after a few inconveniences they would learn.

5. If the stupid users are miserable managers who outrank you, return to step 3. The fewer stupid managers we have in this world, the better.

Can I add these to my rules for living?

 

[The_Doc_Man]

Craig, as long as you don't name me as a co-conspirator, do what you like with the rules.

Actually, when I get a REALLY annoying user, I apply #4 by preference on the theory that experience is the best teacher. I also make the changes really low priority so that I can honestly say - It's on my list...

Further, if the user is both annoying AND stupid, I drop the priority so far that it will NEVER see the light of day. Then I start an office pool on how long it will take for the jerk to get so frustrated as to break down in tears. If the user ISN'T the boss, I invite the boss to join in the pool so he won't spill the beans.

 

[mawcluster]

Thanks guys...the module to disable the X button was just what I needed!

 

[namliam]

3. Shoot the stupid users.

4. Let them wallow in their own misery until they learn better. One would think that after a few inconveniences they would learn.

5. If the stupid users are miserable managers who outrank you, return to step 3. The fewer stupid managers we have in this world, the better.

I like it !

 

[Pauldohert]

Originally Posted by The_Doc_Man
3. Shoot the stupid users.

4. Let them wallow in their own misery until they learn better. One would think that after a few inconveniences they would learn.

5. If the stupid users are miserable managers who outrank you, return to step 3. The fewer stupid managers we have in this world, the better.

I think my users/managers are beyond the level of stupidity that these rules were meant for. Is there more that I can do apart from just shooting them, just to be sure?

 

[neileg]

I think my users/managers are beyond the level of stupidity that these rules were meant for. Is there more that I can do apart from just shooting them, just to be sure?

Don't shoot to kill, a severe wound will keep them off work for a while!