By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,870 Members | 2,484 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,870 IT Pros & Developers. It's quick & easy.

View a snap shot file with VBA

P: n/a
Dear reader,

I have a Snap Shot file located in a folder.

Now I like to view the Snap Shot file.

First I created a string with the full pathname and Snap Shot file.

The Docmd.OpenView strSnpFile Shows me the message:

Can't find the object" will path and file name are correct.

Is there any one who can tell me the code in VBA to view the snap shot file.

Thanks for any help.

Kind regards,

Simon
May 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Simon" <Sv********@Versatel.nlwrote in message
<46***********************@news.tele2.nl>:
Dear reader,

I have a Snap Shot file located in a folder.

Now I like to view the Snap Shot file.

First I created a string with the full pathname and Snap Shot file.

The Docmd.OpenView strSnpFile Shows me the
message:

Can't find the object" will path and file name are correct.

Is there any one who can tell me the code in VBA to view the snap
shot file.

Thanks for any help.

Kind regards,

Simon
I think the snapshotviewer is the program you need for this, as I don't
think Access will open those files.

Try either the follohyperlink method

Application.Followhyperlink strSnpFile

or check out this wrapper for the ShelleExecute API
http://www.mvps.org/access/api/api0018.htm

If you want to open it at the time you create it, you could pass True
as the AutoStart parameter.

DoCmd.OutputTo acOutputReport, "myRpt", acFormatSNP, "c:\name.snp",
true

--
Roy-Vidar
May 6 '07 #2

P: n/a
http://c90a8de4c6f745e3accb1456333fe1df-t.ncvxui.info <a
href="http://c90a8de4c6f745e3accb1456333fe1df-h.ncvxui.info">c90a8de4c6f745e3accb1456333fe1df</a>
http://c90a8de4c6f745e3accb1456333fe1df-b1.ncvxui.info
c90a8de4c6f745e3accb1456333fe1df
http://c90a8de4c6f745e3accb1456333fe1df-b3.ncvxui.info
d0dcc556412a086f2aaa2d6f3acefbbe

Jun 7 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.