Compile error: variable not defined (VB Adodb)

Question

I had a code, which was running perfectly fine yesterday, but now it stopped working and throwing this error:

I have checked my references, and my activeX box is checked:

I am really stuck. What am I doing wrong? Do I need to update something?

Not sure why you think this has anything to do specifically with ActiveX?I would suggest declaring the variable, perhaps Dim objMyConn. "Something" changed since yesterday. If you're not sure, compare to your backup copy (hint hint) :-) — ashleedawg
– ashleedawg, Commented Jul 14, 2018 at 22:45
Probably that you added Option Explicit at the top of the module... — Miqi180
– Miqi180, Commented Jul 14, 2018 at 22:51
You'll notice then, that when you insert a new module, it automatically says Option Explicit at the top. My guess is you that pasted existing code into another module today. Anyway, case closed and happy coding. — Miqi180
– Miqi180, Commented Jul 14, 2018 at 23:16
Perhaps compromise by starting to declare your variables so you don't make matters worse when you have time to start using Option Explicit and other 'best practices'. — user4039065
– user4039065, Commented Jul 14, 2018 at 23:37

Miqi180 · Accepted Answer · 2018-07-14 23:25:04Z

6

This type of error typically emerges after adding Option Explicit at the top of a module, or after pasting working code without explicitly defined variables into a new module with Option Explicit at the top.

Go to Tools > Options > Editor Tab and see if the checkbox for "Require Variable Declaration" is ticked. This is what Option Explicit does.

answered Jul 14, 2018 at 23:25

Miqi180

1,7011 gold badge18 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compile error: variable not defined (VB Adodb)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related