William Hindman
wdhindman at dejpolsystems.com
Thu May 15 20:41:42 CDT 2008
"installing it and running weeping into the corner doesn't count, does it?" Charlotte ...probably not since that would make more than a few of us guilty :( William "The truth is incontrovertible, malice may attack it, ignorance may deride it, but in the end; there it is." -------------------------------------------------- From: "Charlotte Foust" <cfoust at infostatsystems.com> Sent: Thursday, May 15, 2008 8:42 PM To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: Re: [AccessD] A2K3 vs A2K7? > Well, I'll be the first to admit I've never worked with 2007 (installing > it and running weeping into the corner doesn't count, does it?), so I > don't know what's going on behind the scenes. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > at Beach Access Software > Sent: Thursday, May 15, 2008 5:15 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] A2K3 vs A2K7? > > Charlotte: > > Just before the Me.Requery ActiveControl.Name is a text box on the main > form. > > I put in a msgbox for a text box on the sub-form and got the same > message. > Apparently Access 2007 thinks that, at that point, the subform is > closed. > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > www.bchacc.com > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte > Foust > Sent: Thursday, May 15, 2008 4:32 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2K3 vs A2K7? > > Screen.ActiveControl? > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > at Beach Access Software > Sent: Thursday, May 15, 2008 3:20 PM > To: 'Access Developers discussion and problem solving' > Cc: 'Jack Stone' > Subject: Re: [AccessD] A2K3 vs A2K7? > > Well, I agree Charlotte. Me should just refer to the subform; > Me.Requery should refer to the RecordSource of the subform. But Darryl > was speculating that perhaps an explicit call > > This works perfectly in A2K3. Fails consistently in A2K7. I just tried > it myself with A2K7 (loathe as I am to even fire it up). And got it to > fail. > > Then I tried converting the mdb to A2K7 format. And got the same result > with an accdb. Something really screwy going on there but darned if I > can figure out what it might be. > > To try to find out what Me. was referring to at that point I put in > MsgBox Me.Name but in A2K7 that gives an error message as well - Invalid > procedure call or argument > > In A2K3 MsgBox Me.Name displays "Matters_GroupMatters" which is the > correct name of the sub-form. > > On the theory that it might have something to do with a library, here's > the references in A2K7 of the accdb which fails: > > Visual Basic for Applications > Microsoft Access 12.0 Object Library > OLE Automation > Microsoft CDO for Windows 2000 library > MicrosoftCalendarControl 11.0 > Microsoft Visual Basic for Applications Extensibility 5.3 Microsoft > Office 12.0 Access database engine Object library > > The references for the A2K3 mdb are the same except for the addition of > > Microsoft DAO 3.6 Object Library > > When I try to add DAO 3.6 to the references in the A2K7 accdb I get Name > conflicts with existing project, module or library. > > Any ideas? > > Regards, > > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > www.bchacc.com > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte > Foust > Sent: Thursday, May 15, 2008 2:37 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2K3 vs A2K7? > > I don't understand, Rocky. If you're calling the code behind the > subform and trying to requery the subform, there's no reason to refer to > the parent at all. Me.Requery should be the right construction. Put a > breakpoint in and find out what Me points to at that point. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > at Beach Access Software > Sent: Thursday, May 15, 2008 2:28 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] A2K3 vs A2K7? > > Darryl: > > I'm using > > Forms!Matters.Matters_GroupMatters.Form.Requery > > But get an "application-defined or object-defined error" which usually > means the wrong syntax. This is being called from a module behind the > sub form. Main form is Matters; sub form is Matters_GroupMatters. I'm > trying to requery the subform. > > > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > www.bchacc.com > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl > Collins > Sent: Wednesday, May 14, 2008 9:41 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2K3 vs A2K7? > > > Hey Rocky, > > Just as a guess, have you tried to reference the sub form specifically? > > [Forms]![frm_MainForm].[frm_SubForm].[Form].requery > > I find this approach is less flakey than using Me.whatever. > > regards > Darryl. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin > at Beach Access Software > Sent: Thursday, 15 May 2008 2:30 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] A2K3 vs A2K7? > > > Dear List: > > I have an app in development in 2003. My client tests it in 2007 and > occasionally we find something that works in A2K3 and not in A2K7. > > Now I have a statement in a subform on a form and after manipulating the > data in the table that is the recordsource for the sub-form I issue a > Me.Requery. Which works in A2K3. But when he tries it in A2K7 he gets > an error "2467: The expression you entered refers to an object that is > closed or doesn't exist". Since the object, in this case the sub-form, > is open and does exists, I think the error might be misleading and may > actually be a result of some other condition. But I don't know. > > Has anyone seen this behavior? Any theories? > > MTIA > > Rocky > > > > > > > > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > This email and any attachments may contain privileged and confidential > information and are intended for the named addressee only. If you have > received this e-mail in error, please notify the sender and delete this > e-mail immediately. Any confidentiality, privilege or copyright is not > waived or lost because this e-mail has been sent to you in error. It is > your responsibility to check this e-mail and any attachments for > viruses. No warranty is made that this material is free from computer > virus or any other defect or error. Any loss/damage incurred by using > this material is not the sender's responsibility. The sender's entire > liability will be limited to resupplying the material. > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.16/1433 - Release Date: > 5/14/2008 > 4:44 PM > > > -- > 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 > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.16/1433 - Release Date: > 5/14/2008 > 4:44 PM > > > -- > 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 > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.16/1433 - Release Date: > 5/14/2008 > 4:44 PM > > > -- > 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 >