Brett Barabash
BBarabash at TappeConstruction.com
Wed Feb 25 17:38:52 CST 2004
Aha! I see... Never tried that before (tend to favor MDI interfaces anyways). I saw a code sample on Dev Ashish's site that used the ShowWindow API call to hide it. Is this the one you are using? (I think that may be a little out of the realm of Macro commands <grin>) -----Original Message----- From: DWUTKA at marlow.com [mailto:DWUTKA at marlow.com] Sent: Wednesday, February 25, 2004 4:42 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Re: OT Quick Question Um, try again Brett. I said ACCESS Window, NOT the database window. If you know of a way, without VBA (or any other 'code language') to hide the ACCESS Window, I'd love to know. Hiding the access window puts your forms on the desktop, and you don't have Microsoft Access sitting in the taskbar. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Brett Barabash Sent: Wednesday, February 25, 2004 4:15 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Re: OT Quick Question Can't hide the Access Window without VBA? C'mon now Drew! Some of us who began Access development before VBA recall using DoMenuItem Form, Window, Hide in our AutoExec macros to hide the Access window (alternatively you could use DoCmd DoMenuItem in AccessBasic code, your choice!). In A97 and beyond, the same can be accomplished with RunCommand WindowHide in a Macro. Not the most elegant solution (only works if your database window is active), but I can personally show you one of our A2 apps that uses it, and it hasn't failed once in the last 8 years! At 10:12 AM 2/25/2004 -0600, you wrote: >Date: Tue, 24 Feb 2004 14:00:40 -0600 >From: DWUTKA at marlow.com >Subject: RE: [AccessD] Re: OT Quick Question >To: accessd at databaseadvisors.com >Message-ID: > <2F8793082E00D4119A1700B0D0216BF8022278E9 at main2.marlow.com> >Content-Type: text/plain; charset="iso-8859-1" > >Um, yeah. Kind of what I was saying! > >Technically, whether people like it or not, if you use a form, you are using >VBA, because Forms are Class Objects. Whether you put code behind them or >not, they are still using VBA. VBA can be used with the UI, for reasons >other then business rules. In fact, the first VBA code I ever used was to >hide the Access Window, something that you can't do without VBA, and also >part of the UI. > >Drew ---------------------------------------------------------------------------- ---------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the originator of the message. This footer also confirms that this email message has been scanned for the presence of computer viruses. Any views expressed in this message are those of the individual sender, except where the sender specifies and with authority, states them to be the views of Tappe Construction Co. Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software.