The problem is that there are quotes in the error message.
Use: Replace(Err.Description,"'","")
This will remove all of the single quotes in the Err.Description - this is causing the query not to run.
The problem is that there are quotes in the error message.
Use: Replace(Err.Description,"'","")
This will remove all of the single quotes in the Err.Description - this is causing the query not to run.
Tried this too..still the same.
See post # 20.
It worked now .. I have changed the table column format to for Err_Num and used Replace(Err.Description,"'","") and its printing both column.
Thanks a lot.
Glad to hear it, well done!