Arthur Fuller
artful at rogers.com
Fri Apr 11 19:32:48 CDT 2003
Ok JC I'll give that approach a try. It sucks, but you know what you're doing so I'll buy your advice. Since I've never done this, exactly how do you go about it? In the form-open code do you say me.visible = False? Forgive me the stupid questions but I've never had to go here before. A. > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] > Sent: April 11, 2003 7:25 PM > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Startup Module not Startup Form > > Arthur, > > If you have startup, you generally have cleanup as well. As you know > Access can hang if you don't cleanup properly. I use exactly what you are > discussing - a hidden form. The form's OnOpen runs my init, and the > form's Close runs my cleanup. That way the database simply cannot close > without cleaning up. the database close has to close the form before it > can close. The close event WILL fire. The cleanup will happen. > > Works well. > > -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2460 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030411/ad2ca855/attachment-0001.bin>