Weird issue on exit - Access 2010

[Shado]

Hi all,

Is there a way to tell if the user has pressed the exit button on Access itself? (The red cross in the top right corner). I've run into an issue where if the user hits this button, the currently open form fires form_load which in turn is opening a dialog box. Due to the dialog box opening, Access then just locks up requiring to be closed via Task Manager.

Basically, the user opens this form. If no arguments are supplied, a dialog comes up to search customers. If arguments do get supplied (the user is opening this form from another), the box won't appear. If I know what's firing the form_load, in my mind anyway, I can incorporate this event into my if statement that controls whether the dialog opens or not.

Thoughts?

 

[boblarson]

The currently open form would not be firing the LOAD event if the database is closing. What would be firing would be the form's close event and the UNload event.

 

[Shado]

That's what I thought also. Which is why it makes no sense. Back to the drawing board I guess!

 

[boblarson]

That's what I thought also. Which is why it makes no sense. Back to the drawing board I guess!

I would love to have you post a copy so I can see what's happening. What you THINK is happening may have a totally unrelated cause.

Can you run COMPACT AND REPAIR and then zip the file (right click the file and select SEND TO > COMPRESSED FOLDER) and then upload it? (make sure only fake data is in that copy). So we can try it out?

 

[Shado]

I would love to have you post a copy so I can see what's happening. What you THINK is happening may have a totally unrelated cause.

Can you run COMPACT AND REPAIR and then zip the file (right click the file and select SEND TO > COMPRESSED FOLDER) and then upload it? (make sure only fake data is in that copy). So we can try it out?

It's fixed. Was a logical error on the old programmers part (I've taken over the project). I couldn't have uploaded it though sorry, it's linked to an internal SQL server.

 

[franki007]

any chance you could post what the problem was, having the same issue.
Thanks

 

[Shado]

I can't recall off the top of my head sorry (multi projects going on). If I recall correctly, there was a reference to the forms load event somewhere that fired as the current form was closing.. Hence the infinite loop which caused the issue.