Find Database & Update the table in Bulk Method

Hi Guys,

Good day!

I have a project here and I need your sweet helpful minds to make it finish. Im kinda struggle here.

I have a 14 columns on my database. I have here a code of FindAll Data and modified it and Add Data Entry/Update on it.

Here's the scenario; I need to search for a ticket number on Column A using Textbox and display the remaining columns on a listbox is it possible?

I also have a userform with 14 textbox so that each time I search for a ticket number it will display all data records on listbox and I update the values using textboxes in bulk method. Please help me here is my codes;

I also attached my full file.K Please help me finish this.

MY GOAL;
Find and Edit Database in Bulk Method
***// If textbox is empty or not need to update, the data should not changed in the worksheet.//**

PLEASE GUYS AND ADMIN HELP ME! THANK YOU

Please Login or Register  to view this content.

Hi MarvinP,

Thanks for your swift response.

Regarding the built-in Microsoft Tool, I am aware of it actually this is not my first database. I have few but this is the crucial part I have.

I hope someone will help me here. Thanks

Hi to All,

kindly help me here,

this is my other code but same in Idea as above problem. I cant figure out what best fit the code. Everything is fine here except for the edit code!

I have 3 textbox to update the 3 columns. I need this to suit our records.

Please Login or Register  to view this content.