Whereis this location?

[Lou_Reed]

When using Vtools, I did a search on txtattendancePercent and it came up with two instances.



That is fine.

What I do not understand is the location in the second instance.

It lists this location as EventProcPrefix. Uh where is that location?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[ranman256]

i dont know what youre talking about.
are you seaching thru code for a textbox in forms?
are you query search for data in a field?

[Lou_Reed]

This is a VTools search for txtAttendeancePercent in my current db. This is where two instances oftxtAttendeancePercent were found. One of them is easy, but the second one is not.

I have no idea where that location is.

That is the reason for his posting.

Respectfully,

Lou Reed

[jwhite]

Like ranman... You've asked a question about something we cannot see.

Perhaps it is related to the EventProcPrefix Property: https://support.office.com/en-us/art...2-14cf7c6af63f

Did you search your code for EventProcPrefix?

[ranman256]

since VTools is not an access app, there's no telling. The app should provide this info.
if not, you could try seaching in the vbe window for txtAttend and see if you get hits.

[Lou_Reed]

I will take your advice. V Tools has been very helpful to me. I could search on that term.

Thanks.

Respectfully,

Lou Reed

[HiTechCoach]

If you are not familiar with V-Tools, it is a free Access add-in (Access database) that adds addition functionality for developers.

See: V-Tools (Click Here)

[Lou_Reed]

I searched on the terms above using V-Tools. Nothing of any importance came up.

I will try and find out other ways.

Thanks for your help.

Respectfully,

Lou Reed

[HiTechCoach]

It lists this location as EventProcPrefix. Uh where is that location?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

Lou,

I will try to help.

That location will probably be in the VBA code "behind" the form the has or previously had a text box named txtattendancePercent. Try looking at the properties for the control txtattendancePercent. Do you see any events that have [Event Procedure].

FYI: If you delete or rename a control that has VBA code in an event, the code gets orphaned (detached).