Jan 26 2010, 03:10 PM
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?
Jan 26 2010, 03:19 PM
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?
Jan 26 2010, 03:38 PM
MSADODC.ocx version 6 --- MSADO Date Control 6.0 (SP4) OLEDB
problems with VB
Date won't work --- Can't find project or library
Trim won't work --- Can't find project or library
Jan 26 2010, 07:36 PM
have you checked to see if there are any missing references?
Jan 27 2010, 07:31 AM
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
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)
Jan 27 2010, 08:48 AM
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
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here