Binding DataReport (in VB6) to custom recordset

    Question by:
    On

    Topics:

    I nave designed a report using DataReport designer in VB6 (NOT Crystal). This report is bound to some DataEnvironment in design time. I want to bind my report in runtime to my custom ADODB.Recordset (having just the same structure) How to do it?
    Good Question?
    0

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    Top Expert Contributor

    Essential articles and videos from the Experts

    Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

    More valuable questions with Expert answers

    Question: I have the following SQL Query and I need to change the Case Statement to get the minimum, average and max values based off of the Shareholder and Associate Titles (t.Description is the alias name for the Title Field in the SQLTable). There are...

    Answer: Hmm, not sure why MIN wouldn't work, it should be fine. I can see AVG getting "confused", so we can calc average ourselves: select CASE WHEN t.Description in ('Shareholder-Income','Shareholder-Equity') THEN 'Shareholder' ELSE...

    Question: Hi, I try to put Data Validation list to Z column of 1st sheet, based on the codes in Column A from 3rd sheet. I've saved the Excel book and then re-opened it but such Data validation list disappears to the cells. Why?

    Answer: Try saving the file as an xlsx or xlsm file

    Question: Would it be possible with help of VBA to create this function?: When I click inside an empty mini-circle, the cell becomes selected and the mini-circle becomes filled. The column width is only 1, so the mini-circle must fit into a cell with...

    Answer: Try this. Select any cell in F1:F10. The secret is that that column's font is Wingdings.

    Question: I have a need to develop some sort of desktop alert screen based on data in an MS Access database table. When a given table/field value would exceed > 100, for example, a desktop notification would pop-up asking the user to take action. Is...

    Answer: if the database is open, you can use a MsgBox (CODE)

    201601-LO-Qu-076

    Extend your technology team with the Experts Exchange community.

    — trusted by —

    Who answers my questions?Our community has technology experts around the world.

    Martin Liss

    16

    Articles

    2,256

    Solutions

    Expert in:

    • MS Excel
    • Visual Basic Classic
    • MS Office
    • VB Script
    • VBA

    Subodh Tiwari (Neeraj)

    736

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • Visual Basic Classic
    • MS Applications

    Robberbaron (robr)

    1,178

    Solutions

    Expert in:

    • MS Excel
    • VB Script
    • Visual Basic Classic
    • .NET Programming
    • ASP.NET

    chaau

    749

    Solutions

    Expert in:

    • MS SQL Server
    • MS Access
    • MS SQL Server 2008
    • Query Syntax
    • .NET Programming

    Roy_Cox

    310

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • VB Script
    • Visual Basic Classic

    Bill Prew

    3,632

    Solutions

    Expert in:

    • MS DOS
    • VB Script
    • Windows Batch
    • Scripting Languages
    • MS Excel

    Ejgil Hedegaard

    433

    Solutions

    Expert in:

    • MS Excel
    • VBA
    • MS Office
    • Spreadsheets
    • VB Script

    ☠ MASQ ☠

    6

    Articles

    8,777

    Solutions

    Expert in:

    • Computer Games
    • Hardware-Other
    • Windows XP
    • Components
    • Laptops/Notebooks

    Guy Hengel [angelIII / a3]

    11

    Articles

    37,332

    Solutions

    Expert in:

    • MS SQL Server
    • MS SQL Server 2005
    • Databases-Other
    • MS SQL Server 2008
    • MySQL Server

    RELATED TOPICS view all topics

    1. MS Excel
      (127,113)
    2. VB Script
      (35,970)
    3. MS Access
      (214,533)
    4. .NET Programming
      (130,873)
    5. Visual Basic.NET
      (91,309)
    6. MS Development-Other
      (47,891)
    7. Programming Languages-Other
      (19,530)
    8. Programming-Other
      (51,581)
    9. MS Office
      (56,511)
    10. MS Word
      (26,707)