[AccessD] A2K3 vs A2K7?

Are all the computers running Office 2007 at the same version level?  We
were having intermittent weird errors like this and discovered that there
was a version level discrepancy between two of the Office 2007 computers.
Fixing this fixed most, but not all, of the errors.

Doug Steele

On Wed, May 14, 2008 at 10:14 PM, Rocky Smolin at Beach Access Software <
rockysmolin at bchacc.com> wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>