[AccessD] A2K3 vs A2K7?

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Thu May 15 00:14:32 CDT 2008


Darryl:

The error is not dependably reproducible.  Seems random.  He's running over
a network with other users.  I wonder if it could be related to that. 

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 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
 




More information about the AccessD mailing list