error using leban's ReportToPDF

J

Jorge

Hi, and sorry for my english

I would like use the ReportToPDF functions in one of my projects.
When I try to generate the pdf from an access report i'm getting the
following error:

error '2282': The format in which you are attempting to output the current
object is not available

It seems that the problem is in the DoCmd.OutputTo sentence when the program
is going to create the previous snapshot.
I'm able of export any report to snapshot, but when I try to do it with the
DoCmd.OutputTo command, I get the specified error.

Any help?
thanks
 
S

Stephen Lebans

This is an Access non Western language Snapshot registry entry issue.

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]



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
J

Jorge

A thousand of thanks...

It worked right

We are used to translation problems with microsoft software...


Stephen Lebans said:
This is an Access non Western language Snapshot registry entry issue.

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]



--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


Jorge said:
Hi, and sorry for my english

I would like use the ReportToPDF functions in one of my projects.
When I try to generate the pdf from an access report i'm getting the
following error:

error '2282': The format in which you are attempting to output the
current object is not available

It seems that the problem is in the DoCmd.OutputTo sentence when the
program is going to create the previous snapshot.
I'm able of export any report to snapshot, but when I try to do it with
the DoCmd.OutputTo command, I get the specified error.

Any help?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top