cannot terminate msaccess

[hennep]

Some of my Access applications won't close after "application.quit". in that case i have to remove the access from memory by killing the process with the task manager.

I've already found an article in msdn about one of the possible causes: Q190074
it says:

When you try to quit Microsoft Access version 97, you find that you are able to close the database, but you are unable to quit Microsoft Access. Instead, Microsoft Access is minimized without generating any errors.

This is exactly my problem but the solution mentioned here does not work. All checkboxes are handled correctly.

Does anybody know a "better" solution.

thanks,
Hennie

 

[hennep]

I think I have found it

If Me.Parent![CheckBox] Then
MsgBox "true"
End If
needs to be changed in
If Me.Parent![CheckBox] = True Then
MsgBox "true"
End If

AND passing the checkbox as an argument of a sub or function is a problem too

SomeSub arg, arg2, Me.Parent![CheckBox], arg4

needs to be changed in

if Me.Parent![CheckBox] = true then
SomeSub arg, arg2, true, arg4
else
SomeSub arg, arg2, false, arg4
endif