Pick PDF Creator (1 Viewer)

[GC2010]

I am using

acFormatPDF

to convert a report to a pdf. I have both Adobe and CutePDF installed on my computer. Is there a way I can select which one generates the PDF?

I ask because Adobe is not writing my label to the PDF but cute is, so I would need to use cute.

 

[bastanu]

acFormatPDF uses none of those but the Microsoft Office built-in PDF generator. You will need to use APIs to use the other two you have.

Cheers,

 

[GC2010]

Oh, I didn't realize Office had a built-in PDF generator. Is there a way that I can "force" it to recognize the barcodes added? I'm using 3 of 9 barcode which is pretty standard.

 

[bastanu]

Have a look at these links:

Printing bar or qr codes in access

I would like to be able to either print bar codes or qr codes in an access report. Can this be done in access?

answers.microsoft.com

Using the Barcode Font with Access

Using ConnectCode barcode font with Microsoft Access.

www.barcoderesource.com

 

[GC2010]

I have looked at those

My issue is that if I do ctrl+p to print, and select Adobe no barcodes are printed, if I use the code above acFormatPDF no barcode is printed, but if I select cutePDF the barcode prints exactly as I need.

 

[bastanu]

Sorry, I don't use barcodes, but it is a well discussed topic in the forums, there seems to be many free ActiveX controls to do that and the specific fonts need to be installed (which shouldn't be your case if CutePDF does it).

In the meantime look at these links on how to specify the printer for a report. Change the printer to CutePDF, print your report then set if back to the original default.

Automate process of selecting printer for a report - Office

Describes how to programmatically select a printer and print the reports with the options that you predefine. Assumes you are familiar with the Access database and Visual Basic programming.

docs.microsoft.com

MS Access – Select a Printer | DEVelopers HUT

Illustrating printer manipulations (opening the dialog, switching printers and more...) in Microsoft Access using VBA.

www.devhut.net

Cheers,
Vlad

 

[Gasman]

You could try setting the Printer to Cute PDF Writer and just print it?

 

[GC2010]

@Gasman - I'll have to google to figure out how to use vba to set a printer

 

[Gasman]

@Gasman - I'll have to google to figure out how to use vba to set a printer

You might also search here.?
Plenty of links about with Google

Basically store the current printer, set to new one, print, then set back to old printer.

 

[bastanu]

Wouldn't all that be in my post #6 above:

In the meantime look at these links on how to specify the printer for a report. Change the printer to CutePDF, print your report then set if back to the original default.

Automate process of selecting printer for a report - Office​

Describes how to programmatically select a printer and print the reports with the options that you predefine. Assumes you are familiar with the Access database and Visual Basic programming.
docs.microsoft.com
MS Access – Select a Printer | DEVelopers HUT

 

[Gasman]

@Gasman - I'll have to google to figure out how to use vba to set a printer

There you go, @bastanu had already given you a link on how to do it.?