Mass change to field found in reports, etc.

[mjwillyone]

Years ago I created an Access database that holds employee information. There are multiple reports, queries, etc. I am working on a project and realize that I was not very smart in giving some of my database field names two words (i.e. First Name, Last Name, etc.). I should have used an underling (_) to connect the two words. I cannot proceed with the work I am now doing until I get the field names in the reports, queries, etc. changed. I have changed one of the field names in the table but that is the only one.

I am wondering if there is a way that I can create some VBA or other code that will basically do a search/replace so I will not have to find all the places where the code needs to be changed. One field in particular would be a bear to update manually. It is a field that is often used as a sort criteria for reports, etc.

Thank you for your help,
Mike

 

[workmad3]

have you tried putting square brackets around the field names? i.e. [Field Name] as thats the standard way of getting a space recognised as part of the field name in access.

 

[mjwillyone]

Actually, I am attempting to link the database into another application and the other application gives errors due to the two-word field names. That is why I am wanting to change the field names to one-word instead.

Thanks

 

[mjwillyone]

Pat,

Thanks for the insight. I was able to locate a simple but effective search/replace add to MS Access at:

http://www.freewarefiles.com/program_10_109_7251.html

Thank you so much .. this will save me countless hours!

Mike