• Registered: 2019-10-25
  • Posts: 23

Topic: Command procedure to clear data in tables

Hello all,

I am looking for a command procedure that I can add to my project.

I need to add a new menu item in "Options Menu" to say (Clear Database)

With this option, the user can clear all the data from specified tables with a warning dialog box of  "Are you sure you want to clear the data?" Yes to clear and no to return to Form1.

Has anyone written a procedure like this?

2 Reply by derek (edited by derek 2020-08-01 09:12:27)

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: Command procedure to clear data in tables

Hi,
You could do it something like this (see attached - Form1 > Options > Clear Tables).
I just hope your users are more trustworthy than mine - LOL!
Derek.

Post's attachments

Attachment icon deletetables.zip 337.83 kb, 500 downloads since 2020-08-01 

  • Registered: 2019-10-25
  • Posts: 23

Re: Command procedure to clear data in tables

This is awesome Derek... Thanks