[AccessD] form closure

Andy Lacey andy at minstersystems.co.uk
Sat May 8 13:02:08 CDT 2004


John
You can suppress the Close x but not if the form's maximized. See
http://www.mvps.org/access/api/api0022.htm to overcome this. Alternatively
(and easier) create a boolean var in the form's code (e.g. blnCanClose).
Behind your Close button set it to True. In the form's OnUnload event put:

If blnCanClose=False then
  Cancel=true
End if

That way only closing via your code will work.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Eget
> Sent: 08 May 2004 12:37
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] form closure
> 
> 
> Is there a way to hide the upper right hand corner (x) close 
> capability on a form. Individuals are closing out their 
> databases with that option instead of the form option i have 
> installed to compact upon closure? thanks john eget 
> -- 
> _______________________________________________
> 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