Disappearing Code

[Design by Sue]

I have an Access database which is split into a front end and back end (not
sure if that makes a difference) Anyway - as I work on the project, I make
frequent backups and it is a good thing! Periodicly the entire SQL coding
for one of the forms completely disappears. It is only one form that I have
a problem with. It is called InputFrm. I have noticed in my entering code,
sometimes Access auto corrects the spelling to the incorrect InPutFrm. Any
idea on what is causing either of these two problems and are they related?

Thanks
Sue

 

[Michael J. Strickland]

I have an Access database which is split into a front end and back end
(not
sure if that makes a difference) Anyway - as I work on the project, I
make
frequent backups and it is a good thing! Periodicly the entire SQL
coding
for one of the forms completely disappears. It is only one form that
I have
a problem with. It is called InputFrm. I have noticed in my
entering code,
sometimes Access auto corrects the spelling to the incorrect InPutFrm.
Any
idea on what is causing either of these two problems and are they
related?

Thanks
Sue

It sounds like some sort of corruption problem. You might try creating a
new,
blank form and copying all your form objects (and code) to the new form
and see if that solves the problem.



--

 

[Dale Fye]

Sue,

Recommend you turn off Name AutoCorrect. See Allen Browne's explaination:

http://allenbrowne.com/bug-03.html

 

[Design by Sue]

I have turned off Name AutoCorrect and recreated the database as described -
sure hope that solves the problem

thanks!

Sue