Reversing Case of eRR.function

[Chris Freeman]

hello all,
I have a bizarre issue here: I was working on coding, and click something,
and now, all of my Err functions display as eRR.Number or eRR.Description,
instead of Err.Number or Err.Description.

I thought I saw some box popup at the time of the incident, but clicked OK
before I realized what was going on, and now I have this issue.

How can I revert back to the normal default setting here?

Thanks

 

[John W. Vinson]

hello all,
I have a bizarre issue here: I was working on coding, and click something,
and now, all of my Err functions display as eRR.Number or eRR.Description,
instead of Err.Number or Err.Description.

I thought I saw some box popup at the time of the incident, but clicked OK
before I realized what was going on, and now I have this issue.

How can I revert back to the normal default setting here?

Thanks

Sounds like you may have a Dim eRR As... somewhere in your code and it's
autosensing it.

 

[Chris Freeman]

John,
I searched the entrie project for eRR. and found nowhere that it was
declared as such. I also tried doing a Find/Replace to change from eRR. to
Err., and it simply reverted back after the process. And it does this for
every Err. function, even ones that I'm not using. This is really wierd.

 

[Marshall Barton]

I searched the entrie project for eRR. and found nowhere that it was
declared as such. I also tried doing a Find/Replace to change from eRR. to
Err., and it simply reverted back after the process.

I haven't seen this in a long time, but sometimes these
things stick even after you remove the line that caused it.
Try inserting a Public Err statement in a module and see it
that fixes it. Then delete the statement.

 

[Chris Freeman]

Marshall,
Bingo! That corrected the error.

Thanks

 

[John W. Vinson]

Marshall,
Bingo! That corrected the error.

Thanks

Wierd! Thanks, Marsh for posting the resolution, and Marshall for verifying
that it worked. Now all I need to do is remember it for when it comes up
again... <g>