Access 2003 Query VBA error under Vista

[Matt Slattery]

Any help would be sincerely appreciated,

I have an Access 2003 MDB that works fine under fully patched WinXP system.
However the same 2003 MDB is throwing an error under an up to date Vista
Business OS.

I have a UDF written in VBA that displays some data on the main form.
On the Vista PC I receive a Run Time Error ...
"Function is not available in expressions in query expression
'Left([ccnContainerType], 2)'"

Does anyone have any idea as to why Vista is doing this?

Thanks in advance
Matt

 

[Marshall Barton]

Any help would be sincerely appreciated,

I have an Access 2003 MDB that works fine under fully patched WinXP system.
However the same 2003 MDB is throwing an error under an up to date Vista
Business OS.

I have a UDF written in VBA that displays some data on the main form.
On the Vista PC I receive a Run Time Error ...
"Function is not available in expressions in query expression
'Left([ccnContainerType], 2)'"

Does anyone have any idea as to why Vista is doing this?

Check the References on the problem system (VBA window
Tools - References menu). You'll probably find that one of
them was not installed or was installed in a different
place.

 

[Matt Slattery]

Any help would be sincerely appreciated,

I have an Access 2003 MDB that works fine under fully patched WinXP system.
However the same 2003 MDB is throwing an error under an up to date Vista
Business OS.

I have a UDF written in VBA that displays some data on the main form.
On the Vista PC I receive a Run Time Error ...
"Function is not available in expressions in query expression
'Left([ccnContainerType], 2)'"

Does anyone have any idea as to why Vista is doing this?

Check the References on the problem system (VBA window
Tools - References menu). You'll probably find that one of
them was not installed or was installed in a different
place.

All references have been compared between XP and Vista machine. All
references are identical and in same order.

Has anyone had any similar issues if not identical?

 

[Matt Slattery]

Any help would be sincerely appreciated,

I have an Access 2003 MDB that works fine under fully patched WinXP
system.
However the same 2003 MDB is throwing an error under an up to date
Vista Business OS.

I have a UDF written in VBA that displays some data on the main form.
On the Vista PC I receive a Run Time Error ...
"Function is not available in expressions in query expression
'Left([ccnContainerType], 2)'"

Does anyone have any idea as to why Vista is doing this?

Check the References on the problem system (VBA window
Tools - References menu). You'll probably find that one of
them was not installed or was installed in a different
place.

All references have been compared between XP and Vista machine. All
references are identical and in same order.

Has anyone had any similar issues if not identical?

For those that may have experienced something similar ...

The solution came from an Access 97 article on the Microsoft KB site

Answer:
Register any reference at all that you don't already have registered.
Close and open the DB
Unregister that reference
Close and open the DB

http://support.microsoft.com/kb/194374