+ Reply to Thread
Results 1 to 3 of 3

USERFORM: EDIT to include FIND, DELETE & CLEAR

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    USERFORM: EDIT to include FIND, DELETE & CLEAR

    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?
    Last edited by srands; 12-31-2012 at 03:35 AM.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: USERFORM: EDIT to include FIND, DELETE & CLEAR

    Just add these lines to the delete button and it will delete the proper record


    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Re: USERFORM: EDIT to include FIND, DELETE & CLEAR

    Here is my latest edit, another DATABASE version, with QUICK START macro command buttons, all with no faults for SEARCH& ADD/EDIT/UPDATE/BROWSE, even includes photo preview in SEARCH & ADD/EDIT/BROWSE for records in database with photos inserted.

    http://www.1sar.karoo.net/QUICKstartFRONTdb.xls 390 KB's

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1