Executing an Access Report in DTS ActiveX Script
Hi, my ultimate goal is to convert an Access report to *.rtf format and then email the new file to a mailing list.
I've used Data Transformation Services in SQL before, and I've been successful sending files to mailing lists.
I need help in doing one of the following, which will accomplish my goal:
1. Make an Active X Script that will convert the Access report to *.rtf and save it to the harddisk.
I've tried this code:
Set objDB = CreateObject("Access.Application")
objDB.DoCmd.OutputTo acOutputReport, "report name", acFormatRTF, "C:\Dest Name.rtf"
In DTS, I get the error "The Microsoft Jet Database engine couldn't find the object 'Database name'
2. Make an Active X Script that will execute the Access Report.
In this situation, I have used VB to attach the Code to the Access report. This code successfully outputs the report to *.rtf format when the report deactivates. Thus, I need only execute the report through ActiveX or some other means to produce the output file.
The code I use in the actual Access report to output the file is as follows:
DoCmd.OutputTo acOutputReport, "report name", acFormatRTF, "C:\Dest Name.rtf"
Thanks for your replys! Any help is appreciated!
By Joey_G in forum Database
Last Post: 02-18-2005, 08:40 AM
By Mike Mitchell in forum .NET
Last Post: 09-13-2002, 05:41 PM
By Sergey in forum Database
Last Post: 10-12-2001, 12:06 AM
By Bob in forum VB Classic
Last Post: 06-21-2001, 05:37 AM
By Calle in forum VB Classic
Last Post: 08-28-2000, 05:18 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL