Left$ - Function not defined

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a client on OfficeXP. I am trying to do a couple of updates and fixes
and in one of the queries I am writing (my system is on '03), I am using the
Left$ funtion, like LastInitial: Left$([LastName],1).

When I try to run the query, I get "Left$ - Function Not Defined". Am I
missing something? All of my references are good (in that none are marked
MISSING).

Advice is appreciated.
 
Make sure that the reference for "Visual Basic for applications" and
"Microsoft Access 10.0 Object Library" are checked. When I started working
at my current job, I found that the "Visual Basic for Applications" had been
turned off as the default, leading to many such errors.
 
My MSWord 11.0, MSOutlook 11.0 and Office 11.0 are checked. I also have VBA
checked and VB Extensibility 5.3 checked.

Wouldn't 11.0 checked cover what was necessary in 10.0? If I uncheck 11.0
and check 10.0, my application won't run because of some of the code.

I did a compile and compact as was suggested in a thread from last April.
That did not resolve the problem.

Michael Suttkus said:
Make sure that the reference for "Visual Basic for applications" and
"Microsoft Access 10.0 Object Library" are checked. When I started working
at my current job, I found that the "Visual Basic for Applications" had been
turned off as the default, leading to many such errors.


Pendragon said:
I have a client on OfficeXP. I am trying to do a couple of updates and fixes
and in one of the queries I am writing (my system is on '03), I am using the
Left$ funtion, like LastInitial: Left$([LastName],1).

When I try to run the query, I get "Left$ - Function Not Defined". Am I
missing something? All of my references are good (in that none are marked
MISSING).

Advice is appreciated.
Click to expand...
Click to expand...
 
Yes, those should be sufficient.

Since I haven't worked with the 11.0 object set, you may have to depend on
someone else for answers. My best remaining guess is to remove the $ from
the function. The $ is really a holdover from the old BASIC days when it
identified string functions. In the 10.0 object set, "Left(" works just was
well as "Left$(". Perhaps they decided to stop supporting the older form in
favor of the new one.

Pendragon said:
My MSWord 11.0, MSOutlook 11.0 and Office 11.0 are checked. I also have VBA
checked and VB Extensibility 5.3 checked.

Wouldn't 11.0 checked cover what was necessary in 10.0? If I uncheck 11.0
and check 10.0, my application won't run because of some of the code.

I did a compile and compact as was suggested in a thread from last April.
That did not resolve the problem.

Michael Suttkus said:
Make sure that the reference for "Visual Basic for applications" and
"Microsoft Access 10.0 Object Library" are checked. When I started working
at my current job, I found that the "Visual Basic for Applications" had been
turned off as the default, leading to many such errors.


Pendragon said:
I have a client on OfficeXP. I am trying to do a couple of updates and fixes
and in one of the queries I am writing (my system is on '03), I am using the
Left$ funtion, like LastInitial: Left$([LastName],1).

When I try to run the query, I get "Left$ - Function Not Defined". Am I
missing something? All of my references are good (in that none are marked
MISSING).

Advice is appreciated.
Click to expand...
Click to expand...
Click to expand...
 
I believe that Access 2003 no longer supports the Left$ function. The Left
function does exactly the same thing.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html



Pendragon said:
My MSWord 11.0, MSOutlook 11.0 and Office 11.0 are checked. I also have
VBA
checked and VB Extensibility 5.3 checked.

Wouldn't 11.0 checked cover what was necessary in 10.0? If I uncheck 11.0
and check 10.0, my application won't run because of some of the code.

I did a compile and compact as was suggested in a thread from last April.
That did not resolve the problem.

Michael Suttkus said:
Make sure that the reference for "Visual Basic for applications" and
"Microsoft Access 10.0 Object Library" are checked. When I started
working
at my current job, I found that the "Visual Basic for Applications" had
been
turned off as the default, leading to many such errors.


Pendragon said:
I have a client on OfficeXP. I am trying to do a couple of updates and
fixes
and in one of the queries I am writing (my system is on '03), I am
using the
Left$ funtion, like LastInitial: Left$([LastName],1).

When I try to run the query, I get "Left$ - Function Not Defined". Am
I
missing something? All of my references are good (in that none are
marked
MISSING).

Advice is appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top