ACCESS DATA MANIPULATION

  • Thread starter Thread starter DTROUPE
  • Start date Start date
D

DTROUPE

AFTER I HAVE USED THIS MACRO TO GET WHAT I NEED FROM THE
TABLE TO EXCEL (GOOD INF THERE!), HOW DO I TURN AROUND AND
DELETE THE LINES OF DATA FROM THE DATABASE THAT ARE NO
LONGER NEEDED HERE?
 
dtroupe,

Based on what you have told us so far, it sounds like a Delete Query
might be applicable. After you have defined the Delete Query, you
could then use an OpenQuery action in your macro to make it happen.

- Steve Schapel, Microsoft Access MVP
 
If you are using a SELECT query to do the export, then issue a DELETE
FROM on the table using the same WHERE clause as your SELECT query. If
you are not using a SELECT query... well, you probably should.
 
Back
Top