Access 2007 button click event error -
i have following code in access vba on button click event. idea use temporary variable forward value textbox subform:
private sub button_novi_ir_click() on error goto button_novi_ir_click_err on error resume next tempvars("brojrn").value = me.brojrntxt docmd.openform "podaci_o_izvrŠenim radovima_form", acnormal, "", "", acadd, acnormal if (macroerror <> 0) beep msgbox macroerror.description, vbokonly, "" end if button_novi_ir_click_exit: exit sub button_novi_ir_click_err: msgbox error$ resume button_novi_ir_click_exit end sub
each time click button error message "a problem occurred while ms office access communicating ole server or activex control". have no idea it. so, please can point me in right direction?
thanks in advance!
i don't know whether accented character in form name issue - i'll assume isn't. shouldn't supply empty strings "" filtername , wherecondition arguments, use commas skip these arguments ,,,
and code, not macro, should using err
object , examine err.number
, err.description
.
Comments
Post a Comment