Forced to move to Access 2007 from 2003. There are several issues keeping my 2003 from working and need to guidance and directions

1. missing Active X .ocx files... a variety of ocx's are missing... Is there a trusted site I can go to download what I am missing

2. TRIM is not recognized .. What's up with that?

trim() should work fine.

Create a new database and try it and see if it works... if it errors then check the VBA references

Which ocx's are you missing?

missing OCX's:

MSADODC.ocx version 6 --- MSADO Date Control 6.0 (SP4) OLEDB
Sheridan Month/year/Datecombo


problems with VB

Date won't work --- Can't find project or library
Trim won't work --- Can't find project or library

have you checked to see if there are any missing references?

When I start MS Access 2007 up and go after the 2003 mdb, the following occurs

a missing or broken reference

IVINavigation.ocx version 1.0
ApproveItForFormDesignAndClient.dll v1.0
FamilyTree_Fac.ocx v1.0
MSADODC.ocx v6.0
SSCALA32.ocx

I click OK through these and then a message box pops up

Undefined function 'Left' in expression

When I activate the switchboard, it goes into Debug mode and errors on this line

Hold_line = "blah, blah, blah" & Date

if i retype that line the debugger goes to a line further down in the code and errors on

me("display_line") = Trim (Test_line)

(note: I cut it short, the two lines work in 2003)

It seems like it's going to be another "highway to [censored]" with MS2007.... I reviewed my code and don't see any need for the ocx's, so I removed them from the reference table. This seems to have fixed the problem on start-up and also with the VB code. Seems like LEFT doesn't work in 2007; but got DATE and TRIM to work.

Now, it seems I have a problem in SWITCHBOARD where the "ON CLICK" event doesn't want to engage. Any thoughts on this or try to rebuild my Switchboard