Display access query output in a text file - notepad

Question

How can I display the outout of a query in a notepad on button click in access?

I have a button "View Query Output" in access. I want to be able to display the ouput in a notepad file. How can I do this?

Thanks in advance

Fionnuala · Accepted Answer · 2012-02-24 20:57:41Z

2

You can use DoCmd.TransferText to save the output to a textfile and FollowHyperlink to open the file.

answered Feb 24, 2012 at 20:57

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user793468 Over a year ago

Would you happen to know why using the following command deletes my file: TestFile.txt? Dim Test_File as string Test_File = "C:\Users\Documents\TestFile.txt" DoCmd.TransferText acExportFixed, "Test_Specification", "Test_View", Test_File

Collectives™ on Stack Overflow

Display access query output in a text file - notepad

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related