ibeling
asked on
binding a ADODB Recordset to a report
I like to bind a adodb recordset to a report in VBA.
ASKER
Sorry i forget to say explicit that this report is a ms-access report (VBA).
So your advise will not help.
Regards Ingo
So your advise will not help.
Regards Ingo
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe this example can help:
http://www.freevbcode.com/ShowCode.asp?ID=6335