Microsoft Office Access cannot find the field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have an access database created using Office 2003 which has multiple forms
and tables. One particular button control on a form contains code that opens
another form for entry of notes related the current project record on the
first form. All this data is located in the same table but just entered from
different forms. The wizard was used to create the button control. Yesterday
day we were testing the button control and entering notes for each individual
project. Half the day this working properly. Then we began to get an error.

Microsoft Office Access cannot find the field 'Text227' that is referenced
in your expression.

Upon looking at the code - both the form name and Text227 were incorrect. I
changed them to what they should be and now all works fine. The developer
assures me that she did not change this code yesterday.

My question is - Has anyone seen any quirks like this before? My three
hypotheses are 1.) the files on the server were refreshed to an earlier
version (probably not the case because no-one is complaining of lost data)
2.) Corruption caused by a machine error or virus. 3.) Someone decided to
change things up a bit and purposely changed the code.

Any other suggestions?? Any comments or suggestions are welcome!
 
MorningStarFan said:
We have an access database created using Office 2003 which has multiple forms
and tables. One particular button control on a form contains code that opens
another form for entry of notes related the current project record on the
first form. All this data is located in the same table but just entered from
different forms. The wizard was used to create the button control. Yesterday
day we were testing the button control and entering notes for each individual
project. Half the day this working properly. Then we began to get an error.

Microsoft Office Access cannot find the field 'Text227' that is referenced
in your expression.

Upon looking at the code - both the form name and Text227 were incorrect. I
changed them to what they should be and now all works fine. The developer
assures me that she did not change this code yesterday.

My question is - Has anyone seen any quirks like this before? My three
hypotheses are 1.) the files on the server were refreshed to an earlier
version (probably not the case because no-one is complaining of lost data)
2.) Corruption caused by a machine error or virus. 3.) Someone decided to
change things up a bit and purposely changed the code.

Any other suggestions?? Any comments or suggestions are welcome!
Click to expand...

The possibility of that kind of problem is one of the primary reasons
compiled MDE files were introduced (along with split front-end/back-end
databases).

You may well need to go in that direction with this database ASAP.
Otherwise, children will play...and things may go bump in the night.
 
Back
Top