Re: Access 2000 and VB 6

From: dauster (dauster_at_discussions.microsoft.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 13:25:04 -0800

That's what I thought. Thanks for the reply. So, I should just use a DBO
instead of ADO so the report recordsource can understand the SQL.

"Brendan Reynolds" wrote:

> 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: Report the current filtered records from a Form
    ... It's still Access applying the filter, that's why it's in that format. ... Access 2002 front-end using SQL Server 2000 (MSDE ... The form has a <print report> button which should trigger a report ... based on that filtered recordset -- this does not work. ...
    (comp.databases.ms-access)
  • Re: Emailing a Report
    ... the reason Debug.Print was done was to test the SQL of what is being generated. ... If you will add and change data here, you need to set this up as a main/subform -- or just a main form that DISPLAYS data from Users and allows modifications to Agreements. ... If you are just going to send Agreements, then AgrID should be added to the form RecordSet so you can capture it. ... maybe also some kind of category for this followup type ...
    (microsoft.public.access.modulesdaovba)
  • Re: What is the advantage of Event programming?
    ... >> dice what lumps of data you need. ... which wouldn't work if the recordset has more than ... >My knowledge on using SQL statements is somewhat limited. ... Requesting a limited number of records at a time, was useful in the old days ...
    (microsoft.public.vb.general.discussion)
  • Re: REPOST: One Web Service updates SQL, the other cant
    ... insert is executed a reference to rs.eof is invalid and the program bombs. ... > get recordset back and ADO could generate error here. ... Another instance of the same Web Service code, ... >> Watching both the debugger and the trace, SQL is receiving what I send ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Vs Recordset
    ... I can run the SQL using DoCmd.OpenQuery "Qdf.SQL" method and at the same ... How can I refer to a recordset in the form or report? ... >> may need to create many version for different qrydef. ...
    (microsoft.public.access.modulesdaovba)