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

Access Report to ADO recordset..

P: n/a
Is there any way at all in Access 2003 to bind a report to an ADO recordset?
The closest I've come so far is to use a pass through query that gets a
table based UDF- but that's still not optimal since it's a pain to use
paramaters.

Thanks.

--
Matthew.Wells
Ma***********@FirstByte.net
Aug 29 '08 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Yes. Use an ADP.

It's a pain to use parameters? Not here in Canada! With the snow, and
the wild beasts and Stevie Harper and Alberta one never notices the
pain of using parameters, which is so small in comparison. Or maybe
there isn't any.

I guess this is top secret and if you told us what you REALLY want to
do you'd have to kill us, eh?

Did I mention Celine Dion?
On Aug 28, 10:10*pm, "Matthew Wells" <Matthew.We...@FirstByte.net>
wrote:
Is there any way at all in Access 2003 to bind a report to an ADO recordset?
The closest I've come so far is to use a pass through query that gets a
table based UDF- but that's still not optimal since it's a pain to use
paramaters.

Thanks.

--
Matthew.Wells
Matthew.We...@FirstByte.net
Aug 29 '08 #2

P: n/a
You had to bring up Celine didn't you?
Aug 29 '08 #3

P: n/a
So how does this help me with a REPORT???
"lyle fairfield" <ly************@gmail.comwrote in message
news:f7**********************************@w7g2000h sa.googlegroups.com...
Yes. Use an ADP.

It's a pain to use parameters? Not here in Canada! With the snow, and
the wild beasts and Stevie Harper and Alberta one never notices the
pain of using parameters, which is so small in comparison. Or maybe
there isn't any.

I guess this is top secret and if you told us what you REALLY want to
do you'd have to kill us, eh?

Did I mention Celine Dion?
On Aug 28, 10:10 pm, "Matthew Wells" <Matthew.We...@FirstByte.net>
wrote:
Is there any way at all in Access 2003 to bind a report to an ADO
recordset?
The closest I've come so far is to use a pass through query that gets a
table based UDF- but that's still not optimal since it's a pain to use
paramaters.

Thanks.

--
Matthew.Wells
Matthew.We...@FirstByte.net

Aug 29 '08 #4

P: n/a
One more time.
Is there any way at all in Access 2003 to bind a report to an ADO
recordset?
Yes. Use an ADP.

On the other hand if you described what you are REALLY doing, maybe
there are other solutions.

And parameters are simple and IMO, their use is not eminently
whineable.
On Aug 29, 9:07*am, "Matthew Wells" <Matthew.We...@FirstByte.net>
wrote:
So how does this help me with a REPORT???

"lyle fairfield" <lyle.fairfi...@gmail.comwrote in message

news:f7**********************************@w7g2000h sa.googlegroups.com...
Yes. Use an ADP.

It's a pain to use parameters? Not here in Canada! With the snow, and
the wild beasts and Stevie Harper and Alberta one never notices the
pain of using parameters, which is so small in comparison. Or maybe
there isn't any.

I guess this is top secret and if you told us what you REALLY want to
do you'd have to kill us, eh?

Did I mention Celine Dion?

On Aug 28, 10:10 pm, "Matthew Wells" <Matthew.We...@FirstByte.net>
wrote:
Is there any way at all in Access 2003 to bind a report to an ADO
recordset?
The closest I've come so far is to use a pass through query that gets a
table based UDF- but that's still not optimal since it's a pain to use
paramaters.
Thanks.
--
Matthew.Wells
Matthew.We...@FirstByte.net
Aug 29 '08 #5

P: n/a
rkc
On Aug 29, 9:07*am, "Matthew Wells" <Matthew.We...@FirstByte.net>
wrote:
So how does this help me with a REPORT???
What? Celine Dion doesn't help?
Aug 29 '08 #6

This discussion thread is closed

Replies have been disabled for this discussion.