 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / September 2003Strange errors/MS Form 2.0 library
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 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" <no@email.com> [quoted text clipped - 16 lines] | in the Access 2002 for 2000? | Thanks for any help you can offer 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, [quoted text clipped - 38 lines] > >. 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" <no@email.com> [quoted text clipped - 86 lines] | > | >. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.