Invalid Functions

[legendv]

Yesterday in various locations I used the =date() and UCase functions. Yesterday those functions worked,,,,all day,,, without a problem.
After compacting the database, zipping it, putting it onto another pc, unzipping it and opening it. Now I get error messages saying
"Undefined function 'UCase'in expression". What could have happened? Could the autocorrect text feature have caused it? I know that must sound silly.

 

[cpod]

You have a problem with the references on the pc you moved to.

Go to the VB editor, tools, references and uncheck anything that says "Missing".

 

[boblarson]

Umm, the uncheck portion is correct, but you still have to go back and add the missing reference back in. Otherwise it will not work as well.

You're most likely suffering from a MISSING reference.
Click on the reference that is listed as MISSING (not on the checkbox). If you click on the reference it will show you in a gray area below which file you should be looking for.
The most common one for the Mid, Left, and Right function problem is: Comctl32.ocx
So, uncheck the check box for the missing reference, close the dialog box. Open it up again by selecting Tools / References and then click the BROWSE button.
Go to the place where your file should be (for Comctl32.ocx I believe it will be in the Windows/System folder.
Select it and shut the dialogs. It should work now.

BL
hth

 

[legendv]

Fixed it, thanks!!!!!!!!
When I looked in there, I remembered I did install an animated gif reference yesterday. Maybe that kicked out the other one or something. I did have to uncheck the gif animation to get it to work. Thanks so much for the help.