S
smw
The following code:
Dim sReport As String, sOutput As String
sReport = "ReportName"
sOutput = "C:\Test.snp"
DoCmd.OutputTo acOutputReport, sReport, "Snapshot Format",
sOutput
Causes the following error:
Run-time error '2282':
The formats that enable you to output data as a Microsoft
Excel, rich-text format, MS-DOS text, or HTML file are
missing from the Windows Registry.
I am doing this in an Access 97 database. All the normal
references are checked and all other VBA code is working.
This code has worked fine in Access 2000 and Access XP
databases, but does not work in Access 97 on my PC.
I have Office 97, 2000, & XP installed (in seperate
folders and in the correct order) and have had no other
issues (except the hatten font issue - see Knowledge Base
article #141373). Any info would be greatly appreciated !
smw
Dim sReport As String, sOutput As String
sReport = "ReportName"
sOutput = "C:\Test.snp"
DoCmd.OutputTo acOutputReport, sReport, "Snapshot Format",
sOutput
Causes the following error:
Run-time error '2282':
The formats that enable you to output data as a Microsoft
Excel, rich-text format, MS-DOS text, or HTML file are
missing from the Windows Registry.
I am doing this in an Access 97 database. All the normal
references are checked and all other VBA code is working.
This code has worked fine in Access 2000 and Access XP
databases, but does not work in Access 97 on my PC.
I have Office 97, 2000, & XP installed (in seperate
folders and in the correct order) and have had no other
issues (except the hatten font issue - see Knowledge Base
article #141373). Any info would be greatly appreciated !
smw