Search results for query: *

SKIP: it doesnt go there...it goes to the NEXT LINE STRONGM: yes that is the code (my previosu post)

and...No...no msgboxes work after it fall into 'buggy mode'. Only fix is by restarting the application.

ok..here's the code Private Sub Compare(ByVal SQLString As String, ByVal SQLString2 As String) On Error GoTo error Dim cnDATA As ADODB.Connection Dim rsDATA2 As ADODB.Recordset Dim strConn As String Set cnDATA = New ADODB.Connection Dim QuestionMsg If DtbConnError =...

Private Sub Test() On Error Goto Error Dim Response as integer Response = MsgBox(Msg, Style, Title, Help, Ctxt) Exit sub Error: MsgBox "Error occured" End Sub this does the same behavior

no, there is no 'Resume Next' statement in the subroutine. I know it returns VbOk since the following returns always returns '1' Response = MsgBox(Msg, Style, Title, Help, Ctxt) Nothing is running in the background

when i single step....the msgbox doest execute visually and the code continue to the next line returning VbOk.

Private Sub Test() On Error Goto Error MsgBox "test" exit sub Error: MsgBox "Error occured" End Sub

Hi, i have this very strange problem that occurs SOMETIMES with a software where you can use vba code. When i run the code, msgboxes fail to show up and code is continuing through. I use this software (called RSView32 from Rockwell Automation) since couple of years now, and this is the first...