access system close

[jurgen]

How can I prevent that user quits the application with the system close in access. I kind have procedure that the users have to follow to get result, but if he closes with the system close, I need to reset that data.

So I want to block every possibility to quit access. Anyone an idea ?

Regards


Jurgen

 

[MarkWright]

Hello Jurgen,

the last step in Access is the
Private Sub Form_Unload(Cancel As Integer). set your coding here to check if something is not answered . Use an exit sub to exit if the user has to finish giving any information in the formular. For example ->

If IsNull(Produkt.Value) Then
MsgBox "Produktfeld Bitte ausfüllen "
Exit Sub
else
***
end if

This is something I use to make sure the user fils in all the text fields that need to be filled.

Hope this is what you were looking for.
Mark