Can't Find Field

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

Can some one please explain why this happens. I'm aware of
the remedy (decompile).
I misspell the name of an object on my form and Access, of
course, can't find it. I go to the debug window a make
the necessary changes and then click File|Save dbname. But,
Access doesn't seem to know that the spelling is correct. I continue
to get the same error until I decompile. Is this a bug???? Seems to me
Access should realize that the correction has been made. It just
gets to be a bit annoying.

James
 
That doesn't sound good. The decompile option is (or should really be) only
something to be used in exceptional circumstances. Could you explain
exactly the process that you're using - it sounds like you're doing
something a bit wrong.

One thing that it sounds like you may be doing, that isn't a good idea: if
you're running a db and the code crashes, then you should halt all code
(Run, Reset in A2K) before making any corrections. Correcting code while
it's still live might lead to your problem.
 
Can some one please explain why this happens. I'm aware of
the remedy (decompile).
I misspell the name of an object on my form and Access, of
course, can't find it. I go to the debug window a make
the necessary changes and then click File|Save dbname. But,
Access doesn't seem to know that the spelling is correct. I continue
to get the same error until I decompile. Is this a bug???? Seems to me
Access should realize that the correction has been made. It just
gets to be a bit annoying.

James
Click to expand...

Try turning off 'Name Autocorrect' in the database's Options. It's
horribly buggy and this sounds like part of the problem.

You should also use Debug.... Compile <project> after any editing of
VBA code, prior to running it. This isn't decompiling, it's compiling,
and should be done before you Save.

John W. Vinson[MVP]
 
Back
Top