reports("template").report.recordsource HELP 
Author Message
 reports("template").report.recordsource HELP

Trying to change the recordsource on a Access97 report in VB5;
The code follows.

   Dim objAccessSend As access.Application
   Set objAccessSend = CreateObject("Access.Application")

      With objAccessSend
         .OpenCurrentDatabase "c:\celpril\dbnov.mdb"
        'This is where I get the error template misspelled or not open
         .Reports("template").Report.RecordSource = "db" & Format(Date - 1)
         .DoCmd.SendObject acReport, "template", acFormatRTF, _

         "Attached report", False
      End With


Thu, 11 May 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Crystal Reports "Cannot Find Report."

2. Crystal Reports "Load report failed"

3. Report deployment, runtime, "load report failed"

4. Crystal Reports "Report Designer Component"

5. Help-"Error5-Logon Failed"-HELP PLease!!!!!!-Crystal Report

6. "Help" Unable to download Templates

7. "Crystal Reports" vs "Access Reports"

8. report "on no data"

9. Export Report to ".doc"

10. sample crosstab report from "Solutions"

11. printing a report as "text only"

12. "#Name?" in forms and reports


Powered by phpBB® Forum Software