Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Wed, 13 Aug 2008 09:26:09 -0700,    group: microsoft.public.access.macros        back       


Printing from a macro   
I am executing a macro from a Switchboard selection.  The macro is very 
simple - "open report" and "printout".  The report prints correctly, but 
after the report prints an image of the Switchboard screen also prints.  I do 
not understand what is causing the Switchboard image to print.
date: Wed, 13 Aug 2008 09:26:09 -0700   author:   FiscalMike

Re: Printing from a macro   
Hi FiscalMike,

The PrintOut command is printing your Switchboard view.  The OpenReport
command prints your report when you set the view to Print.  Sounds like you
just don't need the PrintOut command and it will work fine.

Bonnie
http://www.dataplus-svc.com

FiscalMike wrote:
>I am executing a macro from a Switchboard selection.  The macro is very 
>simple - "open report" and "printout".  The report prints correctly, but 
>after the report prints an image of the Switchboard screen also prints.  I do 
>not understand what is causing the Switchboard image to print.

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200808/1
date: Wed, 13 Aug 2008 16:53:17 GMT   author:   bhicks11 via AccessMonster.com u44327@uwe

RE: Printing from a macro   
Bonnie,

Exactly correct.  Thanks much!

"FiscalMike" wrote:

> I am executing a macro from a Switchboard selection.  The macro is very 
> simple - "open report" and "printout".  The report prints correctly, but 
> after the report prints an image of the Switchboard screen also prints.  I do 
> not understand what is causing the Switchboard image to print.
date: Wed, 13 Aug 2008 11:04:12 -0700   author:   FiscalMike

RE: Printing from a macro   
You welcome Mike.

Bonnie
http://www.dataplus-svc.com

FiscalMike wrote:
>Bonnie,
>
>Exactly correct.  Thanks much!
>
>> I am executing a macro from a Switchboard selection.  The macro is very 
>> simple - "open report" and "printout".  The report prints correctly, but 
>> after the report prints an image of the Switchboard screen also prints.  I do 
>> not understand what is causing the Switchboard image to print.

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-macros/200808/1
date: Wed, 13 Aug 2008 18:45:43 GMT   author:   bhicks11 via AccessMonster.com u44327@uwe

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us