Hello friends, I want to clear a table by clicking a button on a form. I have created the query to clear the table but I cannot make it the source for the command button on the form. Is this possible? Thanks for your time and help.
I'm sure there is a VBA approach to this, but you could also make a macro with 6 lines in it.
Make a new Macro and use the following:
SetWarnings = No
OpenTable = table you want to remove all records from
RunCommand = SelectAllRecords
RunCommand = DeleteRecord
Close = choose table and specify table you just opened
SetWarnings = Yes
After the macro is made, make a command button and assign the macro to it.
No need to use a query to do this.
Many thanks, it worked just as I wanted it to!
I have a problem where I need to search on data set with 5 fields.
Field 1 - Account number
Field 2 - Date
Field 3 - Person1
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion Here is my simple code. // db.php code _______________________ <?php //$con = mysqli_connect("localhost","root","","bakery"); ...
Hi guys. I am trying to create a program where the user inputs an integer and the program will cout the nth prime number. Unfortunatly when I try to cout ...