How to read a Recordset into a table/form/report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a recordset from a ActiveX control. Now I want to save the recordset
into a table and display it using a form/report. The table, Form, and Report
are created in run-time. How to do it? Thanks for any help.

Yolande
 
Unlike some other applications, Access works best when objects are created
in Design View and not at run time.
Assuming that your ActiveX control always returns a recordset in the same
format, you can "pre-create" the table.
When you need to fill it from your recordset, simply run a delete query to
empty out its current contents, then step through your recordset row by row,
appending data to the query.
You can also "pre-create" your form and report, and bind these to the table.

HTH
- Turtle
 
Back
Top