John W. Colby
jcolby at ColbyConsulting.com
Fri Apr 11 20:13:32 CDT 2003
Yep, I put me.visible = false in onOpen. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Sent: Friday, April 11, 2003 8:33 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Startup Module not Startup Form 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. << File: ATT00238.txt >> ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2304 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030411/4242f2ac/attachment-0001.bin>