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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"IgorM" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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.
|
|
| "IgorM" <(E-Mail Removed)> wrote in message
| news:(E-Mail Removed)...
|| 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