Hello.
I am learning vba as i go along and am creating an excel vba database to record repairs of products.
I have managed to put together a basic database, but there is code needed to make it work properly.
At the moment the database has only 1 tab for TV repair records. I will be adding a tab for other products like Mobile Phone, Fridge.....etc. Not sure how i will add these extra tabs, so will need some help with this.
Scenario
When i do have several tabs - TV, Mobile, Fridge, i will want to search for a search string like WiFi or Repairer Name or State of repair (open) and all records from all the tabs should be displayed as a list in the search results box.
Is this possible? If so, please can someone show me how or point me in the right direction?
One other thing i noticed is that when I add a new repair record, it overwrites the current one. It should a a new repair record to the next row down. Again if someone can show me how to do this please.
I have attached the file here.
I am continuously learning, so your help would be valuable.
Thanks in advance.
;-)
I am learning vba as i go along and am creating an excel vba database to record repairs of products.
I have managed to put together a basic database, but there is code needed to make it work properly.
At the moment the database has only 1 tab for TV repair records. I will be adding a tab for other products like Mobile Phone, Fridge.....etc. Not sure how i will add these extra tabs, so will need some help with this.
Scenario
When i do have several tabs - TV, Mobile, Fridge, i will want to search for a search string like WiFi or Repairer Name or State of repair (open) and all records from all the tabs should be displayed as a list in the search results box.
Is this possible? If so, please can someone show me how or point me in the right direction?
One other thing i noticed is that when I add a new repair record, it overwrites the current one. It should a a new repair record to the next row down. Again if someone can show me how to do this please.
I have attached the file here.
I am continuously learning, so your help would be valuable.
Thanks in advance.
;-)