Help Please -> VB Code: Replace Main Row if a part is Unapproved or Obsolete
I have an access table that I download from a specific site that looks like the one that I attached. The problem is the format of the table. I want to write a code that will replace the main row of the PART NUMBER if the PART STATUS is Unapproved OR Obsolete to an Approved Part Name row. You will see that the some of the PART NUMBER field are left blank. It means that it is the same as the PART NUMBER on top of it.
I have an access table that I download from a specific site that looks like the one that I attached. The problem is the format of the table. I want to write a code that will replace the main row of the PART NUMBER if the PART STATUS is Unapproved OR Obsolete to an Approved Part Name row. You will see that the some of the PART NUMBER field are left blank. It means that it is the same as the PART NUMBER on top of it.
Last edited:
