DIVINEDAR0956
IS-IT--Management
I have searched everything I can possibly search and I don't really know how to explain this.
I would like to change the data or replace the data in a column with other data. I know I can use edit and paste but what I would like to do is have a code to attached to a button that when clicked it will ask you to put in the number you want to replace with the information you want to replace it with. Such as Replace P0026 with P0053. Say I have 4 tables and this information is all 4 tables in 1 column with the same field heading such as Project Number. Project Number being the key field.
Please help.
I would like to change the data or replace the data in a column with other data. I know I can use edit and paste but what I would like to do is have a code to attached to a button that when clicked it will ask you to put in the number you want to replace with the information you want to replace it with. Such as Replace P0026 with P0053. Say I have 4 tables and this information is all 4 tables in 1 column with the same field heading such as Project Number. Project Number being the key field.
Please help.