[AccessD] Calling all Gurus - Hide Access Window

Charlotte Foust cfoust at infostatsystems.com
Wed Nov 3 11:13:39 CST 2004


Isn't that what OT is for? <innocent>

Charlotte Foust


-----Original Message-----
From: Colby, John [mailto:JColby at dispec.com] 
Sent: Wednesday, November 03, 2004 8:42 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Calling all Gurus - Hide Access Window


Hmm... do we need a Lonely Hearts list?  ;-)

John W. Colby
The DIS Database Guy


-----Original Message-----
From: Lonnie Johnson [mailto:prodevmg at yahoo.com]
Sent: Wednesday, November 03, 2004 11:30 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Calling all Gurus - Hide Access Window


Christopher, 
 
I am a completely happily married heterosexual man but want to say I
LOVE YOU. I am going to try that. I'll look in the archives for that
code.

"Mackin, Christopher" <CMackin at quiznos.com> wrote:
You can always have a hidden form that processes the click on the "X" to
close the application as a command to close the report. The methodology
to prevent the ap from closing has been discussed extensively in the
archives, just add some code to that to close the currently visible
report and you should be OK.

-Chris Mackin

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lonnie Johnson
Sent: Wednesday, November 03, 2004 7:37 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Calling all Gurus - Hide Access Window


Thanks DD, Charlotte and Jim.

I may consider using the process of unhiding the Access MDI when viewing
a report. The only thing I didn't like when I tested it is that they
have the
(X) to close the application. 
The user may mistake this X as the one to close the report. In the form
that they use they have to close the app with a button. Anyway, thanks
again everyone. You've all earned the rank of Guru in my books.

Darren DICK wrote:
Hi Lonnie
I use this code all the time too.
When you want to "SEE" (i.e. Preview) a report you have to make the
Access window (MDI) visible again I do this in the onclick of the
'launching' command button for the report or in the load Events of the
report. Then when the report is closed I have code in the Unload to make
the MDI hidden again

I like the look of the hidden MDI and it really suits my purposes, you
just have to put up with The hide, unhide aerobics if you want to keep
hiding the MDI for forms.

If I am mistaken about the MDI and previewing reports I am sure someone
from the list will let me know

See ya 

DD

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie
Johnson
Sent: Wednesday, 3 November 2004 8:14 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Calling all Gurus - Hide Access Window

Yes, I have created the menu as and a toolbar as Jim had also suggested
and assigned their names in the property window for the form and cannot
see either of them when I open it. Am I missing another step?

Thanks Charlotte.

Bobby, Right Click dosen't work in this case with the HideWindow code.

Thanks to all so far.

Charlotte Foust wrote:
Have you created a shortcut menu for the report?

Charlotte Foust


-----Original Message-----
From: Bobby Heid [mailto:bheid at appdevgrp.com]
Sent: Tuesday, November 02, 2004 12:45 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Calling all Gurus - Hide Access Window


Can't you right-click and choose Print?

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie
Johnson
Sent: Tuesday, November 02, 2004 3:10 PM
To: 'MS-ACCESS-L at lists.missouri.edu'; AccessDevelopers; ms_access;
AccessD solving'
Subject: [AccessD] Calling all Gurus - Hide Access Window


Hello all,

I am using the popular API code that hides the access window and just
shows a form on the desktop. (Small snippet below)

Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As
Long) As Long Dim dwReturn As Long Const SW_HIDE = 0 Const SW_SHOWNORMAL
= 1 Const SW_SHOWMINIMIZED = 2....

It is working fine except withe reports. I am even able to preview
reports. However, how do I print them? Has anyone worked this part out?

I know there is an answer out there somewhere!

Thanks in advance.



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us












---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com/a
-- 
_______________________________________________
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
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us












---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com/a
-- 
_______________________________________________
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



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us












---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com/a
-- 
_______________________________________________
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



May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us





 





			
---------------------------------
Do you Yahoo!?
 Check out the new Yahoo! Front Page.  www.yahoo.com/a
-- 
_______________________________________________
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



More information about the AccessD mailing list