By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Ca a collection be a rowsource for a report?

P: n/a
I generate a collection of errors from a procedure. I then show these
errors in a msgbox buy looping thru the collection and adding them to
a string called sMsg. in the msgbox, I ask the user if they would
like to print these errors. If they say yes, what is a way of
printing this list to the default printer, or better yet, create a
report that can be called with the collection as the record source.

Thanks in advance,
Adolph
Aug 11 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Mon, 11 Aug 2008 13:11:24 -0700 (PDT), adolph
<ad****@programconsultants.comwrote:

No, but I'm pretty sure that rather than using a collection you could
use an ADO Recordset. You can create one out of thin air, add a few
fields to it, add your rows to it, and use that recordset as the
RecordSource for a report.

-Tom.
Microsoft Access MVP

>I generate a collection of errors from a procedure. I then show these
errors in a msgbox buy looping thru the collection and adding them to
a string called sMsg. in the msgbox, I ask the user if they would
like to print these errors. If they say yes, what is a way of
printing this list to the default printer, or better yet, create a
report that can be called with the collection as the record source.

Thanks in advance,
Adolph
Aug 13 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.