reports("template").report.recordsource HELP

reports("template").report.recordsource HELP

Post by Rand » Mon, 24 Nov 1997 04:00:00

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



1. Report Tool "Crystal Reports"

It's probably a stupid question, ...

Is it possible to use Crystal Reports in combination with FM files.
Or any other report writer.

I'am aware of the FM report writer qualities of FM.
I just don't want to anyone to add lay-outs and make scripts.

Thanks in advance,


2. Upsizing from Access 95

3. Layouting Reports / "Exporting" Reports

4. msgraph

5. PDF report generator "vienas reports"

6. Syntax problem using Aliases in SQL

7. Help "Select-a-Report"

8. Inserting Records into IB / TQuery

9. Report crashes when using "order by"

10. Zachary's Crystal Reports "Deal"

11. issuing "MS Access" reports through MSVC

12. Report Writer "101"

13. Report stops with message "Timeout Expired"