Access Report to ADO recordset..

[Matthew Wells]

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

[lyle fairfield]

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" <[e-mail]>
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
[e-mail]

[The Frog]

You had to bring up Celine didn't you?

[Matthew Wells]

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" <[e-mail]>
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
[e-mail]

[lyle fairfield]

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" <[e-mail]>
wrote:

So how does this help me with a REPORT???

"lyle fairfield" <[e-mail] 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" <[e-mail]>
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
[e-mail]

[rkc]

On Aug 29, 9:07*am, "Matthew Wells" <[e-mail]>
wrote:

So how does this help me with a REPORT???

What? Celine Dion doesn't help?