MastercafeCTV
mastercafe at ctv.es
Mon Dec 29 18:35:20 CST 2003
Yes it so easy, we use a function to LOAD any SNP file over the control. See the code Function LoadSnapshotFile(snpCtl As Object, strFilePath As String) As Boolean On Error Resume Next Const conSnpFinishedDownload As Integer = 4 With snpCtl .SnapshotPath = strFilePath Do While .ReadyState < conSnpFinishedDownload DoEvents Loop If .Error = 0 Then LoadSnapshotFile = True Exit Function Else MsgBox "Error loading FILE Snapshot", _ vbOKOnly, "Error Snapshot = " & .Error LoadSnapshotFile = False End If End With End Function On the form we put the SNAPSHOT control and ON OPEN, we send ARGS to the main form with SNPFile (me.informe= SNP file) ( me.snaprep = Ctl Snapshot in our Form) Private Sub Form_Open(Cancel As Integer) Me.informe = Me.OpenArgs LoadSnapshotFile Me.SnapRep, Me.informe End Sub For create the SNP files we use another function, and this is very flexible to send mail with this SNP Sub OutputSnapshotFile(intOutputTO As Integer, strName As String, Optional strPath As String, Optional strRecipName As String, Optional strSubject As String, Optional strmessage As String) Dim strOutputFormat As String DoCmd.Hourglass True Select Case intOutputTO Case conSaveSnapshotToDisk If Len(strPath) > 0 Then DoCmd.OutputTo acOutputReport, strName, acFormatSNP, strPath Else DoCmd.Hourglass False Exit Sub End If Case conSaveSnapshotToMail If Len(strRecipName) > 0 Then DoCmd.SendObject acSendReport, strName, acFormatSNP, strRecipName, , , strSubject, strmessage Else DoCmd.Hourglass False Exit Sub End If Case Else End Select DoCmd.Hourglass False End Sub Hope that this can help you. Good luck Juan Menendez =========================================== MASTERCAFE SL - NIF B-82.617.614 www.mastercafe.com Deleg. Asturias Tel 985.88.49.44 / 627.531.764 Fax 627.500.205 info at mastercafe.com juan at mastercafe.com Deleg. Madrid Tel 627.474.285 cecilia at mastercafe.com =========================================== -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Greggs Sent: lunes, 29 de diciembre de 2003 23:43 To: Access Developers discussion and problem solving Subject: [AccessD] [AccessD ]Snapshot Viewer Control I have inserted the Activex Snapshot Viewer Control into a form and can view a snp file. Is there any way I can change the file the viewer looks at programmatically? What I want to select the file from a list of snapshot files in a list box or continuous form and have the Viewer show me the selected snapshot. This could be a very cool way to give the user a thumbnail of a report to see if he is selecting the right report before he takes the time to preview or print it. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com