Compile Error

[wilson51]

I am using Access 2000 on home PC with Win2000.

With many of my input forms I'm using the following code to convert users input into proper case

Private Sub Title_AfterUpdate()
[Title] = StrConv([Title], vbProperCase)
End Sub

On my home PC it works fine.

When I transfer the file to my Laptop (Access 2000 & WinXP) or Work PC (Access2000 & Win 2000) I get the following compile error

"Can't find project or library" with "StrConv" highlighted



How can I fix this?

 

[dk]

Hi,

This is a common problem but normally happens when you move from one version of Access to another, not within the same version. Are they both at the same service pack level?

Anyway, to resolve this go in to the VB editor and click Tools, References. If you can see any references marked as MISSING then uncheck them, click OK and the problem should be fixed. Let us know if that doesn't do it...

 

[wilson51]

Thanks. I did that with the following

"Open the library window
Write down all enabled references
Uncheck all references that access will allow to uncheck
Close and the reopen the references window
Recheck(enable) all of the library references unchecked in the previous step above
Close the library reference"

and yep it worked on both machines