Why are Functions Missing?

  • Thread starter Thread starter John Lane
  • Start date Start date
J

John Lane

I installed Office Professional 2007 on Windows Vista Home Preminum Edition
and find Access is missing functions like UBound and Split. Ay idea why this
happened? Thanks.
 
Probably a broken reference. Try this: Open Access. Press Ctrl + g at the
same time. In the Immediate Window put: Debug.Print Date() and and press
Enter.
If that causes an error instead of returning a date, most likely a broken
reference.

Go to the following web page for information on checking references:
http://www.mvps.org/access/bugs/bugs0001.htm
 
I did a little more checking and found the VBA dll is VBE6.DLL with a date
modified of of 9/30/2006 in the Microsoft Shared/VBA folder. I also noticed
when I open the Tools/References in a Module, there are multiple Visual Basic
for Applications libraries shown. Help!
 
I did even more checking and saw the other VBS libraries are in
Windows/system32 and have the following names: VBAEN32.OLB, msvbam60.dll,
VBAEND32.OLD and VEN2232.OLB. Does anyone know which, if any is the right
one? Also, I tried to remove the VBA library and it woulnd't let me, even in
a blank database - and neither could I replace it with one of the others.
Help!
 
Back
Top