How can I get a form to open for final data entry after initiating database close?

[bcmarshall]

I want to have a form open as the database is closed for people to enter one final bit of information about their productivity, and then email that to a supervisor, and then complete the close of db.



Is there a way to interrupt the sequence that begins with the Close Database command? What about the X in the top right corner? Can that be interrupted?

As always, all assistance is appreciated.

[rpeare]

Realistically no, if they close the database without using your form button you're pretty much hosed. If your users are reliably using the form button then you just make sure when the 'close' button is clicked it opens your 'final' form and when they click 'add information' on their productivity information that's when you issue the database close command.

[bcmarshall]

I kinda figured as much. Ideally I'd like to remove the X upper right from the DB, and remove the Close Database option from the menu. That would leave the only way to close the db as a form button, and of course then it's not a problem to accomplish.

Is it possible to remove the X and modify the menu?

[rpeare]

I haven't messed around with it for a long time but there used to be a way to create custom toolbars so you COULD substitute your own tool bar and remove the 'close' or 'exit' options but that doesn't prevent the user from using the x in the upper right of the application window. I'll have another look this weekend and see if I can find something.

[vicsaccess]

if they always finish on the same page before they close, you could use the onclose event of the form to open your final form.

[bcmarshall]

Thanks, Vic. I do have a final form and I first put a MsgBox in the OnClose (I put it on the top of other instructions already there). It fires without problem. Then I put a CancelEvent in order to make it possible to interrupt the cycle and open the form. That didn't work.
I didn't go straight to OpenForm because it seemed pointless. If the cycle isn't interrupted the final form will just close anyway. Do you think it's worth a test?

[vicsaccess]

what are you scared of? make a copy of the form and give it heck. i ran with one of mine and it worked great.

Private Sub Form_Close()
DoCmd.OpenForm "adminf"
End Sub

[bcmarshall]

I tried exactly as you described, and it didn't work. The form popped open, then closed and the DB closed as well.