[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Error #0 and VB

I am getting an Error #0 msgbox when loading a form that is connecting to a SQL DB and getting Recordsets.  If I click ok, the form opens fine.

I cannot figure out why I'm getting this error?

Any ideas?

0
baddogi
Asked:
baddogi
  • 2
1 Solution
 
RichWCommented:
Look at the error handler in the form.

What is most likely happening is that an error is raised,  and the Error object is getting reset prior to displaying the error value.  

Check your error handling code.
0
 
amebaCommented:
You forgot "Exit Sub" or "Exit Function" before error label.

Sub SomeSub()
     On Error GoTo EH
     '...
     '...
     Exit Sub          '  <<<< this is missing
EH:
     ShowError
End Sub
0
 
RichWCommented:
ameba is correct.  That could also be it.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now