viewing recordset reults from vba

  • Thread starter Thread starter gregb
  • Start date Start date
G

gregb

Hi.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine position in query recordset 1
query a recordset 2
recordset vs collection 2
Simple Question? 4
query delay 2
Recordset automatically updates 2
Loading recordset at runtime 4
SQL query to Access database 5

Back
Top