Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu May 15 17:20:23 CDT 2008
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