With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
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])
|MS Access Define a New Field Name In A Query When Special Characters Are Used In The Field Name||14||29|
|How to remove the decimal places from a number field within an expression in Access 2010||4||25|
|Run-time error 429 - ActiveX Component Can't Create Object - VBA Code - MS Access - Adobe||4||22|
|How to use VBA to highlight a string within a text box in a MS Access form?||4||14|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!