Lisa,
I made at least one error in my reply.
Number 1 should say ... double click on your MDB while holding down
the Shift Key...
Sorry
Dick
--- In [email protected], "Dick Root" <[EMAIL PROTECTED]> wrote:
>
> Lisa,
> Welcome -
> To delete the contents of a table:
> 1. In MyComputer or Explorer double click on your Access database
> (MDB). This will put you into design/developer mode.
> 2. You will see a vertical list of things to be developed with name
> like table, form, query, etc. Go to the Table tool and double click
> on the table you want to empty.
> 3. Once you can see all the entries in that table do EDIT/SelectAll
> 4. Then do EDIT/Delete - The table will now be empty.
>
> Alternatively you could write a Delete Query -
> 1. back where there was the vertical list of table, form, query, etc.
> and choose Query.
> 2. Click on New
> 3. Choose Design View
> 4. Close the Show Table box (start with an "empty slate")
> 5. Choose View/SQL view
> 6. Key in "Delete From yourtablename"
> 7. Close the Query SQL development box and name your query
> Then in the future when you click on this new query yourtablename will
> be emptied
>
> I usually have a service/utility form from where I run various
> different functions. On that form I would add a new button that runs
> the delete query.
>
> Dick
>
> --- In [email protected], "eakdxl" <eakdxl@> wrote:
> >
> > Hi everyone,
> >
> > I just joined the group but I have very limited knowledge of Access.
> > Basically I input data for a food pantry every month. Each year the
> > database is copied and retains all records. There are three tables
and
> > one of them should have the information in the columns deleted. The
> > columns are strictly used to record dates of visits and change from
> > year to year. I would like to know if it is possible and how to do it
> > to save me from deleting each entry to set up the database for 2007.
> > Hope this makes sense. As you can see, I am a real novice and any
help
> > you can give me would be truly appreciated.
> >
> > Lisa
> >
>
