The ReportToPDF converter works by first exporting the report to Snapshot
format, breaking the Snapshot file into its component Metafiles, and then
converting each individual Metafile record into its PDF counterpart.
You are using a non US version of Windows. If you forget about my code for a
moment, and simply tried to export any report to Snapshot format, the
process would fail with the same error message you encountered with my code.
Here is a detailed explanation of the issue by a Spanish Access MVP:
Well. There is a bug in spanish Access XP and 2003 (and probably in other
non-english versions).When spanish Access Xp or Access 2003 install, they
write a wrong entry in windows registry for the Snapshot Format. I mean,
they write this (for Access XP):
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Access\Report
Formats\snp,,1,Formato Snapshot (*.snp),0
which is a translation of something that had to be written in english (note
the "Formato Snapshot" spanish translation of "Snapshot Format"). I mean,
they should write:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Access\Report
Formats\snp,,1,Snapshot Format (*.snp),0
which is the correct one!
The same happens with Access 2003.
AFAIK, this bug is not fixed. It stills there.
So, if you use the PDF converter in some of these spanish versions, and the
problem of the wrong registry value hasn't been previously fixed... well,
Access says that "The format is not avalable" ... or so, I don't remember
the exact message, meaning that it cannot find the Snapshot Format value in
registry, and obviously, it stops there.
When you correct that value in windows registry, everything goes all right.
To reproduce this situation, you can temporarily change that value in
registry for whatever other you want, and then you try the PDF converter.
Saludos,
Juan M Afan de Ribera
[MVP Access]
http://accessvbafaq.mvps.org
http://www.mvp-access.com/juanmafan
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
Zappus said:
In the "How to use" form, when i clic on button after set for example the
first report (in convert report to pdf section) it give a message that the
format for the output is not disponible.
Can you help me?
