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

displaying recordset results from VBA

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.