BeforeUpdate on linked table

  • Thread starter Thread starter IgorM
  • Start date Start date
I

IgorM

Hi

I have a pivottable in excel that is connected to a query in Access. The
query joins a table and a linked table. Is it possible to run some macro
before the linked table is updated in order to check some data in source
file for the linked table? In other words I want to run some code that is
triggered when a user clicks to refresh a pivot table in Excel.

Kind regards
IgorM
 
No, Access doesn't support triggers.

The only way to run code before an update is to use a form.
 
Douglas J. Steele wrote:

Not exactly. We can use custom function in WHERE conditions to run some
code:

Select ...
From ...
Where
...
AND
MyFunction() = True

Sometimes MyFunction() can run another SQL...
(Let say some deletes/inserts to temporary table(s)...)

Unfortunately custom function cannot be evaluated from excel (IMHO)...

--
KN



| No, Access doesn't support triggers.
|
| The only way to run code before an update is to use a form.
|
|
| || Hi
||
|| I have a pivottable in excel that is connected to a query in Access.
|| The query joins a table and a linked table. Is it possible to run
|| some macro before the linked table is updated in order to check some
|| data in source file for the linked table? In other words I want to
|| run some code that is triggered when a user clicks to refresh a
|| pivot table in Excel.
||
|| Kind regards
|| IgorM
 
Back
Top