Firing an Event on MS Access exit (1 Viewer)

G37Sam · Apr 23, 2008

Hi,

I would like to know if there's a way one can launch an event when MS Access is closed (hitting the outermost close button)

Regards,
Samer

pbaldy · Apr 23, 2008

One typical method is using the unload event of a form that would always be open. There is no event on the program itself closing.

boblarson · Apr 23, 2008

As Paul mentions, I typically will have a hidden form that is open and in its UNLOAD event I will put whatever I want, including code that will ask the user if they really wanted to close the database and setting Cancel = True if they did not, thereby keeping the database open if the close X at the top of the screen was used.

G37Sam · Apr 23, 2008

thanks, appreciate it

burrcm · Apr 24, 2008

MS code here to disable the X. You can then have an exit button on your form or command on menu. File - Close beats it though.

http://support.microsoft.com/kb/245746

Chris B

aziz rasul · Jan 22, 2013

On the link above, I get the error

user-defined type not defined on the line

Code:

Dim c As CloseCommand]

when I open my database?

pbaldy · Jan 22, 2013

Never used it, but is that bracket really in your code?

aziz rasul · Jan 22, 2013

Sorry that's a typo.

pr2-eugin · Jan 22, 2013

Did you follow the steps correctly?? As the Step 6 says..

On the File menu, click Save (to save the project), and when prompted for the name of the class module, save it as CloseCommand.

So if you save it as such I think the compiler Error will not occur..

aziz rasul · Jan 23, 2013

I checked all that. I now get an error

'the expression you entered has a function name that Microsoft access can't find'

when it runs the InitApplication() function.

pr2-eugin · Jan 23, 2013

So the Function InitApplication() is on a Standard Module, and the other Procedures like Get Enabled() and Let Enabled() are in a separate Class Module?

aziz rasul · Jan 23, 2013

Ah, I had the module types the wrong way round. Thanks.

pr2-eugin · Jan 23, 2013

Yea, I have done something similar to that in the past, so thought it might be case here too..

Good luck..

Firing an Event on MS Access exit (1 Viewer)

G37Sam

Registered User.

pbaldy

Wino Moderator

boblarson

Smeghead

G37Sam

Registered User.

burrcm

Registered User.

aziz rasul

Active member

pbaldy

Wino Moderator

aziz rasul

Active member

pr2-eugin

Super Moderator

aziz rasul

Active member

pr2-eugin

Super Moderator

aziz rasul

Active member

pr2-eugin

Super Moderator

Similar threads

Users who are viewing this thread