Changed the name of a table and this happened

[Lou_Reed]

In the attached db file, when I try to open frmAttendance it fails. It claims that it cannot file tblAttendence. I have no doubt that it cannot find that table since that table was renamed tblAttendance. Note the spelling of the last syllable.

It will not find tblAttendence anywhere. I thought that I changed all the name from tblAttendence to tblAttendance. But I had apparently had not. I just cannot find where it has used tblAttendence.



Any help appreciated. Thanks in advance.


Respectfully,


Lou Reed

[Lou_Reed]

I have this one. Just by happenstance, I stumbled over some VBA code for frmAttendence and yes it had the old spelling of tblAttendence on it. I see that by changing the name of s field it changes there and in the queries. But it does not seem to change in the VBA code or anything else. Is there a way to get this to change the VBA code as well as all the rest say reports , etc.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

What a minute it did not change! I did change some VBA code which seemed to work. But now it does not. Trying to open frmAddMeeting everything is fine, then when I hit cancel on frmMeeting, I get ann error.

I am adding the db file to the post along with a screenshot of the offending VBA code for frmAddMeeting.


Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[June7]

Use a third party find and replace add-in utility, like Rick Fisher's Find and Replace for Access, cost $37. Saved my sanity more than once. Or freebie VTools.

[Lou_Reed]

Where can I find VTools?

Respectfully,

Lou Reed

[June7]

Google it. I never used, just seen it recommended in posts.

[jwhite]

Did you not try MZTools which I recommended several days ago?

[Lou_Reed]

I would love to try MZTools, but it only lasts for 30 days. I am not sure when to try it.

Respectfully,

Lou Reed

[Lou_Reed]

The proper name I believe is V-Tools, There are a lot of VTOOLS software out therein internet land that are not at all helpful. V-Tools is what you want.

FYI

Respectfully,

Lou Reed

[Lou_Reed]

Okay, after having looked for my old post where you told me what version of MZ Tools to download and not finding it.I have to ask again, what version of MZ Tools should I download that can be used with MS Access 2016?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, V-Tools is working very well. However, I do not know what it is telling me. I have included a printscreen pic
of the printout. Please interpret.

This tool is awesome.

What is it telling me?

Ay help appreciated.

Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

Okay, I have got three of them, but what are the others telling me? I am specifically referring to the first two lines as the result of deep search. In those the type - Doc/Sub Object is tblMeetingstblAttedence. for the first. What exactly are they talking about?

Respectfully,

Lou Reed

[jwhite]

Looks like it telling you the table names that are in the Relationships Diagram.

[Lou_Reed]

I thought that. It was not the case. That was too easy. I tried i and it did not work. The table name are tblAttendance not tblAttendence in relationship diagram.

That was the reason for this post. It seems logical. It was not.

R,

Lou Reed

[jwhite]

Well, you have the application, not me...