Left() Function

[Arry]

I am running code in Access 97 as follows.

SQL = "INSERT INTO [Tbl_Adjustments_Data] ( [Invoice Number], [Invoice Period], Type, Type2, Comments, [Date From/For], [Charge (£)] )" & _
" SELECT Left([F1],10) AS [Invoice Name], Right([F1],4) AS [Invoice Period], TempAdjustment.F2, TempAdjustment.F3, TempAdjustment.F4, TempAdjustment.F5, TempAdjustment.F6 FROM TempAdjustment" & _
" WHERE (((Left([F1],10))<>'Invoice Na'));"
dbs.Execute SQL

The code works and has been running fine.

My problem is that i have just changed computers and the Left() function errors. It is present in the built in functions of a query design window but will not run from there either. I just get the error that the function is not available. Any Ideas !!!!

Many Thanks
Arry

 

[chenn]

If there are no major differences in the PC, then I would uninstall and reinstall access. If this isn't an option, or too time consuming, you could write your own left function. Call it LeftNew or something. But that is an access error, probably in your VBA reference. Also, check for any missing references. Sometimes a missing reference will break other "Access" functions.

 

[Travis]

You either have a missing reference or need to refresh your references.

To refresh your references simply remove a reference, close the reference screen and then add the reference back in.

 

[Arry]

Thanks for your help. It seems to be working okay now.

Thanks

Arry