remove database by command instead of clicking delete button

when I remove all the entry by clicking reset button all the entries are removed from dataform.

all entries are gone but when you call data form by clicking form button there will be still blank database is exist and you have to edit each entry instead of click the new button.

Hi, dharmang1910,

AFAIK the builtin DataMask doesnīt feature a DeleteAll. You have integrated a CommandButton to clear the contents which is one of the ways it could be done

Please Login or Register  to view this content.

Alterantives may be to add a column toi the data wirth the date and filter for that date via Criteria, to use the Advanced Filter with a criteria range on another sheet and copy only the data which is available or to maybe add some functionality that on opening the workbook the old data is cleared and the data for the actual day is inserted. As I donīt know how you imprt the data and from which file this code may show a way, procedure goes into ThisWorkbook:

Please Login or Register  to view this content.

You would need to alter the directory and the filename or have a dialog for choosing the file (GetOpenFilename or Application.Dialogs(xlDialogOpen)).

Ciao,
Holger

first of all thank you all for your reply, i've updated my user form so my delete database problem get solved but i need help in this matters...

• need code that can display total of all entries in the textbox. here is the formula i need
  
  1000*texbox1.value+500*textbox2.value+100*textbox3.value...........+1*textbox9.value
  
• want to prefix "dh" to all "Tr. no." so i only have to enter numbers.(transaction number format like dh12345)
  
• want to import/export every day database record as xml or any other format.(i have once seen a excel file which have generate xml button which can generate xml file of database )
  
• automatically add "0" to blank textbox at once by clicking ok button

so please can anybody help me in this final coding of my project..???

database sheet new.xls

i have seen a code for generating xml is looks like this..

Please Login or Register  to view this content.

Hi, dharmang1910,

you would need to make the strings of the textboxes values for excel like using CDbl or CLng to convert them prior to writing the value to the cell.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Although I would prefer to use ListIndex = -1 for ComboBoxes.

Ciao,
Holger

Hi, dharmang1910,

I wouldnīt use the change-event (any empty textbox value will cause a RunTimeError) but use the Exit and check the length oif the cell prior to calling the procedure but thatīs up to your taste.

Please Login or Register  to view this content.

Ciao,
Holger