sending snapshot from access

  • Thread starter Richard.Shackleton
  • Start date
R

Richard.Shackleton

I have a problem with Microsoft Access.When I send a report in the
snapshot format the attachement has an exstenion of XLS.This only started
yesterday after a software failure, before that it was SNP.Does anyone
know how to change it back
 
B

Bob R

Richard
Try checking the File Type Options located in the Tools\Folder Options\File Types of the Windows Explorer Menu Bar. Scroll down to the Snapshot file and check the extension shown and what it opens with (Press <Edit>).

Bob

----- [email protected] wrote: ----

I have a problem with Microsoft Access.When I send a report in the
snapshot format the attachement has an exstenion of XLS.This only started
yesterday after a software failure, before that it was SNP.Does anyone
know how to change it back
 
R

Richard.Shackleton

I've checked that and its OK, and if I actually rename the files that has
been created from access to *.snp instead of *.xls it opens pefectly. So
the problem seems to be that access is just putting the wrong extension on
the file when it exports it.
 
B

Bob Rapp

Richard,

Try this. I created a little module to export reports to different file types and locations.. Here is one for Snapshot which specifies an Input and Ouput file along with a check box to let the user start the app after it is exported. Me.chkAutoStart is the check box name. This forces the export to have a specific file name. if this doesn't make any sense, let me know.

If Me.optNeverUsed Then ' Option on reporting menu
Screen.MousePointer = 11 ' Toggle the hourglass
strReport = "crptItemsNotUsed" ' Report name
If Me.optExportToFloppy Then ' User choosen output file
strExportDest = "A:\Items Never Used.snp"
ElseIf Me.optCd Then
strExportDest = "G:\Items Never Used.snp"
Else
strExportDest = "C:\Items Never Used.snp"
End If
DoCmd.OutputTo acOutputReport, strReport, acFormatSNP, strExportDest, Me.chkAutoStart
If Not Me.chkAutoStart Then
Beep
MsgBox "The selected report was exported to " & strExportDest & ".", vbInformation, "Reporting Manager..."
End If
Screen.MousePointer = 1
End If

----- [email protected] wrote: -----

I've checked that and its OK, and if I actually rename the files that has
been created from access to *.snp instead of *.xls it opens pefectly. So
the problem seems to be that access is just putting the wrong extension on
the file when it exports it
 
B

BObR.Shackleton

Bob,
Unfortunately thats no good, it allows you to save the snapshot to
a file but does not automatically create a mail with the details of the
sender in. I'm using this to create the mail
DoCmd.SendObject acSendReport, "memo", "Snapshot Format", send_to, , ,
"Memo " & ref_no, "please find attached memo " & ref_no, , False
 
Top