Just loaded Access 2000 on this workstation, and the UCase() and Trim() functions didn't work.
When I Compile the code, the message says "Compile Error - can't find project or Library", and the UCase is highlighted (same for Trim() when I remove the UCase).
Microsoft Common Dialog control (COMDLG32.OCX) is MISSING in References, so I copied it (from another computer) to my Sustem32 directory and registered it using regsvr32.
My question is, why didn't it get installed with Access? Where does it come from? (i mean, what would I have to have installed for it to have been put there without me having to do it manually?)