Export to snapshot, viewer issues

[SusanV]

Hi all,

I have a form with a command button which exports 2 reports to snapshot
files then opens the files via Snapshot viewer. Works fine for everyone but
one user - he gets the error that the viewer couldn't access the data. If he
goes to the exported file via windows explorer it opens fine - but not when
the files are generated via VBA. I have several other reports generated the
same way via different command buttons and he has no problem with these -
but they are smaller reports - perhaps 3-4 pages, whereas these 2 reports
are 15+ pages. he also has no trouble if these same reports are exported as
rtf and open in Word.

His computer is running Win98, the database is Access 2000.

Any ideas?

TIA,

Susan

 

[Mastercafe - Juan]

On the windows registry the Snapshot format is diferent on some versions...
check with RegEdit and search SNAPSHOT you can see this.
This bug on Spanish version is normal... and always I need put a patch ON
ERROR....

on error goto CtrlError
dim formatoExp as String
dim SoloUnError as Boolean

'formatoExp="SNAPSHOT FORMAT (*)" this is the generic value
formatoexp = acFormatSNP
DoCmd.OutputTo acOutputReport, stDocName, formatoexp, cteInfsnp & "\" &
stDocName & Format(Date, "YYMMDD") & ".snp"

CtrlError:
If Err.Number = 2282 And SoloUnError = False Then
formatoexp = "Formato Snapshot(*.snp)" 'this is the value con Win2k
with Access2002Xp Spanish
SoloUnError = True
Resume
Else
MsgBox Err.Description
End If
exit sub

Check too that you have the SnapShot Viewer control on this machine.

--
Saludos

Juan
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)

 

[SusanV]

I have only English language versions, and the Snapshot Viewer works fine
when opening via Explorer, or with smaller reports. Perhaps it's a memory
issue - he's overdue for an upgrade which has been ordered(he currently only
has 128 MB RAM).
"Mastercafe - Juan" <vb

Thanks!

(e-mail address removed)> wrote in message

 

[Guest]

Hi Susan,

While you are waiting for the upgrade to arrive, you might try reinstalling
the Snapshot viewer on this PC. You can grab the latest copy here:

Microsoft Snapshot Viewer is available in download center
http://support.microsoft.com/?id=175274


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I have only English language versions, and the Snapshot Viewer works fine
when opening via Explorer, or with smaller reports. Perhaps it's a memory
issue - he's overdue for an upgrade which has been ordered(he currently only
has 128 MB RAM).
"Mastercafe - Juan" <vb

Thanks!

 

[SusanV]

Thanks Tom, I'll give that a try!

 

[SusanV]

That did it Tom, thanks again!

Thanks Tom, I'll give that a try!

 

[Guest]

Hi Susan,

You're welcome. Thank You for posting your reply to let me know that this
fixed it.


Tom
_____________________________________

:

That did it Tom, thanks again!