Recent content by AHendriks
-
A
No errors for query in form
Bilbo, What do you mean by a test of conditions? In ADO various objects have an errors collection, but not so in DAO, which is still used by Access. André -
A
No errors for query in form
The code for the error handlers looks like this: Private Sub cmdCreate_Click() On Error GoTo Err_cmdCreate_Click ... omitted sub body Exit_cmdCreate_Click: ... omitted clean up code Exit Sub Err_cmdCreate_Click: MsgBox "Error: " & Err.Number & " " & Err.Description... -
A
No errors for query in form
Rabbie, The queries are stored as parameterized queries in MS Access or generated on the fly. Examples: Set qryAppendSampleSel = db.QueryDefs("qryAppendSampleSel") qryAppendSampleSel.Parameters("LocGroup") = strLocNetw Set rstAppendSample =... -
A
No errors for query in form
Rabbie, The error shown varies. Even when the query is not well formed (like 'SELECT & FROM table', where the & should have been a *) I get no error, just an empty recordset. Thus I am forced to check each generated query (depending on user settings) in the query builder or by running the same... -
A
No errors for query in form
"Bilbo", Yes there are error handlers defined. But they all DO display the error message. And by setting breakpoints on their entry point or by stepping through the code I can see they are not entered. When stepping through the code and checking all possible error variables just after executing... -
A
No errors for query in form
When executing queries from within the code behind an MS Access form (using linked tables linked to a MS SQL Server database), no error :mad: is generated if something is wrong with the query. The same query executed from a query builder window in MS Access will tell me what's wrong (syntax...