Search results

The behaviour i wanna achieve when the txtEmpNo is invalid is to return back to txtEmpNo. not in txtName Note: The uploaded file is full of error :):p

Yes. Same form. errHandler: If Err.Number = 3021 Then MsgBox "Invalid Employee Number!" & vbCrLf & _ "Please check the number again.", vbOKOnly + vbInformation, "Message" 'DoCmd.GoToControl "txtEmpNo" Me.txtEmpNo.SetFocus Else MsgBox "A...

errHandler: If Err.Number = 3021 Then MsgBox "Invalid Employee Number!" & vbCrLf & _ "Please check the number again.", vbOKOnly + vbInformation, "Message" DoCmd.GoToControl "txtEmpNo" Else MsgBox "A problem occurred when trying to retrieve the...

Much better. Thanks!

Thanks! But what's the channel? can't view the link because of the restriction - Post Count < 10

I'm kinda good in video tutorials, do you guys have resources for such?

Hi guys! I'm learning MS Access VBA. May this forum be of help.. :o