 |  |  |  |  |  |  |  |
Clear a table on button click.
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Nov 2008
Posts: 451
Reputation: 
Solved Threads: 35
Posting Pro in Training
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.
Check out my new band URL on facebook. I'm the bass player. :) Become a fan and leave comments if you like.
URL on facebook!
URL on facebook!
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.
Good luck
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.
Good luck
Last edited by HI2Japan; May 4th, 2009 at 7:20 pm. Reason: added more info.
Who was the first person to look at a cow and say, "I think I'll squeeze these dangly things here, and drink whatever comes out!"
•
•
Join Date: Nov 2008
Posts: 451
Reputation:
Solved Threads: 35
Posting Pro in Training
Many thanks, it worked just as I wanted it to!
Check out my new band URL on facebook. I'm the bass player. :) Become a fan and leave comments if you like.
URL on facebook!
URL on facebook!
 |
Similar Threads
- ListView in VB.Net (VB.NET)
- ImageButton Command Event (ASP.NET)
- signout image button problem (ASP.NET)
- comparison of distinct field values in 2 tables in the datagridview (VB.NET)
- Need help on export asp.net table to excel (ASP.NET)
- Radio button insert and retrieve (PHP)
- help required (Viruses, Spyware and other Nasties)
- Hi guys please clear my doubt. (ASP.NET)
- Validation difficulties *sigh* (ASP.NET)
- Retrieving values from pop up and displaying into asp page (ASP)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: Employee Call-Out Report
- Next Thread: memo field problem
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
