• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • 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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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