Re: Snapshot viewer and Access 97 reports And Emailing
- From: Salad <oil@xxxxxxxxxxx>
- Date: Sat, 24 Sep 2005 21:09:02 GMT
polite person wrote:
On Thu, 22 Sep 2005 23:40:00 GMT, Salad <oil@xxxxxxxxxxx> wrote:
Hi: I have the following line:
DoCmd.SendObject acSendReport, "TestReport", _ "SnapshotFormat (*.snp)", _ "joeblow@xxxxxxxxxxx", , , "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.
.
- References:
- Prev by Date: Re: Code for controling FTP from Access VBA
- Next by Date: Re: Looking for matches, adding to match table
- Previous by thread: Re: Snapshot viewer and Access 97 reports And Emailing
- Next by thread: A97 query question
- Index(es):
Relevant Pages
|
