View Single Post
  #4 (permalink)  
Old 28-Jul-2006, 07:36 AM
Tom Wickerath's Avatar Tom Wickerath
Guest
 
Posts: n/a
   
   
Re: VB Code to print to .pdf

Hi Jennifer,

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13344-vb-code-to-print-to-pdf.html
You might find that one of these methods works for you. You may need to add
a command button to your form to print a report based on the active record in
your form, instead of the form itself.

Printer Selection Utility
http://allenbrowne.com/AppPrintMgt.html

How to automate the process of selecting the printer
for a report in Microsoft Access
http://support.microsoft.com/?id=319317

Programming Printer Settings in Microsoft Access 2002

http://msdn.microsoft.com/library/de...0_printers.asp


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"Jennifer Cali" wrote:

> Hi Doug,
> I feel like your new best friend (or that crazy person who asks too many
> questions - you decide).
>
> I actually have PrimoPDF on my computer already, and I love it - very easy
> to use. I can select "Print" from the file menu and change the printer, but
> I'd rather have a button on my form that allows users to print a copy of the
> report directly to .pdf format (a shortcut). Currently my VB looks like:
>
> Dim stDocName As String
> Dim MyForm As Form
>
> stDocName = "frmMVR"
> Set MyForm = Screen.ActiveForm
> DoCmd.SelectObject acForm, stDocName, True
> DoCmd.PrintOut
> DoCmd.SelectObject acForm, MyForm.Name, False
>
> Where in here can I set the printer type? I want it to select the printer
> PrimoPDF.
> --
> Thank you! - Jennifer
>
>
> "Douglas J. Steele" wrote:
>
> > Take a look at what Stephen Lebans has at
> > http://www.lebans.com/reporttopdf.htm
> >
> > Other options include CutePDF at http://www.cutepdf.com, PDF995 at
> > http://www.pdf995.com/ and the PDF and Mail Class Library from ACG Software
> > at http://www.groupacg.com/
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "Jennifer Cali" wrote in message
> > news:039B7833-90A2-4272-A54D-D23B0EDA8D2F@microsoft.com...
> > >I want to print the file to .pdf, but am not sure how to code the VB to do
> > > it. Right now the print is going to the default printer; I need to change
> > > the
> > > printer that it prints to.
> > > --
> > > Thank you! - Jennifer

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13344
> >
> >
> >

Reply With Quote
 
Page generated in 0.11865 seconds with 25 queries