I have an access form that I want to use to delete records. There is a
trigger on the table and when I attempt to delete the record I get a "Cannot
insert null into......." message with the ID field of the user. I thought I
could run a pass through query on form open that would set the user ID, but
that is not working.
Any suggestions?
Hi Pam,
What do you mean by a trigger? Is this a SQL front end?
Bonnie
http://www.dataplus-svc.com
>I have an access form that I want to use to delete records. There is a
>trigger on the table and when I attempt to delete the record I get a "Cannot
[quoted text clipped - 3 lines]
>
>Any suggestions?
Pam - 30 Jun 2008 20:40 GMT
It is an Oracle 10g backend trigger with a MS Access front end.
> Hi Pam,
>
[quoted text clipped - 10 lines]
> >
> >Any suggestions?
bhicks11 - 30 Jun 2008 21:27 GMT
Sorry Pam, maybe somebody else can help you.
Bonnie
http://www.dataplus-svc.com
>It is an Oracle 10g backend trigger with a MS Access front end.
>
[quoted text clipped - 3 lines]
>> >
>> >Any suggestions?