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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center