Charlotte Foust
cfoust at infostatsystems.com
Fri Nov 7 10:34:58 CST 2003
The distinction about runtime engines is because some things work differently when you are running an app from a fully installed version of Access than when you are running it using an Access runtime engine. In either case, you can get runtime errors (when you run it, naturally), but the behavior is different and you don't always even see the errors under the runtime engine, just the effects. I asked about the Access version (as distinct from the file format) because I've seen things compile in Access 2002 that crash when the code is run because it can miss routines with the same name if they are only called from the property sheet of an object rather than from within code. I didn't run into that in Access 2000, but then I rarely if ever use lightweight forms myself. Have you tried creating a new database and importing all the objects? Do they all import? It sure sounds like some object corruption to me. Charlotte Foust -----Original Message----- From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com] Sent: Thursday, November 06, 2003 5:55 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Method 'SourceObject' of object... Charlotte, 1. Yes, that's the literal message, referring to object names that are not found anywhere in my code or object set. 2. Using Access 2000. 3. I don't understand your distinction about runtime engines. The app compiles cleanly, and compacts without complaint. But when I start hitting a few areas with subforms, I get a hailstorm of these errors. I can turn on error pausing and see where it trips up, and the code lines are all different, but they do have the common thread of assigning various subform names to the container form's subform's SourceObject. 4. Oops, you are right -- I meant "SourceObject". The offending lines read like: forms!frmPerson!subSection.SourceObject = "frmPerson_SubVolunteer" Steve Capistrant Symphony Information Services scapistrant at symphonyinfo.com www.symphonyinfo.com Phone: 763-391-7400 7308 Aspen Lane North, Suite 132 Brooklyn Park, MN 55428 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, November 06, 2003 7:29 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Method 'SourceObject' of object... Is that the literal error message, or do 'SourceObject' and '_SubForm' stand as placeholders? What version of Access are you using and What file format? Are you getting the message when someone attempts to run the application using the runtime engine or is it an error that *happens* at runtime? Is the error triggered on methods like "ControlSource" or did you mean "SourceObject" rather than what you typed? Charlotte Foust -----Original Message----- From: Steve Capistrant [mailto:scapistrant at symphonyinfo.com] Sent: Thursday, November 06, 2003 5:04 PM To: Access Developers discussion and problem solving Subject: [AccessD] Method 'SourceObject' of object... Help!! Our main database has been corrupted, displaying this: " Run-time Error '-2147417848 (80010108): Method 'SourceObject' of object '_SubForm' failed " from a variety of contexts. How do I shake it? Nothing in MSKB. We're using Source Safe, and even totally rebuilt versions still have the corruption, and it happens on all workstations. Triggered on lines like this: forms!frmPerson!subSection.ControlSource = "frmPerson_SubVolunteer" Steve Capistrant Symphony Information Services scapistrant at symphonyinfo.com www.symphonyinfo.com Phone: 763-391-7400 7308 Aspen Lane North, Suite 132 Brooklyn Park, MN 55428 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com