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

Thanks
Randy



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