Subreport Detail

[Ron]

I have an Access 2000 database with a report that has a
subreport. I need to retrieve the information from the
records displayed in the subreport from a VB 6 application.

In the VB application, I get a handle to the running
Access instance and eventually get a handle to the
displayed subreport. When I try to do something like:

Set myRS = mySubRpt.Recordset

I get an error message stating:

This feature is not available in an MDB.

How do I otherwise access the individual records?

 

[Michael Shao [MSFT]]

Hi Ron,

Thanks for your post. As I understand, you want to retrieve the Recordset
property of a report in a Microsoft Access database (.mdb). If I have
misunderstood, please feel free to let me know.

Based on my research, reports in a Microsoft Access database do not support
the use of the Recordset property. For more information regarding the
workaround of this issue, please refer to the following article:

287437 ACC2002: Run-Time Error 2593 When You Set or Retrieve the Recordset
http://support.microsoft.com/?id=287437

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.