[AccessD] Calling all Gurus - Hide Access Window

I've not tried this out, but you can probably do this by previewing the
report and displaying a small Pop-up form with the buttons needed to print,
quit, save to file etc.

I do this kind of thing in a 'normal' access project, with the Access window
visible, opening the report with code like this...


    PrintPreview "SomeReport", me.Name
    While IsLoaded("PrintPreviewFrm")
        DoEvents
    Wend

The routine PrintPreview  takes the name of the report and the calling form
as parameters and then opens the form PrintPreviewFrm which in turn opens
the report in preview mode.

The while loop then pauses the calling code until the form is closed.

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
> Sent:	Tuesday, November 02, 2004 3:22 PM
> To:	Access Developers discussion and problem solving
> Subject:	RE: [AccessD] Calling all Gurus - Hide Access Window
> 
> Lonnie,
> If you mean print from the preview, you'll need to have a custom menu.
> If you mean print from a button click without preview: DoCmd.OpenReport
> "SomeReport" works well.
> Did I miss something?
> HTH
> Jim
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Lonnie Johnson
> Sent: Tuesday, November 02, 2004 2: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