Re: Access 2000 and VB 6

From: Brendan Reynolds (brenreyn)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 20:22:22 -0000

Well, the reason why is that the feature was not added to reports until a
later version of Access. It's in Access 2003, I'm not sure about Access
2002, but it is definitely not in Access 2000.

If upgrading is not an option, you could assign the SQL string to the
RecordSource property instead, but the MDB will need an ODBC link to the
Oracle data for that to work. 

-- 
Brendan Reynolds (MVP)
"dauster" <dauster@discussions.microsoft.com> wrote in message 
news:90FF12F0-2314-4DB9-8710-712866761BFB@microsoft.com...
> Using VB6, I create a ADODB connection to an Oracle 8i database. The I 
> open a
> recordset based on an SQL string. Now, how can I show the data in the
> recordset in an ACCESS report?
>
> I can display the data in an ACCESS form but setting the form's record
> source to the recordset but can't for the ACCESS report. Why?
>
> Thanks!

Relevant Pages

  • Re: ADP report based on stored procedure.
    ... sylvain aei ca (fill the blanks, no spam please) ... report to a recordset; however, there have been reports of people having ... that is based on a ado recordset. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Modify a SQL Expression Field from Visual Basic
    ... though I can view data in the report. ... Dim sResult As String ... ' 'SetPrivateData sets the recordset data to the report in memory ... Crystal Report Engine 8.0 Object Library, ...
    (microsoft.public.vb.crystal)
  • Dynamate report creation....help
    ... I have the following code to generate an Access report based on an Acsess ... time with 26 columns and 200 rows in the recordset before I killed the print ... Dim RptRS As Recordset ... Private Sub Detail1_Format ...
    (microsoft.public.access.reports)
  • Re: ADP report based on stored procedure.
    ... sylvain aei ca (fill the blanks, no spam please) ... set it dynamically in the OnOpen event of the report: ... that is based on a ado recordset. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADP report based on stored procedure.
    ... Put public variables in your report and use them as the source for your ... Private Sub Report_Open ... that is based on a ado recordset. ... in VBA during the open event of the report. ...
    (microsoft.public.access.adp.sqlserver)