Can't Find Field

[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

 

[Rob Oldfield]

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.

 

[JamesJ]

I'll use Run, Reset the next time it occurs and
see what happens.

Thasnks,
James

 

[John Vinson]

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

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]