[AccessD] Re: OT Quick Question

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.




More information about the AccessD mailing list