 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Error deleting records in sub-sub-forms
Microsoft Access 2007 wil not delete a record in a sub-sub-form. I am sure that this is a bug in Access 2007. I have tried to isolate the problem by creating a new database with to simple related tables. And no code. Does anyone know a hotfix? Hi Leif, if you are in the code behind the main form, try this: with me.subform_controlname.form.subsubform_controlname .form.Recordset.Delete .requery end with WHERE subform_controlname is the Namep prperty of the subform control subsubform_controlname is the Namep prperty of the sub-subform control Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > Microsoft Access 2007 wil not delete a record in a sub-sub-form. > I am sure that this is a bug in Access 2007. > I have tried to isolate the problem by creating a new database with to > simple related tables. And no code. > Does anyone know a hotfix? I know that there are several options to solve the problem - for instance by using code or to make the sub-subform to a parellel linked subform. But I want the simple solution, which is suppose work. > Hi Leif, > [quoted text clipped - 25 lines] > > simple related tables. And no code. > > Does anyone know a hotfix? Hi Leif, please post the "simple" solution that does not work that you are using Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > I know that there are several options to solve the problem - for instance by > using code or to make the sub-subform to a parellel linked subform. [quoted text clipped - 29 lines] >>> simple related tables. And no code. >>> Does anyone know a hotfix? FormC (based on tableC) is inserted i formB (based on tableB) is inserted i formA. The field [idb<] in tableC is joined to the key field [idb] in tableB. FormC is linked to formB by Link Master fields = [idb] and Link Child Fields = [idb<] For Both formB and FormC Default View = Datasheet. Then it is not possible to delete a record i sub-subfomC. > Hi Leif, > [quoted text clipped - 44 lines] > >>> simple related tables. And no code. > >>> Does anyone know a hotfix? Hi Leif, thank you for explaining how your tables are related. When you try to delete a record in form C, how are you doing it? is FormC form property AllowDeletions set to True? is the RecordSource for FormC ONLY table C? in the defined relationships for your database, is there a relationship between tableB and tableC? If so, which table holds the 'parent' field? Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > FormC (based on tableC) is inserted i formB (based on tableB) is inserted i > formA. [quoted text clipped - 52 lines] >>>>> simple related tables. And no code. >>>>> Does anyone know a hotfix? As I mentioned in the start - it is a bug in Access 2007: Because, when I run the Access-file with tables, that I have just described, in Access 2003 there are no problems! But how can I contact Microsoft to make them solve the problem - whithout having to pay a lot of money contacting their support? > Hi Leif, > [quoted text clipped - 75 lines] > >>>>> simple related tables. And no code. > >>>>> Does anyone know a hotfix? Hi Leif, you still have not described the method you are using to try to delete the record please also answer these questions: 1. is FormC form property AllowDeletions set to True? 2. is the RecordSource for FormC ONLY table C? If the Recordsource is a query or SQL, please post the SQL statement 3. in the defined relationships for your database, is there a relationship between tableB and tableC? If so, which table holds the 'parent' field (double-click on the link line -- which table is listed in the left column?) ? Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > As I mentioned in the start - it is a bug in Access 2007: > Because, when I run the Access-file with tables, that I have just described, [quoted text clipped - 81 lines] >>>>>>> simple related tables. And no code. >>>>>>> Does anyone know a hotfix? I use the Delete-key to delete the record. Which is the normal way to delete records. And this method is suppose to work. And still - why doesn't it work in Access 2007 when it works fine in Access 2003? And therefor your other questions are also irrelevant I AM ABSOLUTELY POSITIVELY SURE THAT MY SETTINGS ARE OK - AND IT IS A BUG IN ACCESS 2007!!!! PLEASE JUST DIRECT TO A HOTFIX. > Hi Leif, > [quoted text clipped - 109 lines] > >>>>>>> simple related tables. And no code. > >>>>>>> Does anyone know a hotfix? Hi Leif, This is not a bug. The Delete key will only work if the RECORD is selected to select a record: 1. click in the gray record selector rectangle on the left OR 2. press SHIFT-Spacebar when an entire control is highlighted (F2 toggles between insertion point and highlighting entire control) OR 3. choose 'Select Record' from the ribbon otherwise, to DELETE A RECORD, it is fastest to use: CTRL - (hold Control and press the minus sign) Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > I use the Delete-key to delete the record. Which is the normal way to delete > records. And this method is suppose to work. [quoted text clipped - 118 lines] >>>>>>>>> simple related tables. And no code. >>>>>>>>> Does anyone know a hotfix? I have been programming Access databases for about 13 years. so I surely know how to delete a record. Every possible way. And also - you still have not explained to me why it is possible in Access 2003 and not in Access 2007. I can send you the database, if you give me your email? > Hi Leif, > [quoted text clipped - 145 lines] > >>>>>>>>> simple related tables. And no code. > >>>>>>>>> Does anyone know a hotfix? Hi Leif, yes, I would like to test this for myself strive4peace2006 at yahoo.com please specify the steps you take from the database opening to press the DELETE key Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > I have been programming Access databases for about 13 years. > so I surely know how to delete a record. Every possible way. [quoted text clipped - 151 lines] >>>>>>>>>>> simple related tables. And no code. >>>>>>>>>>> Does anyone know a hotfix? Hi Leif, got your database sorry to be the bearer of bad news, but what you sent has several problems: 1. you need to remove '<' from the field and controlname for 'idt1' 2. you have not qualified 'ID' with the type of ID it is... tableB and tableC both have ID as a fieldname -- but, obviously being an autonumber in each table, they are not the same information! 3. you have no defined relationships 4. the LinkChildField for the subform control containing TableC is idt1< ... in addition to containing a bad character, it is also not filled in the table (probably due to '<' in the name) 5. a datasheet view form cannot display a subform -- therefore, you are actually using the 'subDatasheet' property of the table (which has problems and is recommended to turn off), not a form -- and the subform, since it is specified, probably has the table open read 'Access Basics' Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * > Hi Leif, > [quoted text clipped - 177 lines] >>>>>>>>>>>> with to simple related tables. And no code. Does anyone know >>>>>>>>>>>> a hotfix? |
Reply to this Message |
 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.