Strange errors/MS Form 2.0 library

[SFAxess]

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

 

[Alick [MSFT]]

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
|

 

[SFAxess]

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!