By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,301 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

How to remove reference to deleted field

P: 10
I was creating fields on the table of my database. I accidentlly named a field, "MonthNAme" I now need the function, "MonthName".
I deleted "MonthNAme" from the table, however VBA still has a reference to it as a textbox.

I created a new database and imported the information, however i still have the same problem. Is there anything i can do to resolve this?

Please help.
Nov 12 '08 #1
Share this Question
Share on Google+
1 Reply


missinglinq
Expert 2.5K+
P: 3,532
I deleted "MonthNAme" from the table, however VBA still has a reference to it as a textbox.
Still has a reference to it where? VBA would indicate it's in the code module. From the code module of any form, run Find using

MonthNAme

as the search term.

Under "Search Options" select "Current Project."

Remove the references.

If it's involved in any queries or reports remove it.

If there are textboxes on forms that have it set as the Control Source, delete them.

And please, use a thread title that gives some clue as to the actual problem. I'll change your title now. This allows others who may have similar issues to search the site for help.

Welcome to Bytes!

Linq ;0)>

Moderator
Nov 12 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.