- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
returns the following in Immediate Window
Sub t() On Error Resume Next Debug.Print "1)", CurrentDb.OpenRecordset("select id from table1")(0) If Err <> 0 Then Debug.Print Err, Err.Description Debug.Print "2)", CurrentDb.OpenRecordset("select id, x,y from table1")(0) If Err <> 0 Then Debug.Print Err, Err.Description End Sub
Q): Is there a way to extend somehow the output to, say,
1) 5 3061 Too few parameters. Expected 2.
Although it is irrelevant to the question I illustrate it with a "live" example.
1) 5 3061 Too few parameters. Expected 2 ([x],[y])
|Error message when attempting to run query||14||28|
|Need to Create a PDF file from a MS Access Report||10||27|
|Query output to Excel producing error||7||33|
|Trying to develop input form for time clock database||15||19|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!