SOLVED: Left(quan) something's corrupted?

[markcrobinson]

I've been running a vb application I wrote for several months now.
Suddenly, when I run it, I get an error:



It's erroring on compile a simple "left" statement.
I go into the immediate panel typing ? Left("abcd",2) and get the same error. ? RIGHT("abcd",2) works fine
I notice, as I'm typing the command, the suggestion is wrong.






Troubleshooting:
I close my application, open a blank database, and it's fine. My access program isn't corrupted

So there is something in my application (just a bunch of vb scripts, tables, and queries) that is changing the format and meaning of the LEFT command. I've disabled my startup switchboard, done a compact and repair database, checked my form startup code. I'm lost.

Does this make sense to anybody?

[moke123]

Any missing references in the VBE?

[ranman256]

Also,if your db gets close to the limit of 2gig,weird errors like that will happen.
but ,most likely it's a missing reference.

[June7]

This is vb.net or VBA?

[markcrobinson]

Thanks. Checked, but no missing references.

[markcrobinson]

Its VBA. I've got a bunch of tables and queries and vba code to manage them.

[markcrobinson]

Small file 75k

Another quick data point...
As soon as I open the database -- before running anything, the error exists (identified by typing Ctrl-G and Left( then seeing Left(quan come up as the suggestion).
If I then File->close the database and hit Crtl G, when I type Left( or Right( no suggestion appears.

Can't even see how to troubleshoot this.... May try opening a new database and importing components from the "corrupted?" one.

Or I may eat a gummy bear and watch Arrested Development again...

[markcrobinson]

OK, I'm just posting this in the unlikely event that anyone does something so stupid as to cause an error like this, and to prostrate myself in deft apology to those helpful people who truly know how to program.

Stuck in the middle of my code somewhere was

______________
Function Left(quan)

End Function
_______________

Have no idea how it got there -- perhaps and errant paste or Access trying to autocorrect an unfinished line by making it a function. Interesting, though, how it allowed me to redefine a built-in function like Left(. I wonder if I can use that....

For any fellow idiots that follow me down this path of corruption and find this thread, to troubleshoot I created a new database, imported components of the original until I imported the errant module. Each time typing Left( to see if the weird hint occurred. In the module that triggered it I Cut one half, then the other, until I narrowed it down.

If I die from eating too many gummy bears, please tell my grandchildren that I was killed by bears.

[moke123]

That is actually another possible reason that comes up when googling your issue, having a sub/function with the same name.