Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-30-2013, 02:05 PM   #1
toby0595
Newly Registered User
 
Join Date: Mar 2013
Location: london
Posts: 10
Thanks: 8
Thanked 1 Time in 1 Post
toby0595 is on a distinguished road
how will i automatically delete the information in a table with a command

Hello there i was wondering if anyone could help me with a project of mine for my a2 ICT course, my database just records end of day sales figures which are entered though a form, after they are entered the total for the day is archived. However the problem i have is that the i need some way of clearing the input table with a command in the form.

Any help would be greatly appreciated

Many thanks toby

toby0595 is offline   Reply With Quote
Old 10-30-2013, 02:07 PM   #2
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,280
Thanks: 78
Thanked 1,409 Times in 1,329 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: how will i automatically delete the information in a table with a command

Set up a button to run a delete query.
Galaxiom is offline   Reply With Quote
Old 10-30-2013, 02:27 PM   #3
toby0595
Newly Registered User
 
Join Date: Mar 2013
Location: london
Posts: 10
Thanks: 8
Thanked 1 Time in 1 Post
toby0595 is on a distinguished road
Re: how will i automatically delete the information in a table with a command

yes that's stupidly simple,

so just run

DELETE FROM table_name;

or

DELETE * FROM table_name;

toby0595 is offline   Reply With Quote
Reply

Tags
command button , delete , query's , table data , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Fill In information Toledo123 Forms 1 09-23-2012 08:42 AM
automatically add information after date exceeds? stu_c General 5 09-20-2012 06:00 AM
Vba code for add,delete and update a record in access table through command button? sunny1 Modules & VBA 1 07-28-2010 05:26 AM
Delete records automatically frm table YamiMarik777 Queries 1 07-26-2006 12:22 PM
Delete records automatically frm table YamiMarik777 Queries 0 07-26-2006 08:32 AM




All times are GMT -8. The time now is 10:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World