HELP! Exporting a selected report or group of reports to a SNP format

  • Thread starter Thread starter Kath via AccessMonster.com
  • Start date Start date
K

Kath via AccessMonster.com

Hi all,
I am trying to create a "mode" to select that would indicate that when a
report or group of reports is selected it is not printed by exported to a
specific file location as a *.snp file (automating posting reports to a
Intranet on a Unix server based on Samba mgmt. Any ideas?
 
ok, more info...I can create the export, but how to I specify the file
location but have the file name the same as the report? Here is the code I
have thus far. :)

On Error GoTo Err_cmdIntra_Click

Dim stDocName As String

stDocName = "OutputSNP"
DoCmd.RunMacro stDocName
DoCmd.OutputTo acOutputReport, Me.ReportID, acFormatSNP
Exit_cmdIntra_Click:
Exit Sub

Err_cmdIntra_Click:
msgbox Err.Description
Resume Exit_cmdIntra_Click
 
Back
Top