ACCESS FEED: RE: [MS_AccessPros] RE: close db not firing form close events

Senin, 24 Maret 2014

RE: [MS_AccessPros] RE: close db not firing form close events

Liz

That's actually a pretty common thing with Access. I occasionally find that a button or other control with event procedures loses its link to the Sub during development. Now that you mention it, it might have been a copy and paste but I can't swear to it. As Graham said, clicking the builder button will re-link the event to the Sub.

Bill

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> wrote :

Thanks Graham. I discovered that I had the break point on a shutdown form that doesn't open for me, and decided it was Friday-brain-went-on-happy-hour thing.

That is weird how that happens. I learned that if you copy and paste a button on a form that has code, that the code unbinds itself. Then all you have to do is click on the ellipses and it rebinds. Strange.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Graham Mandeno
Sent: Friday, March 21, 2014 6:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] RE: close db not firing form close events

Hi Liz

No, the code should still execute and it shouldn't ignore your breakpoint. In fact, this is a common way of preventing a database from closing, except under controlled conditions. If a form is open and you set Cancel to True in Form_Unload, then the database can never close.

Sometimes an object can become "disconnected" from its event procedures for no apparent reason. For example, you have a Form_Close procedure in the form module, but the OnClose property of the form is blank. Check OnClose in the property sheet and make sure it says [Event Procedure].

Cheers,
Graham

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Saturday, 22 March 2014 10:15
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: close db not firing form close events

So, if you have a breakpoint in a form close event, but then shot the database instead of just the form it ignores the breakpoint?

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, March 21, 2014 2:07 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] RE: close db not firing form close events

Wait. I think it is something else.

Maybe it is because it is Friday afternoon and my brain has already gone to happy hour.

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, March 21, 2014 2:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] close db not firing form close events

Pros, I have a database that is not firing the form close events. Any understanding why? Has anyone seen this?

Respectfully,

Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments

1851 S Pantano Road | Tucson, Arizona 85710

Office +1.520.239.4808 |

beaerospace.com

Passion to Innovate. Power to Deliver

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.