Darren DICK
d.dick at uws.edu.au
Wed Nov 3 16:13:01 CST 2004
Hi Lonnie I have a switchboard type form open all the time It is hidden or not hidden depending on where the user has gone When reports are open and the MDI is displayed I have it hidden In the On close of the Switchboard the User is prompted with a msgbox Are you sure you want to close and quit the <<appname>> application? (VBYESNO) That way if they click the big X not the little x in the reports area It (obviously) attempts to close the app, thus attempts to close the Switchboard and thus the MsgBox Confirming quitting comes up. After show or explaining it once they realise they have clicked the bigX By mistake and they answer no the to MsgBox and everything's is cool Simple <vbg> There are heaps of ways of doing this. Have a look in the archives or contact me off list and "I'll show you mine" ;-))) See ya DD -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lonnie Johnson Sent: Thursday, 4 November 2004 1: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 <d.dick at uws.edu.au> 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