Print report to Acrobat Distiller

[PNGBill]

Hi Forum,
Using Access 2000 and have Acrobat 5 installed.
We use Acrobat Distiller as Default Printer.

Any ideas on how to get a Report to print direct to Distiller without any messages and if, possible use a file name related to the access record or if not then any unique file name ie, don't overwrite the last report saved.

I have it setup to print to distiller but we have to type in a file name for each record.

Have seen a few posts but they tend to cover where acrobat isn't installed and may not be default printer.

All we need is some form of unique file name so that when we have finished our task, we can go to the folder and see the 20 odd reports that we can then fax, email etc.

 

[SOS]

check this post out - I think it does what you want (or at least most of it).

 

[PNGBill]

check this post out - I think it does what you want (or at least most of it).

Thanks SOS. Noticed this previously and got overwhelmed by the size of the code just to handle the file name.

Very much a beginner with vba.

Guess I just have to try it and see what happens.

 

[SOS]

Ah Bill - you're better than you think. You deal with way more complex queries here, or database schemas, than this stuff. Just step through it, you'll get it.

 

[PNGBill]

This part fails on Debug

AdobeDevice = GetRegistryValue(HKEY_CURRENT_USER, _
                               "Software\Microsoft\WIndows NT\CurrentVersion\Devices", _
                               "Adobe PDF")

We use Windows xp pro. Any ideas on how to find the path to our AdobeDevice ??

 

[SOS]

This part fails on Debug

AdobeDevice = GetRegistryValue(HKEY_CURRENT_USER, _
                               "Software\Microsoft\WIndows NT\CurrentVersion\Devices", _
                               "Adobe PDF")

We use Windows xp pro. Any ideas on how to find the path to our AdobeDevice ??

Sorry, forgot that it doesn't work with Distiller. It needs the Adobe PDF Writer instead.

 

[PNGBill]

We have acrobat Printer as well and can use this as default.

Use distiller because it handles incoming postscript faxes better and doesn't show them distorted as printer does.

 

[PNGBill]

sorry, just to clarify. We have Adobe pdf writer ver 5 which has two printers. Acrobat PDFWriter and Acrobat Distiller.

We have them both installed and just use Distiller as default but can easily change this to Acrobat PDFWriter as default.

 

[SOS]

sorry, just to clarify. We have Adobe pdf writer ver 5 which has two printers. Acrobat PDFWriter and Acrobat Distiller.

We have them both installed and just use Distiller as default but can easily change this to Acrobat PDFWriter as default.

If you have PDFWriter installed the code should find the appropriate registry entry.

 

[PNGBill]

Even though the code is looking for Windows NT ?? while we have XP

 

[SOS]

Even though the code is looking for Windows NT ?? while we have XP

Windows XP (as well as Vista and 7 are all WinNT based). If you look in your registry at:

HKEY_CURRENT_USER\Software\Microsoft\

you will not find a Windows XP entry but will find a WindowsNT entry.

 

[PNGBill]

Here is a screen shot of the printer registry.
default is the pdf writer and it isn't showing as having any hex key

 

[SOS]

Bill you are looking under the wrong area. Your screen shot doesn't show

HKEY_CURRENT_USER\Software\Microsoft\WIndows NT\CurrentVersion\Devices

you are looking in the wrong area - it isn't under Printers\DevMode2. Where'd you get that from?

 

[SOS]

Perhaps it isn't installed properly? Or something? Not sure...

 

[PNGBill]

Good point. Here is the screen shot from the correct registry path but no NT

 

[SOS]

Wow, you have a malformed registry there. There shouldn't be two HKEY_CURRENTUSER paths.

You still are not looking in the right place. See my screenshots:

 

[PNGBill]

Here is the windows NT screen shot.

Checked other pc's and the same. Will reinstall acrobat and see what diff it makes.