Right function in Access 2007?

[Kamil Dursun]

Hi everybody,

I just purchased MS-Office 2007 and I am having trouble running old VBA
routines.

It does not accept a line with Right(StringName,Length) function. I tried to
locate the reference to VBA and it is there.

Any help appreciated.

All the best
Kamil

 

[Scott McDaniel]

Hi everybody,

I just purchased MS-Office 2007 and I am having trouble running old VBA
routines.

It does not accept a line with Right(StringName,Length) function. I tried to
locate the reference to VBA and it is there.

Check all references to verify that none are marked as MISSING. If they are, note which ones they are and uncheck them,
close and reopen the reference dialog and then find and recheck the missing refs. Even though Access complains about the
Right function, often it's another library causing the problem.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

 

[Aaron Kempf]

yes; Access 2007 doesn't include DAO and a lot of dorks stll use DAO

I would reccomend rewriting it as ADO and Access Data Projects

Check all references to verify that none are marked as MISSING. If they

are, note which ones they are and uncheck them,

close and reopen the reference dialog and then find and recheck the

missing refs. Even though Access complains about the