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 (edited by derek 2020-08-01 09:12:27)

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, 118 downloads since 2020-08-01 

Re: Command procedure to clear data in tables

This is awesome Derek... Thanks