Re: Run a macro after a table is updated....
- From: Walt <park.walter@xxxxxxxx>
- Date: Wed, 21 Oct 2009 13:00:08 -0700 (PDT)
Thanks for the response, here's the info you requested:
Tbl1: Contains raw data (~100 fields, ~1000s of rows). Manually
updated by a few users WITH MINIMAL UNDERSTANDING of anything.
The data will probably first be compiled in .xls and then copied/
pasted into the tbl but may also be modified by manual editing. It
doesn't really matter, but a tbl normally works fine for them to do
this.
MANY queries will take the data from Tbl1 and reformat/modify it and
store it in a read-only tbl (Tbl2).
This tbl will be linked to potentially many different mdbs with users
with a broad range of access knowledge and needs for the tbl.
What I am looking for is to trigger the macros to run when the novice
user closes the file or closes the Tbl1 or something else so that they
don't have to physically double-click the macro.
If that can only be done using a form then I will look into that....
wdp
.
- References:
- Run a macro after a table is updated....
- From: wdp
- Re: Run a macro after a table is updated....
- From: Steve Schapel
- Run a macro after a table is updated....
- Prev by Date: Macro to Export
- Next by Date: Re: Macro to Export
- Previous by thread: Re: Run a macro after a table is updated....
- Next by thread: RE: Run a macro after a table is updated....
- Index(es):
Relevant Pages
|
