Registry settings for Snapshot reports in runtime

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In version 97 of Access there were settings that could be made in the
registry under the runtime profile which looked like the following:
[HKEY_LOCAL_MACHINE\SOFTWARE\Company
Name\SampleLog\1.2\Profiles\SampleLog\Report Formats]
Under this heading there would be:
"HTML"="html,SOA_RptToHtml,1,HTML (*.html),1"
"Microsoft Excel"="xls,SOA_RptToBIFF, Biff5,Microsoft Excel (*.xls),0"
"MS-DOS Text"="txt,SOA_RptToAscii,1,MS-DOS Text (*.txt),0"
"Rich Text Format"="rtf,SOA_RptToRTF,Rich Text Format,Rich Text Format
(*.rtf),0"

This allowed the user in runtime to use the RTF format reports to email to
who ever.
Now in version Access 2002 (XP) where do there registry entries go? Because
I would like to implement the automation of the reports using Snapshot and
saving them to a specific directory. This is no problem to write the code of
this. It should be the following:
DoCmd.OutputTo acOutputReport, "Basic Report B", "Snapshot Format", Filepath

Filpath set in the function as a string. This works on the machine with the
full version of Access 2002 even in runtime but a machine that does not have
the full version or no MS Access at all (only the installed Access runtime
version from the developers tool kit) gives an error that suggest that there
is an error in the registry. This is similar to the error obtained in the
pervious version i.e. version 97. Any help would be greatly appreciated.
 
For those who want to know: I have the solution. In the Access 97 version
if you are running the application in runtime you will need to set up your
registry in the following manner.
[HKEY_LOCAL_MACHINE\SOFTWARE\Company
Name\SampleLog\1.2\Profiles\SampleLog\Report Formats]
Under this heading there would be:
"HTML"="html,SOA_RptToHtml,1,HTML (*.html),1"
"Microsoft Excel"="xls,SOA_RptToBIFF, Biff5,Microsoft Excel (*.xls),0"
"MS-DOS Text"="txt,SOA_RptToAscii,1,MS-DOS Text (*.txt),0"
"Rich Text Format"="rtf,SOA_RptToRTF,Rich Text Format,Rich Text Format
(*.rtf),0"

For the more advanced version Access 2002 or XP you will need to add the
following to the registry. (using the OutputTo without these setting will
produce the following err number 2281)

[HKEY_LOCAL_MACHINE\SOFTWARE\Company Name\Profile
Name\5.002.0030(version)\Profiles\Product Name\Report Formats]
"HTML"="html,SOA_RptToHtml,1,HTML (*.html),1"
"Text Files"="txt,SOA_RptToAscii,1,MS-DOS Text (*.txt),0"
"Microsoft Excel 5-7"="xls,SOA_RptToBIFF, Biff5,Microsoft Excel Biff5
(*.xls),0"
"Microsoft Excel 97-2002"="xls,SOA_RptToBIFF, Biff8,Microsoft Excel Biff8
(*.xls),0"
"Rich Text Format"="rtf,SOA_RptToRTF,Rich Text Format,Rich Text Format
(*.rtf),0"
"Snapshot Format"="snp,,1,Snapshot Format (*.snp),0"
"Data Access Page"="html,,DAP Format,MicrosoftAccessDataAccessPage
(*.htm;*.html),36"
"XML"="xml,,XML Format,XML (*.xml),364"

In the heading [HKEY_LOCAL_MACHINE\SOFTWARE you need the name of the
registered owner of the software/Company it is registered to, e.g. ACCESS
AFRICA.
Then the profile name (set by your Package Wizard in the profile section
(last tab)), e.g. Northwind Pro.
Then after that the version setting (also set by the packing wizard) e.g.
5.002.0029. Then the Product/Application Name that comes after the
"\Profile\" section.
Lastly add \Report Formats]. The contents I suggest copy from your registry
in the Office\Access section of the registry.

This works as I have tried this on a machine that does not have Access
XP/2002 on the machine and the app run in runtime. However, you may find
that you need to load the Snapshot software that is available from Microsoft
(free). The other entries such as RTF and Excel or HTML seem to work as well.
The important part is the heading of the registry entry. Further, this only
works with a profile for the application (created by the Package Wizard).

So to all those who have struggled with "OutputTo" in the runtime version,
these are the registry settings needed.


Tom H. Dalton said:
In version 97 of Access there were settings that could be made in the
registry under the runtime profile which looked like the following:
[HKEY_LOCAL_MACHINE\SOFTWARE\Company
Name\SampleLog\1.2\Profiles\SampleLog\Report Formats]
Under this heading there would be:
"HTML"="html,SOA_RptToHtml,1,HTML (*.html),1"
"Microsoft Excel"="xls,SOA_RptToBIFF, Biff5,Microsoft Excel (*.xls),0"
"MS-DOS Text"="txt,SOA_RptToAscii,1,MS-DOS Text (*.txt),0"
"Rich Text Format"="rtf,SOA_RptToRTF,Rich Text Format,Rich Text Format
(*.rtf),0"

This allowed the user in runtime to use the RTF format reports to email to
who ever.
Now in version Access 2002 (XP) where do there registry entries go? Because
I would like to implement the automation of the reports using Snapshot and
saving them to a specific directory. This is no problem to write the code of
this. It should be the following:
DoCmd.OutputTo acOutputReport, "Basic Report B", "Snapshot Format", Filepath

Filpath set in the function as a string. This works on the machine with the
full version of Access 2002 even in runtime but a machine that does not have
the full version or no MS Access at all (only the installed Access runtime
version from the developers tool kit) gives an error that suggest that there
is an error in the registry. This is similar to the error obtained in the
pervious version i.e. version 97. Any help would be greatly appreciated.
Click to expand...
 
Back
Top