displaying recordset results from VBA

[Greg Bale]

Hi.

(this is s repeat post from MS community newsgroup)

I am building a form for people to use to analyse the data
in my Access2000 database. The SQL is built up in VBA
depending on control values set in the form. How do I
display the resulting recordset to the user? I have used a
create-table query and then used DoCmd.OpenTable but I
would also like to view crosstab results.

I am using DAO at present. Is their a method that will
give a datasheet-like view for a Recordset? Might I have
to build a form using the field list from the recordset
and then copy the recordset into the form?
Cheers,

Greg

[Greg Bale]

Hi Gunny.

Thanks for your reply. I thought there was something I could you do
with QueryDefs but the Office2000 disc2 in not installed on my machine
so I don't have the help files!

Thanks again,

Greg

['69 Camaro]

You're welcome, Greg.

The Help files for Access are on Disk 1 of the 2-CD set, but IIRC, one needs
to specify inclusion of the Help files during the "custom installation" to
get the whole works. But most of us who have used Access 2K Help will admit
that finding information in Help was often nearly impossible, so you aren't
missing much, other than the frustration.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Greg Bale" <gr*******@tesco.net> wrote in message
news:86**************************@posting.google.c om...

Hi Gunny.

Thanks for your reply. I thought there was something I could you do
with QueryDefs but the Office2000 disc2 in not installed on my machine
so I don't have the help files!

Thanks again,

Greg