Using an event as a macro condition?

  • Thread starter Thread starter John Hipskind
  • Start date Start date
J

John Hipskind

Is there a way to use an event as a macro condition?
For example:
My macro imports Excel data into an Access report, and
then updates a Snapshot of the report.
However, things can happen where the import isn't
accomplished, so I only want to proceed to update the
Snapshot if I actually have a revised report.
Is there anything like a AfterUpdate condition that can
be used to test for an updated report before the Snapshot
is then updated?
Thanks.
John
 
John,

I assume you are importing the data from Excel into a table in your
database. The only way I can think of, is to keep a table with the
previous data, maybe using a MakeTable query, and then use another
query to compare the supposedly imported data with the previous data.
If there are non-matching records, proceed with the report.

- Steve Schapel, Microsoft Access MVP
 
Back
Top