How to write to a text file in Access

[dave8]

I want to be able to create a text file in Access and write a message when an macro query is completed.
Is there a way to do something like this?

For example:

Query1
Do something
....
end query2
"Query1 has completed" < ----- This statement gets written to Text file

Query2
Do somehting
....
end query2
"Query2 has completed" <-------- This statement gets appended to Text file
Query3...
....

 

[dave8]

I'm trying to add the "Set Warnings ON/Off" but I can't find this statement in the AutoExec.
The dropdown list only has SetDisplayedCategories to SetTempVar. How do I add the Set Warnings ON in
the AutoExec?

 

[Micron]

Make sure you have selected "Show All Actions" on macro design Actions tab.

 

[dave8]

Is there a way when writing to the log file to keep the file open until the entire routine finishes, rather than opening and closing the file every time an error occurs?

 

[Micron]

Not sure I understand why you've asked that. As written, one error writes to the file and exits the function so the entire routine can't finish. You have modified the code to do something different? I covered this point in post 10, I'd say, which was to gather all errors and write once. Not sure, but I don't think you can write to the file when it's open, but that would be easy enough to test if that's your preference. To do that, move f.Close to just before exitHere. However, I believe you'd generate an error if f had not been already set (assuming that's still being done in the error handler), so just before f.Close I'd write On Error Resume Next. This error (if it occurs) would be ignored and allow you to exit. If you need further help, post the code you have so I can see how/if you modified it.

 

[dave8]

Yes, I was not thinking the logic correctly. I want to thank you very much for helping me understand Access. I really appreciate your help.

 

[Micron]

Glad to help. Good luck with your project.