OK, here's what I'd like to do. I want to generate an error handler for a button on a form. As it stands I can't get a DoCmd.RunSQL command to work, to write it to a table, so now I'm looking at Write#.
OK, here's the code ...
Open "C:\Error Log.txt" For Output As #1
Write #1, "Error occured at " & Now()
Write #1, "Error with Exec Summary, " Err.Description
Now what I'd like to do is concatenate errors, so that the files grows in size and never over-writes data. The reason for this is multiple queries run for over night processes and I need to know if there are any errors on any of them.
Right now the Write over-writes the errors before.