edwinjeffconcepcion
New Member
- Joined
- Mar 8, 2016
- Messages
- 2
I am really very new to VBA USERFORM Codes and I need to create a database file that would have a lot of data. I was able to create a file that can add and data input to the DataBase sheet. I also have codes how to generate reports for different sheets. However, there are still buttons I need to work on since I do not know the codes and how should it work for my needed report. Most of the codes I have just copied in the internet and modified on my use.
The search, update and generate buttons are challenge for me.
For the Search Button, I would like to have a search engine that whenever I input the account number and Name of the data it will pull out all the details into the userform and to the listbox. I have about 24 textboxes to fill in the userform
For the Update Button, whenever I search a data and able to pull out the details and I need to update some details I will click the update button it will update the details of the data accordingly.
For the generate buttons, I would like to have different kinds of reports that whenever I click one of the buttons in the generate button data I need would go to the sheets accordingly.
Lastly, everything I add and update all details will go to the combine report sheet this is for me to track the new and the changes in every data. Duplicates should be allowed here unlike in the DataBase sheet.
I would like to know how and what will be codes for this.
Looking forward for someone to help please. I am on tight schedule already.
Thank you everyone! I am not sure how I can attach the sample file.
Jeff Concepcion
The search, update and generate buttons are challenge for me.
For the Search Button, I would like to have a search engine that whenever I input the account number and Name of the data it will pull out all the details into the userform and to the listbox. I have about 24 textboxes to fill in the userform
For the Update Button, whenever I search a data and able to pull out the details and I need to update some details I will click the update button it will update the details of the data accordingly.
For the generate buttons, I would like to have different kinds of reports that whenever I click one of the buttons in the generate button data I need would go to the sheets accordingly.
Lastly, everything I add and update all details will go to the combine report sheet this is for me to track the new and the changes in every data. Duplicates should be allowed here unlike in the DataBase sheet.
I would like to know how and what will be codes for this.
Looking forward for someone to help please. I am on tight schedule already.
Thank you everyone! I am not sure how I can attach the sample file.
Jeff Concepcion
