Hi,
Since other forms with the exact same code work, I agree most likely the
specific form has some problem; please feel free to let me know if I can be
any assistant.
Sincerely,
Alick Ye, MCSD
Microsoft Online Partner Support
Get Secure! -
www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "SFAxess" <
[email protected]>
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
|
| Hi Alick,
| Thanks for the follow up.
| I have traced the issue to this statement
| me.Detail.Visible=False (or True, both cause errors)
|
| I think the form was corrupted at some point. Instead of
| hiding the detail, I just hide all of the controls in the
| detail section.
|
| Note that this code worked fine when I wrote it
| originally in 2000, and when moved to 2002. It just
| doesn't work in 2000 now that I have done development in
| 2002. Only 1 form is affected, other forms with this
| exact statement have worked fine.
|
| At some point I may rebuild the form to see if a new
| object will fix it.
| Thanks again
| >-----Original Message-----
| >Hi,
| >
| >Glad to hear that you found a workaround :- ) It seems
| it is a strange
| >issue, would you please provide exact reproduce steps?
| Once we confirm this
| >is a problem I will submit a bug to our development team
| so that they are
| >aware of this issue and can fix it in next release/SR.
| >
| >
| >Sincerely,
| >
| >Alick Ye, MCSD
| >Microsoft Online Partner Support
| >
| >Get Secure! -
www.microsoft.com/security
| >This posting is provided "as is" with no warranties and
| confers no rights.
| >
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "SFAxess" <
[email protected]>
| >|
| >| Thanks for the help Alick!
| >|
| >| I am actually not using any VB Forms, which made me
| >| wonder why Access set a reference to it (I sure didn't)
| >|
| >| I did find a work around to the error, that really had
| >| nothing to do with the code (which I displayed
| >| previously) where execution originally broke?! All
| that I
| >| can surmise is that there is a glitch in that one
| >| particular form object, because it wouldn't let me
| >| reference it properly in a public function i.e.
| >| me.Detail.Visible=MyFunction(Forms("myform")
| ("mysubform"))
| >|
| >| I used the form's class module and the 'me' keyword
| >| instead of passing a reference to the public function
| >| (thus keeping it local)i.e.
| >|
| >| If me.myCheckbox Then
| >| me.Detail.Visible=False
| >| Else
| >| me.Detail.Visible=True
| >| End If
| >| Now it works fine!? The original function is called by
| >| other events in the application without issue, so it
| >| seemed to be specific to this one programmatic
| instance.
| >| Why did everything work fine in Access 2002 (with 2000
| >| file format) and not in Access 2000? I think it is a
| >| glitch in 2002.
| >| I also had tried to import all the object into a new
| ADP
| >| in Access 2000, but the bug was inherent to the object.
| >|
| >| Thanks for your help!
| >|
| >|
| >|
| >|
| >|
| >|
| >| >-----Original Message-----
| >| >Hi,
| >| >
| >| >Do you use the UserForm object in your application?
| If
| >| so, please take a
| >| >look at the article:
| >| >
| >| >ACC2000: Access 2000 Does Not Support the UserForm
| Object
| >| >
http://support.microsoft.com/?id=198646
| >| >
| >| >In addition, could you point out which code line
| causes
| >| the error?
| >| >
| >| >
| >| >Sincerely,
| >| >
| >| >Alick Ye, MCSD
| >| >Microsoft Online Partner Support
| >| >
| >| >Get Secure! -
www.microsoft.com/security
| >| >This posting is provided "as is" with no warranties
| and
| >| confers no rights.
| >| >
| >| >
| >| >
| >| >--------------------
| >| >| Content-Class: urn:content-classes:message
| >| >| From: "SFAxess" <
[email protected]>
| >| >| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
| >| >|
| >| >| Hello,
| >| >| I have been developing an ADP in Access 2000. I
| >| recently
| >| >| upgraded to Access 2002, but have continued
| developing
| >| in
| >| >| the Access 2000 file format within Access 2002.
| >| >| I just started using it on Access 2000 again, and I
| am
| >| >| getting strange errors concerning the Form object.
| I
| >| am
| >| >| getting a 2465 error which states that Access can't
| >| find
| >| >| the field 'Forms' referred to in your expression.
| >| >| The code was working before I upgraded and works
| fine
| >| in
| >| >| Access 2002.
| >| >| The only thing I can trace it to is the reference
| to
| >| the
| >| >| Microsoft Forms 2.0 Object Library which was added
| to
| >| the
| >| >| ADP presumably by Access 2002, but was never used
| >| before.
| >| >| Has anyone heard of a similiar instance when
| >| developing
| >| >| in the Access 2002 for 2000?
| >| >| Thanks for any help you can offer
| >| >|
| >| >
| >| >.
| >| >
| >|
| >
| >.
| >
|
