Created BASIC userform which ADDS data: http://www.1sar.karoo.net/ADDonly~DBphone.xls 85 KB's
However, how to add in these other functions? 3 function to include are listed below in bold, and whether to include them as expanding window of existing user form, OR in an seperate userform (Perhaps both to give me an idea what works best):
FIND/SEARCH existing records, using COL A, and if multiple display 1st 4 COLUMNS for those records with option to pick 1
DELETE record selected/displayed currently
CLEAR current userform fields
Have seen good examples of SEARCH/EDIT but unsure how to include this vb code in my spreadsheet as rows/cols/txtboxs are listed many numerous times:
http://www.1sar.karoo.net/NameDB.xls 273 KB's Instructions: Search Detail, left click Search Details, untick return all matches, search data: surname, Surname: Smith. Search. Dbl click only entry below.
Amend Selection appears on RIGHT HAND SIDE. Edit, then press AMEND SELECTION.
HOWEVER AMENDMENTS cause DOUBLE ENTRIES in "Data" hence just delete 1 ROW! Unless CODE can be corrected?
ALSO another great example of SEARCH/EDIT:
http://www.1sar.karoo.net/DataBaseForm.xls 91 KB's INSTRUCTIONS: Sheet1, Start, enter name, find
Small file and easy to use, however DELETE records appears to sometimes delete wrong record, apparently the current top most record, instead of selected record!
Perhaps code can be corrected?
Bookmarks