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
> > lodg...@gmail.com
> >
> > On 28 October 2014 13:24, Peter Goggin <petergog...@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+unsubscr...@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+unsubscr...@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
