468,509 Members | 1,335 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,509 developers. It's quick & easy.

Access Report to ADO recordset..

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
5 4641
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
You had to bring up Celine didn't you?
Aug 29 '08 #3
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
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
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.

Similar topics

5 posts views Thread by Tim Marshall | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.