Left() Function

[arryb]

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" & _
&quot; WHERE (((Left([F1],10))<>'Invoice Na'));&quot;
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!

Thanks
Arry

 

[jrbarnett]

Hello

Open the VBA editor and go to Tools -> References and check for any that are listed as &quot;Missing&quot;. If so, untick them.

John

 

[SQLBI]

Hi,

Further to Johns suggestion, if any are missing, make a note of the reference and try to find the nearest match with your available references.

hope this helps.

Leigh Moore
Solutions 4 MS Office Ltd

http://www.solutions4msoffice.co.uk

 

[arryb]

Thanks for your help guys. I didn't find any missing ones but added in the Microsoft Office object library and it seems to work now!!!

Thanks

Arry