[AccessD] Re: OT Quick Question

Brett Barabash BBarabash at TappeConstruction.com
Wed Feb 25 16:15:28 CST 2004


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.




More information about the AccessD mailing list