I have a form for the Access database that filters the records and writes to a .txt file in the "C:\Temp" folder.
At the end of the program, after I close the recordset and db objects, I want the macro to display the text file on the screen.
Then I can copy and paste the results in an Excel worksheet.
I am not finding the method Application.OpenTextFile in Access. There must be a simple solution for this but I could not get it from the internet.
There is a ton of info on reading, writing or appending to a text file by the FileSystemObject and TextStreams, but I need the file just to be displayed.
Can someone show me the direction how to do it?