469,607 Members | 2,140 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,607 developers. It's quick & easy.

Snapshot viewer and Access 97 reports And Emailing

Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?
Nov 13 '05 #1
4 2373
MLH
<Big Snip>
PDF995 - a swell solution.
If so, any recommendations on a PDF program...preferably cheap?


Nov 13 '05 #2
On Thu, 22 Sep 2005 23:40:00 GMT, Salad <oi*@vinegar.com> wrote:
Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?

Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).
Nov 13 '05 #3
MLH
I'm looking for something to convert a pdf to a BMP or other file
format that makes A97 happy. Haven't found anything as of yet.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).


Nov 13 '05 #4
polite person wrote:
On Thu, 22 Sep 2005 23:40:00 GMT, Salad <oi*@vinegar.com> wrote:

Hi: I have the following line:

DoCmd.SendObject acSendReport, "TestReport", _
"SnapshotFormat (*.snp)", _
"jo*****@nowhere.com", , , "Report Test", _
"Does it open correctly?", True

I have a report called TestReport. I dropped an image control in the
report, and imported a .BMP file into it as the report's background, and
sent it to back. I then dropped my fields on top of the image.

The BMP image is about 8.5 inches wide by 7.0 inches long.

I soon found out that although it prints fine, you can't send it with
SendObject using the normal formats. I went to Google and found
something about the Snapshot viewer. I checked by Access version and it
said I had service release 2.0. but using the Snapshot format didn't
help. I get a "IDocCmd failure" message.

I then went to MS support and downloaded the snapshot viewer
(Snpvw.exe). I installed it but I still get a "IDocCmd failure" ( I
suppose someone is having a poke at marriage) and wondered if my above
command is OK. Is the version OK for A97?

Does the viewer choke on big BMP files? Hmmmm....I guess it does. I
just made a copy of the report and removed the image and the viewer
worked. Hmmmm....

Do you have any suggestions. Is sending a report via PDF the only way
to do this? If so, any recommendations on a PDF program...preferably cheap?

Hi
you can send .snp files as email attachments and the recipient can view them by double-
clicking them provided they have themselves installed the snapshot viewer, they don't
need Access. Not sure about the BMP problem.


The problem is that the Snapshot viewer can't handle large
images/pictures. Maybe it's good for thumbnails but it's not made for
any time of productions work.

if you use pdf, try http://www.cutepdf.com/Products/CutePDF/writer.asp
which is free, it installs as though it is a printer.
However when you print to it, it asks you to supply (or maybe just to confirm) the file
name, ok if you are donig it by hand but a nuisiance if it is automated. There was an
earlier thread on this and whether it required sendkeys (horror!).


Yes, cutePDF works. I was hoping there was a way one could pass to it
the folder/file name. I doubt it would take anyone anytime at all, that
wrote cutePDF, to look for a file in it's current directory and if it
existed, write to the folder directory found in that text file.
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Chuck Grimsby | last post: by
1 post views Thread by Louis Eastwood | last post: by
1 post views Thread by Rick Brown | last post: by
3 posts views Thread by Daedalus | last post: by
2 posts views Thread by Rick Brandt | last post: by
9 posts views Thread by bluedolphin | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.