Andy Lacey
andy at minstersystems.co.uk
Sat Nov 8 14:27:49 CST 2003
John You don't have a SetFocus to anything on the form after the me.visible=False do you? That would make it visible again. Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters > Sent: 08 November 2003 20:12 > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] A2K - setting a form invisible on open > > > John, > > I have a startup form with quite a bit of startup code behind > it. To make it invisible, I go to the database window, > right-click the form, then select properties. Then check the > Hidden checkbox. Now the form will never display, but all > the code behind the form runs from the form's Open event. The > form also closes itself after it does all it's things and > opens the switchboard form. > > For you to be able to see and select the form from the list > in the database window, go to Tools|Options, then select the > View tab and check the Show Hidden Objects checkbox. Now, > when the form list is displayed in the database window, the > startup form's small icon will be 'grayed out' to indicate > that this form is hidden. > > As long as your users can't muck around in Tool|Options and > can't open the database window, this may work for you. > > HTH! > Dan Waters > Quality Process Solutions > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby > Sent: Saturday, November 08, 2003 10:11 AM > To: AccessD > Subject: [AccessD] A2K - setting a form invisible on open > > > I have a form I want to open invisible every time it opens, > regardless of how it is opened. I placed me.visible = false > in OnOpen. That doesn't work! The strange part is that if I > place a breakpoint on the line and stop execution on the > me.visible = false, then continue, the form correctly hides itself. > > Has anyone ever seen such a strangeness? > > John W. Colby > www.colbyconsulting.com > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > >