How to search all possible places in a Form where a table column is used? (1 Viewer)

[darbid]

Hi all,

Access 2007 Front End / SQL Server Backend.

I have to change a few column names in my Tables. I am looking for an easy way to check all the places where this column name is used. In VBA modules i can search for its usage, but is there a way to search if the column is used in a form in one of its fields or if its used in a control?

At the moment the only way I know is to simple make the table column change and then used all the controls to see where I get errors.

 

[jdraw]

darbid,
Haven't seen you for a while.

You could look in Form and report recordsources.
You could look in all query.sql

 

[Poppa Smurf]

You could use the Object Dependencies in the Database Tools menu. This will show you where the table is used in forms, reports, queries etc.then it is just a matter of checking the record source.

 

[spikepl]

dl v-tools