any transparent way to assign recordset to report ?

Z

Zlatko Matiæ

I'm sorry for repeating this question on the newsgroup again, but I didn't
receive any satisfactory response till now...
The question is the following: Is there any way to assign recordset (either
DAO, either ADO) directly to report.
It is quite easy to do it for forms (Me.recordset=rs), but it seems
impossible for reports. Is this true?

Zlatko
 
R

RoyVidar

Zlatko Matiæ wrote in message said:
I'm sorry for repeating this question on the newsgroup again, but I didn't
receive any satisfactory response till now...
The question is the following: Is there any way to assign recordset (either
DAO, either ADO) directly to report.
It is quite easy to do it for forms (Me.recordset=rs), but it seems
impossible for reports. Is this true?

Zlatko
Click to expand...


As far as I know, it is not available in mdb's, but only in ADP's.

Here's a quote from an ADO Whitepaper
"Using ADO Recordsets with Microsoft Access Reports

In Microsoft Access 2002, it is now possible to use ADO recordsets
with reports in Microsoft Access project files. Unfortunately, the use
of the report Recordset property is limited to project files. If you
try to
set or retrieve a report's Recordset property in a Jet database (.mdb)
file, you receive the following error message:

Run-time error '2593': This feature is not available in an mdb

Here's the whitepaper
http://support.microsoft.com/?kbid=301987

I did some experimenting in 2003, with the same results.
 
Top