N
Naz
Hi all
I have a employee database that i have created. Each employee record has a
reports field with the name of their manager.
But if a manager changes i have to manually go into the employee table and
do a find and replace, changing all the old managers name to the new manager
name.
So i would like to create a form with 2 drop down lists, both showing list
of all employees from the same table. From the first field i would select the
current (find) manager and the second one i would select the replacement
manager. Click on a button and Access would do a find and replace type
function.
Would i do this as a macro trying to do a find/replace in the table, or am i
suppose to use a different method. I am ok with forms, dropdown lists and can
do basic VBA, but if someone could point me in the right direction that would
be fab.
Regards
____________________________
Naz
London
I have a employee database that i have created. Each employee record has a
reports field with the name of their manager.
But if a manager changes i have to manually go into the employee table and
do a find and replace, changing all the old managers name to the new manager
name.
So i would like to create a form with 2 drop down lists, both showing list
of all employees from the same table. From the first field i would select the
current (find) manager and the second one i would select the replacement
manager. Click on a button and Access would do a find and replace type
function.
Would i do this as a macro trying to do a find/replace in the table, or am i
suppose to use a different method. I am ok with forms, dropdown lists and can
do basic VBA, but if someone could point me in the right direction that would
be fab.
Regards
____________________________
Naz
London