CODE TO WRITE AN EXTRACT FILE AND TO POPULATE A FORM/REPORT

[Gemini07306]

Hello Tek-Tips professionals.
I need help in Access 97.
I have a table containing various fields. I know how to extract records in SQL/query design view.
QUESTION 1:
How can I write codes either in VB, SQL or Acces to produce an extract file (extract values from a table)?
QUESTION 2:
What codes can I use to populate a form/report, using the extract file produced above?
Please respond to gixtian@nyct.com or giftx@juno.com
Your response will be greatly appreciated.
Thanks,
gemini07306.

 

[jrbarnett]

Hi,

With regards to question 1:
The file handling commands that you need to look up in the help file are:
FreeFile
Open
Print #
Close

These are VBA functions that you will need to combine with a recordset object.

As for question 2, you will need to reload the data from your file back into an access table - or use an ODBC connection to a text file to retrieve it directly.
It will be easier to take the data straight from the table for your report or form.

John