Save as report

[rrhandle]

I have a piece of VBA code that loops through the database, finds the information it is looking for, then saves the search results to a text file named C:\Search.txt.

My question: Is it possible to have this text saved as a report, and have the report automatically open?

Thanks

--Rob

 

[CautionMP]

Yes.

Format [tt]Search.txt[/tt] in a standard format (like CSV), create a linked table that points to [tt]Search.txt[/tt], build a report based on the linked table, use the [tt]OutputTo()[/tt] method to generate a file (Sanpshot format), use the [tt]CreateObject()[/tt] to spawn an instance of the newly created and saved report?

 

[Cloonalt]

Link to your .txt file using File, Get External Data, Link Tables and create a report from it.

Create a new blank form in Access, and open it in design view. Select the toolbox on the Tools menu and drop a command button on your form, following the wizard for "Report Operations". That will give you the code to open a report from a command button.