• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

binding a ADODB Recordset to a report

I like to bind a adodb recordset to a report in VBA.



0
ibeling
Asked:
ibeling
  • 2
1 Solution
 
vinnyd79Commented:
You need to set the DataSource property to the recordset.
Maybe this example can help:

http://www.freevbcode.com/ShowCode.asp?ID=6335
0
 
ibelingAuthor Commented:
Sorry i forget to say explicit that this report is a ms-access report (VBA).
So your advise will not help.

Regards Ingo
0
 
Ryan ChongCommented:
In Access, you can bind the Report with a Query, and you can do a Fitler then if necessary. To open an Access report, you probably need using the Docmd.OpenReprot method, like:

DoCmd.OpenReport "myReport", acViewPreview

for full syntax, you can refer to:
http://msdn.microsoft.com/library/en-us/vbaac11/html/acmthactOpenReport_HV05186500.asp
http://msdn.microsoft.com/library/en-us/modcore/html/deconworkingwithdocmdobject.asp

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now