Re: [libreoffice-users] Printing Reports from BASE extends to Writer?

Yes, that seems correct.

On 10/29/2014 4:55 PM, Andrew Douglas Pitonyak wrote:
> Are you asking if it is possible to use a macro to open a document and 
> then print it?
>
> On 10/28/2014 11:56 PM, Paul D. Mirowsky wrote:
> > Can this be extended to Writer document, eliminating the requirement 
> > of opening Writer and selecting 'Print'?
> >
> > On 10/28/2014 4:05 AM, Walther Koehler wrote:
> > > 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