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
|
|||
|
|||
#Error - Bookmark Invalid
Over the last few months I've been receiving the #ERROR error in all my data
entry fields within a subform along with a message box stating that the "Bookmark Invalid". This happens enough that it is not only a problem, but I am becoming extremely embarassed that I can not resolve the problem. I have a form (frmSales) that contains a subform (subOrderlst). Typical header/detail type of form. The subform as a field called OrderPrice in the Form Footer section that summarizes one of the columns (=Sum([ExtentedPrice])). On the main form I have a field called txt_subTotal_1 that references the the value in OrderPrice field on the subform as follows: (=IIf(IsNull(subOrderlst.Form!orderprice),[Txt_DC]+[txt_TuningCharge]+[txt_d isposalcharge],subOrderlst.Form!orderprice+[Txt_DC]+[txt_TuningCharge]+[txt_ disposalcharge])) What confuses me about receiving this #ERROR problem is when the user gets this problem. The #ERROR shows up in all of the subform fields only after the user completes the line item in the subform and then enters data in a field on the main form. It appears that the user is able to first add a new line item in the subform. Then when the user moves to a field on the main form, either by clicking into that field or by pressing the tab/enter key until the cursor moves from the subform to the next field on the main form. So, now we have the user sitting in the next available field on the main form. A record in the subform was entered. Now the user enters a value in the field on the main form and attempts to move to the next field by pressing the enter key. This is when the #ERROR error shows up in all the fields in the subform. Any suggestions? I'm using Access 2000 within a Terminal Services environment on a W2K server. Oh yea. What I do to get the user out of this is: first I clear the "Bookmark Invalid" message box. Next I right click on the form so I can get it into design mode. Once in design mode, I close the form and back completely out of the Access session. I then go back into the frmSales form and open up the appropriate record. Surprisingly, the detail record is there. With all its proper data. This also confuses me. Any suggestions would be welcomed. Thank you, Thomas j. Kroljic |
#2
|
|||
|
|||
#Error - Bookmark Invalid
Thomas, I don't use TS, so hopefully those who do will reply as well.
Suggestions: 1. The Bookmark error can indicate a corrupt index. Try a Compact and Repair (Tools | Database Utilities) on the back end, and also on the front end if you have tables there as well. 2. I'm assuming you have split this database so that everyone has an individual copy of the front end. If not, that might be the cause of the problem. 3. When any one calculated field fails to calculate, it can cause #Error in the others as well. That makes it hard to track down. 4. One cause of #Error is that Access misunderstands the data type. I find it helps to set the Format property of all calculated text boxes that are intended to result in a number. Workaround: Set the Format to Currency or General Number or whatever. 5. Another cause is names that are misassigned. To avoid this, uncheck the boxes under: Tools | Options | General | Name AutoCorrect Explanation of why: http://allenbrowne.com/bug-03.html 6. If your subform has no records and no new records can be added (e.g. AllowAdditions is No, or its recorset is read only), the form's Detail section goes completely blank. Referring to the non-existent control resuls in #Error. Even if the control is not in the Detail section, results can be unreliable. Workaround: Leave AllowAdditions as Yes, and block new records by cancelling Form_BeforeInsert. 7. If you are using Conditional Formatting (especially on a calculated field), it is very easy to end up with an endless loop where the calculations keep retriggering. The status bar reads "Calculating..." and you can get error results. Workaround: Consider disabling conditional formatting during trouble-shooting. 8. If you are modifying the database with a later version of Access, you can trigger errors. Decompile the database using the TS version, and compact again. 9. In a normal network environment, we ensure all workstations have SP3 for Access 2000 and SP8 for JET 4. Presumably on TS you need to check that the server has these service packs. 10. Timing issue. This one I never did solve completely. It involved multiple users (not TS) on Access 2000 with the back end on an NT4 server. Symptoms included the #Error. Also, combos and list boxes loaded only the first 30 or 50 or so items where 100 or 200 were expected. I suspect it was a network issue, since I was not able to repro. the situation in any other setting. Users were not running as local computer administrator, so I don't know if it was permissions, or the amount of traffic on the network, or an issue with NT, but something seemed to be timing out and generating the #Error. Restarting the session would sometimes help. HTH. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Thomas Kroljic" wrote in message ... Over the last few months I've been receiving the #ERROR error in all my data entry fields within a subform along with a message box stating that the "Bookmark Invalid". This happens enough that it is not only a problem, but I am becoming extremely embarassed that I can not resolve the problem. I have a form (frmSales) that contains a subform (subOrderlst). Typical header/detail type of form. The subform as a field called OrderPrice in the Form Footer section that summarizes one of the columns (=Sum([ExtentedPrice])). On the main form I have a field called txt_subTotal_1 that references the the value in OrderPrice field on the subform as follows: (=IIf(IsNull(subOrderlst.Form!orderprice),[Txt_DC]+[txt_TuningCharge]+[txt_d isposalcharge],subOrderlst.Form!orderprice+[Txt_DC]+[txt_TuningCharge]+[txt_ disposalcharge])) What confuses me about receiving this #ERROR problem is when the user gets this problem. The #ERROR shows up in all of the subform fields only after the user completes the line item in the subform and then enters data in a field on the main form. It appears that the user is able to first add a new line item in the subform. Then when the user moves to a field on the main form, either by clicking into that field or by pressing the tab/enter key until the cursor moves from the subform to the next field on the main form. So, now we have the user sitting in the next available field on the main form. A record in the subform was entered. Now the user enters a value in the field on the main form and attempts to move to the next field by pressing the enter key. This is when the #ERROR error shows up in all the fields in the subform. Any suggestions? I'm using Access 2000 within a Terminal Services environment on a W2K server. Oh yea. What I do to get the user out of this is: first I clear the "Bookmark Invalid" message box. Next I right click on the form so I can get it into design mode. Once in design mode, I close the form and back completely out of the Access session. I then go back into the frmSales form and open up the appropriate record. Surprisingly, the detail record is there. With all its proper data. This also confuses me. Any suggestions would be welcomed. Thank you, Thomas j. Kroljic |
#3
|
|||
|
|||
#Error - Bookmark Invalid
Allen,
Thanks for your quick response and helpful suggestions. I'll go through each suggestion tomorrow and check them against my databases (FE and BE). This error is a pain, but you gave me several good things to look at and possible modify. Thank you, Thomas j. Kroljic "Allen Browne" wrote in message ... Thomas, I don't use TS, so hopefully those who do will reply as well. Suggestions: 1. The Bookmark error can indicate a corrupt index. Try a Compact and Repair (Tools | Database Utilities) on the back end, and also on the front end if you have tables there as well. 2. I'm assuming you have split this database so that everyone has an individual copy of the front end. If not, that might be the cause of the problem. 3. When any one calculated field fails to calculate, it can cause #Error in the others as well. That makes it hard to track down. 4. One cause of #Error is that Access misunderstands the data type. I find it helps to set the Format property of all calculated text boxes that are intended to result in a number. Workaround: Set the Format to Currency or General Number or whatever. 5. Another cause is names that are misassigned. To avoid this, uncheck the boxes under: Tools | Options | General | Name AutoCorrect Explanation of why: http://allenbrowne.com/bug-03.html 6. If your subform has no records and no new records can be added (e.g. AllowAdditions is No, or its recorset is read only), the form's Detail section goes completely blank. Referring to the non-existent control resuls in #Error. Even if the control is not in the Detail section, results can be unreliable. Workaround: Leave AllowAdditions as Yes, and block new records by cancelling Form_BeforeInsert. 7. If you are using Conditional Formatting (especially on a calculated field), it is very easy to end up with an endless loop where the calculations keep retriggering. The status bar reads "Calculating..." and you can get error results. Workaround: Consider disabling conditional formatting during trouble-shooting. 8. If you are modifying the database with a later version of Access, you can trigger errors. Decompile the database using the TS version, and compact again. 9. In a normal network environment, we ensure all workstations have SP3 for Access 2000 and SP8 for JET 4. Presumably on TS you need to check that the server has these service packs. 10. Timing issue. This one I never did solve completely. It involved multiple users (not TS) on Access 2000 with the back end on an NT4 server. Symptoms included the #Error. Also, combos and list boxes loaded only the first 30 or 50 or so items where 100 or 200 were expected. I suspect it was a network issue, since I was not able to repro. the situation in any other setting. Users were not running as local computer administrator, so I don't know if it was permissions, or the amount of traffic on the network, or an issue with NT, but something seemed to be timing out and generating the #Error. Restarting the session would sometimes help. HTH. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Thomas Kroljic" wrote in message ... Over the last few months I've been receiving the #ERROR error in all my data entry fields within a subform along with a message box stating that the "Bookmark Invalid". This happens enough that it is not only a problem, but I am becoming extremely embarassed that I can not resolve the problem. I have a form (frmSales) that contains a subform (subOrderlst). Typical header/detail type of form. The subform as a field called OrderPrice in the Form Footer section that summarizes one of the columns (=Sum([ExtentedPrice])). On the main form I have a field called txt_subTotal_1 that references the the value in OrderPrice field on the subform as follows: (=IIf(IsNull(subOrderlst.Form!orderprice),[Txt_DC]+[txt_TuningCharge]+[txt_d isposalcharge],subOrderlst.Form!orderprice+[Txt_DC]+[txt_TuningCharge]+[txt_ disposalcharge])) What confuses me about receiving this #ERROR problem is when the user gets this problem. The #ERROR shows up in all of the subform fields only after the user completes the line item in the subform and then enters data in a field on the main form. It appears that the user is able to first add a new line item in the subform. Then when the user moves to a field on the main form, either by clicking into that field or by pressing the tab/enter key until the cursor moves from the subform to the next field on the main form. So, now we have the user sitting in the next available field on the main form. A record in the subform was entered. Now the user enters a value in the field on the main form and attempts to move to the next field by pressing the enter key. This is when the #ERROR error shows up in all the fields in the subform. Any suggestions? I'm using Access 2000 within a Terminal Services environment on a W2K server. Oh yea. What I do to get the user out of this is: first I clear the "Bookmark Invalid" message box. Next I right click on the form so I can get it into design mode. Once in design mode, I close the form and back completely out of the Access session. I then go back into the frmSales form and open up the appropriate record. Surprisingly, the detail record is there. With all its proper data. This also confuses me. Any suggestions would be welcomed. Thank you, Thomas j. Kroljic |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Invalid page fault in module RPCRT4.dll | Vensia | General Discussion | 1 | November 4th, 2005 01:01 PM |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Outlook 2002 Error (Several Installations) | RDBrimmer | General Discussion | 3 | June 29th, 2005 10:40 AM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 11:55 AM |
Invalid Argument Problem | JohnB | General Discussion | 0 | February 18th, 2005 03:44 PM |