[AccessD] A2K3 vs A2K7?

Charlotte Foust cfoust at infostatsystems.com
Thu May 15 18:32:20 CDT 2008


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




More information about the AccessD mailing list