Dan Waters
dwaters at usinternet.com
Mon Jan 26 18:27:31 CST 2004
Dwylene, I received this same error on a single desktop PC running W2K and AXP, when all other machines with the same configuration worked fine. The solution was as follows: In the code module for the form comment out ALL the code - even the Option Explicit and Option Compare database. Then compile the database. Then save the form, exit access. Then reopen the database with a /decompile command. The error should not occur when the form is opened. Then uncomment all the code, compile again, and save the form. The form should now work as intended on this PC. To get to this I went through my usual 'narrowing down' to try to find the problem, and that was what worked. What I suspect happened is that this particular form had some corrupted hidden compiled code behind it which only caused a problem on a particular machine due to that machine's particular configuration. When I commented out the form's entire code module, decompiled, and recompiled, the database believed that this form then had no code at all, and erased the hidden corrupted compiled code. At least this was a relatively easy fix attempt - good luck! Dan Waters Quality Process Solutions PS - use the Comment and Uncomment buttons on the VBA Edit toolbar. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dwylene Garcia Sent: Monday, January 26, 2004 2:45 PM To: accessD at databaseadvisors.com Subject: [AccessD] Form doesn't work on new laptop I have an odd problem that has managed to stump several IT people. We are on the verge of giving up but I thought I would make an attempt to ask this group if anyone has seen such a problem. I have a fairly complicated form (one-to-many-to-many relationship, Main form with two subform, one subform filters the other subform) and this form has worked for 2 years and still does work on every desktop in our office. However, one employee received a new laptop this week running Windows 2000, Office XP and Access 2000 (the same as all the desktops) and the database opens and it appears that the less complicated forms work fine but this one form which is the main form used will not populate the subforms correctly. It recognizes there are records but it won't show them in the combo box... I have found this http://support.microsoft.com/default.aspx?scid=kb;en-us;208866&Product=acc20 00 in the knowledge base that seems to restate the problem exactly. However, I'm looking for a solution that does not involve altering my form since it does work on the desktop computers. Why will it work on a desktop and not a laptop???? I don't have time to alter the database to make it work on this one laptop when 7 other desktop computers run the database fine. I'm wondering if anyone else has ever experienced this and I'm hoping that it's something silly that I overlooked while troubleshooting. I think we have hit all the obvious troubleshooting points like reinstalling MS Office, I took the database off the network and tried to run from the C:/. When it first happened we received an error "Object invalid or no longer set.", that error is not showing up now. Dwylene Garcia Computer Applications Trainer Kent Hospital, Department of Education Email: garciad at kenthospital.org _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com