ACCESS DATA MANIPULATION

[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?

 

[Steve Schapel]

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

 

[onedaywhen]

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.