Access Snapshot Viewer

[arst06d]

I need to automate the printing of an Access snapshot report, using the snapshot viewer.
I can invoke the viewer using:

<script language="javascript">
    function fnShellExecuteJ()
    {
        var objShell = new ActiveXObject("Shell.Application");
        
        objShell.ShellExecute("C:\\Program Files\\Snapshot Viewer\\SNAPVIEW.EXE","\\\\server\\share$\\folder1\\report.snp", "", "open", "1");
    }
</script>

however, using the print action - nothing happens

<script language="javascript">
    function fnShellExecuteJ()
    {
        var objShell = new ActiveXObject("Shell.Application");
        
        objShell.ShellExecute("C:\\Program Files\\Snapshot Viewer\\SNAPVIEW.EXE","\\\\server\\share$\\folder1\\report.snp", "", "open", "1");
    }
</script>

Thanks in advance

 

[arst06d]

That last code should read:

[code]
<script language="javascript">
    function fnShellExecuteJ()
    {
        var objShell = new ActiveXObject("Shell.Application");
        
        objShell.ShellExecute("C:\\Program Files\\Snapshot Viewer\\SNAPVIEW.EXE","\\\\server\\share$\\folder1\\report.snp", "", "print", "1");
    }
</script>

[/code/

 

[BabyJeffy]

Does it work if you use VB to call the snapview application? It may be that there is no way to print programatically.

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094

 

[BabyJeffy]

In fact I see no mention of print as an option for shell execution over at MSDN site. Maybe you can't do this

Cheers,
Jeff

[tt]Jeff's Page @ Code Couch

http://www.codecouch.com/jeff/

http://www.codecouch.com/jeff/blog/

[/tt]

What is Javascript? FAQ216-6094

 

[BillyRayPreachersSon]

There is a print option - but it's the second parameter, not the 4th, as you currently have in your script.

http://msdn.microsoft.com/library/d...rm/shell/reference/functions/shellexecute.asp

Dan



[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[arst06d]

just tried vb and no - doesn't work.
Nothing at all happens, in fact - would possibly have expected an error of some sort if the print action is not supported?

 

[arst06d]

sorry Dan, was replying to babyJeffy when you posted. I'll check it out.

Thanks

 

[arst06d]

Hi Dan

Not sure whether that flavour of ShellExecute is compatible with windows scripting host. I get "Incorrect number of arguments or invalid property assignment"

 

[arst06d]

Maybe there is no 'print' option as suggested above. n explorer, right-clicked on a .snp file and select print - opens the viewer and displays, but nothing prints ....

 

[arst06d]

managed it as follows:

function printReport2(strReport)
{
	var strObj;

	strObj = "<OBJECT id=SnapshotViewer style='LEFT: 0px; TOP: 0px' height='0%' width='0%' classid='CLSID:F0E42D60-368C-11D0-AD81-00A0C90DC8D9' VIEWASTEXT>"
	strObj = strObj + "<PARAM NAME='_ExtentX' VALUE='16933'>"
	strObj = strObj + "<PARAM NAME='_ExtentY' VALUE='12700'>"
	strObj = strObj + "<PARAM NAME='_Version' VALUE='65536'>"
	strObj = strObj + "<PARAM NAME='SnapshotPath' VALUE='[URL unfurl="true"]http://apollo04.shb.co.uk/David/Snapshots/Reports/20060306/Options/ibisandintas.snp'>"[/URL]
	strObj = strObj + "<PARAM NAME='Zoom' VALUE='4'>"
	strObj = strObj + "<PARAM NAME='AllowContextMenu' VALUE='-1'>"
	strObj = strObj + "<PARAM NAME='ShowNavigationButtons' VALUE='-1'></OBJECT>"

	
	var snpDiv = document.getElementById("snapshotDiv");
	snpDiv.innerHTML = strObj;
	var snp = document.getElementById("SnapshotViewer");
	snp.PrintSnapshot(false);
	
}