Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Creating a report based on a ADO recordset.

Posted on 2002-06-19
7
Medium Priority
?
448 Views
Last Modified: 2008-03-10
Is it possible, and if so how would you use an access report against an ADO recordset.  For example I have a peice of code that creates and populates an ADO recordset with all the data for a desired report.  Is it then possible to open a report, point the report to the ADO recordset and voila.
0
Comment
Question by:m_bizon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 8

Expert Comment

by:dovholuk
ID: 7093526
i didn't give it a go... but here's at least ONE site that claims to do just that....

http://www.programmingmsaccess.com/Samples/VBAProcs/VBAProcsToAssignAnADORecordsetToAReport.htm

i'll try it out and get back to you...

dovholuk
0
 
LVL 2

Expert Comment

by:Carlovski
ID: 7095330
I'm not sure if it is possible (It probably is, I just haven't tried it!)
My usual way of doing this sort of thing is to write the data out to a temporary table, and base the report on that (The advantage is that you can just bind the report to the table, and drag and drop your fields into the report) It can be a bit tricky in a multiuser situation though.
0
 
LVL 4

Expert Comment

by:wesleystewart
ID: 7095637
I believe in Access2002 you can bind a form or report directly to a recordset.

Wes
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 7

Expert Comment

by:Daniel Stanley
ID: 7097026
i think you can bind an ADO recordset to a form dynamically, but not a report.

drs66
0
 
LVL 28

Expert Comment

by:TextReport
ID: 7117336
Wes is correct in Access 2002 there is a recordset property that "Returns or sets the ADO Recordset or DAO Recordset object representing the record source for the specified form, report, list box control, or combo box control. Read/write."

In previous versions all people are doing is changing the recordsource so it requearies the database, probably not what you are wantiong to do.

Cheers, Andrew

0
 
LVL 54

Expert Comment

by:nico5038
ID: 7253755

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 7269919
Per recommendation, points NOT refunded and question closed.

Netminder
CS Moderator
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question