Help - Field Name Not Found

[jtm013]

Hello,

So my desk is getting concave from me banging my head against it, so if this is a little difficult please bear with me.



So I have been assigned to 'fix' a sizable (aprox 25 mb at this writing) database. The person who created it and set it up had limited access experience and named every single field in the tables with at least one space in the name. This is driving me nuts as it makes coding things a nightmare. Subsequently I have started the painful process of trying to rename all the fields whilst keeping all the relationships happy and kosher.

I have one question and one problem.

The Problem-

the primary data table is called tbl_Data_Entry and originally the recordid field was labeled "Record Identification Field"
I have changed the name to RecordID, and as far as I can tell I have gone through every query, report, form, and module and made the requisite changes....but I still keep getting the error "Enter Parameter Value, Tbl_Data_Entry.Record Identification Field" Which seems to indicate to me that I must have missed changing the record name somewhere on something. This brings me to my question.

Is there a way using code to tell access to replace all instances of Record Identification Field with RecordID?

Any and all help would be appreciated.

[RuralGuy]

You may want to look into some of the "Find and Replace" utilities available. Google knows most of them. Here's one to start with: http://www.rickworld.com/products.html

[RuralGuy]

You might start with a Compact and Repair if you haven't done that yet. There is also a "Decompile" that can be helpful: http://www.granite.ab.ca/access/decompile.htm

[jtm013]

Find and replace utility, great idea!
I did manage to find the one lingering incorrect name.

Thanks for the assist! - Solved

[RuralGuy]

You're very welcome. Glad to hear you solved the issue.