Re: [libreoffice-users] Printing Reports from BASE

Hi Peter

just another proposal:

sub printreport()

Dim oDoc as Object
Dim arg(0) as new com.sun.star.beans.PropertyValue

oDoc=ThisComponent
arg(0).name = "Name"
arg(0).value = "<" & "myprinter" & " >"
oDoc.printPages(arg())
end sub

Yours
Walther

Am Dienstag, 28. Oktober 2014 schrieb Peter Goggin:
> On 28/10/14 15:01, Marion & Noel Lodge wrote:
> > Hi Peter,
> >
> > A macro similar to this should do what you want -
> >
> > Sub PrintReport()
> >          ThisDatabaseDocument.ReportDocuments.getbyname("<name of your
> > report>").open()
> > End Sub
> >
> > Then edit your Menu form, double click on the Print button and under
> > Events
> >
> > | 'Mouse button pressed', link the button to the PrintReport() sub.  Then
> >
> > when you run your application, clicking on the button should fire your
> > report.
> >
> > Noel
> > --
> > Noel Lodge
> > lodgemn@gmail.com
> >
> > On 28 October 2014 13:24, Peter Goggin <petergoggin@bigpond.com> wrote:
> > > I have a report run from a push button on a menu form. I can print it
> > > from the screen, but in Access I was able to program a push button to
> > > print id directly.  Is this possible in BASE? I cannot find any
> > > reference to this.
> > >
> > > Regards
> > >
> > >
> > > Peter Goggin
> > >
> > > --
> > > To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
> > > unsubscribe/
> > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > > deleted
>
> Thanks for the suggestion. However all the subroutine does is display
> the report on the screen. I want to be able to send it to the printer
> without first displaying it on the screen. So far I cannot see any
> reference on how to doi this.
>
> Regards
>
> Peter Goggin



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted