run time error '3085'

[istone]

Hi,
I am sure you heard of this error before. I did a search but I could not come up with a solution.

When I run this query on my pc it's fine, but when I try to run it on somebody else pc I get this error:
Run time error '3085'
undefined function 'Left in expression'

I checked for any missing references in the pc but found none. The only difference I found is this reference for me read: Microsoft access 11.0 Object library
and for the other pc: Microsoft access 9.0 Object library

Could that be the problem?

INSERT INTO tblAssetsParticipantCombined ( PlanID, [Plan Name], [Part# Count], [Computed asset balance], PP )
SELECT Min(tblPlanAssests.[Plan ID]) AS PlanID, Min(tblNumberOfParticipants.[Plan Name]) AS [MinOfPlan Name], Sum(tblNumberOfParticipants.[Part# Count]) AS [SumOfPart# Count], Sum(tblPlanAssests.[Balance Amount]) AS [Computed asset balance], Left(tblPlanAssests![Plan ID],2) AS Form
FROM tblPlanAssests INNER JOIN tblNumberOfParticipants ON tblPlanAssests.[Plan ID] = tblNumberOfParticipants.[Plan ID]
GROUP BY Left(tblPlanAssests![Plan ID],2)
HAVING (((Min(tblPlanAssests.[Plan ID]))="GLC" Or (Min(tblPlanAssests.[Plan ID]))="GLCB" Or (Min(tblPlanAssests.[Plan ID]))="GLNQ") AND ((Sum(tblPlanAssests.[Balance Amount])) Is Not Null))
ORDER BY Min(tblNumberOfParticipants.[Plan Name]);

thanks in advance

 

[VRoscioli]

Have a look here:

http://database.ittoolbox.com/groups/technical-functional/access-l/function-left-not-found-70675

It seems like it could be a problem with a DLL version.


-V

 

[lameid]

I didn't see the solution there in less than 30 seconds so...

Open any module.
On the Tools Menu select references.
Investigate and resolve anything that is missing... It will begin "Missing:"

Also there are a couple default references you should have...

Visual Basic For Applications
Micrsoft Access <Version> Object Library
OLE Automation

You should also have either a DAO and or ActivX Data objects library.

 

[istone]

Thanks. I did not see a solution on the ittoolbox site.

Lameid, I already checked the missing references did not see any, all default references are there except the difference of access 11 and access 9 version.

 

[PHV]

Does the DB compile properly ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[istone]

yes it does

 

[PHV]

On BOTH pc ?

 

[istone]

this button that i run include 6 queries, they all work on my pc. on the other pc all works except the one I am trying to solve.

 

[VRoscioli]

From the page I previously cited:

A related problem was listed here a few months ago. I believe is has to do with a dll version problem in comcat.dll or comctl32.dll. My left() function works fine under windows 2000, my versions are:

Comcat.dll version 5.0.2195.1
Comctl32.dll version 5.81.4704.1100

You can get dll info from:

http://support.microsoft.com/servicedesks/fileversion/dllinfo.asp?sd=MSDN

Have you checked this?


-V