|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 28th, 2006, 12:44 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
triggers
is there a good way to approximate a sql trigger within access -
without using a forms after insert event? 
|
|
#2
February 28th, 2006, 01:24 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
triggers
None that I know of or have heard of.
The only way I know to emulate a trigger is to use form events. Unless you are using a different backend than JET. For instance, you could do this if your database engine was MS SQL, Oracle, etc. wrote in message oups.com... is there a good way to approximate a sql trigger within access - without using a forms after insert event?
|
|
#3
February 28th, 2006, 01:46 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
triggers
right.
so no way to get a macro to immulate a trigger by calling some vba code?
|
|
#4
February 28th, 2006, 02:08 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
triggers
Triggers would sure be nice. Access is event driven and unfortunately tables
do not have events. If you are entering data directly into a table, there is not way to automate something like putting a foriegn key into another table. If you are doing appends or inserts into a table, you need to handle anything trigger-like while you are doing it. I'll add that sequences would also be nice instead of autonumbers. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. " wrote: right. so no way to get a macro to immulate a trigger by calling some vba code?
|
|
#5
March 4th, 2006, 08:30 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
triggers
If we're compiling a wish-list, can we have T-SQL as well?
 )"Jerry Whittle" wrote in message ... Triggers would sure be nice. Access is event driven and unfortunately tables do not have events. If you are entering data directly into a table, there is not way to automate something like putting a foriegn key into another table. If you are doing appends or inserts into a table, you need to handle anything trigger-like while you are doing it. I'll add that sequences would also be nice instead of autonumbers. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. " wrote: right. so no way to get a macro to immulate a trigger by calling some vba code?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| generate triggers ... | family | Visio | 0 | February 3rd, 2006 10:29 PM |
| The Use of Custom Animation Triggers | Trainer Guy | Powerpoint | 3 | January 14th, 2006 12:18 AM |
| triggers don't work in sent message | H Williams | Powerpoint | 5 | December 8th, 2005 09:35 PM |
| Refresh Screen when using triggers | fltpro | Powerpoint | 1 | November 4th, 2005 07:56 AM |
| Using Triggers | fltpro | Powerpoint | 3 | November 3rd, 2005 08:36 AM |
Linear Mode
