[AccessD] A2K - setting a form invisible on open

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
> 
> 




More information about the AccessD mailing list