Delete table information

  • Thread starter Thread starter ryan.fitzpatrick3
  • Start date Start date
R

ryan.fitzpatrick3

Hi have a form with a subform where I input item numbers. This saves
to a table where I use those inputted item numbers in a query. This
works fine. On the form I have a clear table button, (that dosen't
work yet) where I would like to clear the table of the information and
the person can enter in new items? Now would this be an append query
by chance? Or what would be the best way to do this? Thanks in
advance.

Ryan
 
If my table is called tbltrial and the field is ItemNumber, I open up
a new query, bring in the TRIAL table then go to SQL and put
DELETE tbltrail. * FROM tblTrial

is that it and is it correct?

Ryan
 
Where do I put the code on the button, in VBA? Do I copy and paste the
SQL statement, if so, how do I do that (unless it's an obvious copy
and paste)?
 
On Mon, 10 Mar 2008 15:23:49 -0700 (PDT),
Ok I got the delete query to work, just need help attaching it to a
button.
Click to expand...

Code the button's Click event:

CurrentDb.Execute "QueryName", dbFailOnError
 
Back
Top