Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / June 2008

Tip: Looking for answers? Try searching our database.

Updating records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pam - 28 Jun 2008 01:08 GMT
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?
bhicks11 - 28 Jun 2008 03:51 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.