I have a Dreamweaver application that has successfully written to a spl table
in Access. I just need to have Access know when a new record has been
written to the spl table so I can have it kick off a series of macros. I can
(I think) figure out all the macros but how to get things started when a new
record comes in is driving me nuts. Ideas?

Thanks for your assistance!

Unfortunately Access does not have table-level triggers like some other
database. If it did, this would be easy.

You could use the Timer event of a form to do a DCount of the number of
records in the table in question and compare that value against something
stored in another table. If it is greater, run the macros. Also if it is
greater, update the table holding the value.

Another idea would be to add a field to the spl table called NewRecord. Make
it a Yes/No field with the default being Yes. On the On Timer event of a form
(which must be open but can be hidden) check every few minutes for new
records. If it finds one, runs the macros then updates all the records in the
NewRecord field to No.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Bunky" wrote:

> I have a Dreamweaver application that has successfully written to a spl table
> in Access. I just need to have Access know when a new record has been
> written to the spl table so I can have it kick off a series of macros. I can
> (I think) figure out all the macros but how to get things started when a new
> record comes in is driving me nuts. Ideas?
>
> Thanks for your assistance!

Thank you for the information and the options. Super Ideas! Thanks

"Jerry Whittle" wrote:

> Unfortunately Access does not have table-level triggers like some other
> database. If it did, this would be easy.
>
> You could use the Timer event of a form to do a DCount of the number of
> records in the table in question and compare that value against something
> stored in another table. If it is greater, run the macros. Also if it is
> greater, update the table holding the value.
>
> Another idea would be to add a field to the spl table called NewRecord. Make
> it a Yes/No field with the default being Yes. On the On Timer event of a form
> (which must be open but can be hidden) check every few minutes for new
> records. If it finds one, runs the macros then updates all the records in the
> NewRecord field to No.
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
> "Bunky" wrote:
>
> > I have a Dreamweaver application that has successfully written to a spl table
> > in Access. I just need to have Access know when a new record has been
> > written to the spl table so I can have it kick off a series of macros. I can
> > (I think) figure out all the macros but how to get things started when a new
> > record comes in is driving me nuts. Ideas?
> >
> > Thanks for your assistance!

si
"Bunky" <(E-Mail Removed)> escribió en el mensaje
news:919BA231-2836-4153-ABBD-(E-Mail Removed)...
> I have a Dreamweaver application that has successfully written to a spl
table
> in Access. I just need to have Access know when a new record has been
> written to the spl table so I can have it kick off a series of macros. I
can
> (I think) figure out all the macros but how to get things started when a
new
> record comes in is driving me nuts. Ideas?
>
> Thanks for your assistance!