PC Review


Reply
Thread Tools Rate Thread

Delete Multiple Records from Subform

 
 
BrianDP
Guest
Posts: n/a
 
      11th Aug 2010
I have a subform attached to a form, and when you select more than one
record and try to delete, Access hangs, and finally comes back with an
ODBC Error. The backend is a MS SQL database.

Help!
 
Reply With Quote
 
 
 
 
BrianDP
Guest
Posts: n/a
 
      11th Aug 2010
On Aug 11, 3:04*pm, BrianDP <bdp...@gmail.com> wrote:
> I have a subform attached to a form, and when you select more than one
> record and try to delete, Access hangs, and finally comes back with an
> ODBC Error. *The backend is a MS SQL database.
>
> Help!


It seems like there is some code behind the subform - so every delete,
before delete, before confirm delete, after confirm delete, they all
run the same sub-routine.. I don't know what the subroutine does yet,
but when I took out the references to the subroutine from the delete
events, it deleted the records no questions..

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete subform records without deleting main form records =?Utf-8?B?QW5pdGE=?= Microsoft Access Form Coding 0 21st Nov 2006 07:00 AM
Help-How to retreive multiple records from 1 subform to another subform? Ramona Microsoft Access Forms 3 27th Jul 2006 07:11 PM
How to Select and Delete multiple subform records? Penny Microsoft Access 1 26th Feb 2005 08:18 AM
Copy/Paste Records with Multiple Subform Records Max Smart Microsoft Access Form Coding 2 16th Sep 2004 03:26 PM
Subform...delete and add records jimday1982 Microsoft Access Forms 0 11th Feb 2004 06:44 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 AM.