Using "Left"

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

Guest

When I use following:

Dim astring as string
astring = Left(Name,3)

I get an errormessage:
"Can´t find project of library"

I have tried to re-install with no change! - what is going on?
 
I have a similar problem - I have one database with a function that uses the
LEFT$ command. When I attempted to use this same function in a new database,
I find that I am unable to. I receive error messages telling me that an
invalid number of arguments were supplied, or a 'type-declaraction character
does not match the declared data type'.

I have double/triple checked the list of references, to ensure that the same
references are checked for both databases. Still, this function does not
work.....

How can I determine what the missing reference truly is? Why would the list
of references be the same, and yet one database functions correctly, and
another does not?

Any help here would be greatly appreciated!
 
Have you used Left as a name for anything in the second database: a field
name, a control name, a variable name, etc?
 
Doug,

I double checked, just to make sure... But no, I have not used "Left" in any
way, except in the command. Specifically, the command is:

Forms![Login].UserName.Value = Left(sBuffer, lSize)

Where sBuffer is a string of 255, and lsize is the length of sBuffer

DC
 
So you've checked the references, and nothing shows up as Missing?

See whether Forms![Login].UserName.Value = VBA.Left(sBuffer, lSize) helps

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


DC said:
Doug,

I double checked, just to make sure... But no, I have not used "Left" in any
way, except in the command. Specifically, the command is:

Forms![Login].UserName.Value = Left(sBuffer, lSize)

Where sBuffer is a string of 255, and lsize is the length of sBuffer

DC
Douglas J. Steele said:
Have you used Left as a name for anything in the second database: a field
name, a control name, a variable name, etc?
Click to expand...
Click to expand...
 
Yep, that did the trick! Thanks so much for that tip. This problem was
literally driving me nuts.

Thanks!
DC

Douglas J Steele said:
So you've checked the references, and nothing shows up as Missing?

See whether Forms![Login].UserName.Value = VBA.Left(sBuffer, lSize) helps

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


DC said:
Doug,

I double checked, just to make sure... But no, I have not used "Left" in any
way, except in the command. Specifically, the command is:

Forms![Login].UserName.Value = Left(sBuffer, lSize)

Where sBuffer is a string of 255, and lsize is the length of sBuffer

DC
Douglas J. Steele said:
Have you used Left as a name for anything in the second database: a field
name, a control name, a variable name, etc?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have a similar problem - I have one database with a function that uses
the
LEFT$ command. When I attempted to use this same function in a new
database,
I find that I am unable to. I receive error messages telling me that an
invalid number of arguments were supplied, or a 'type-declaraction
character
does not match the declared data type'.

I have double/triple checked the list of references, to ensure that the
same
references are checked for both databases. Still, this function does not
work.....

How can I determine what the missing reference truly is? Why would the
list
of references be the same, and yet one database functions correctly, and
another does not?

Any help here would be greatly appreciated!

:

Hi,
please look here:
http://www.mvps.org/access/bugs/bugs0001.htm

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


When I use following:

Dim astring as string
astring = Left(Name,3)

I get an errormessage:
"Can?t find project of library"

I have tried to re-install with no change! - what is going on?
Click to expand...
Click to expand...
Click to expand...
 
The fact that being explicit solved the problem doesn't mean that there
isn't still an issue with your application.

I'd suggest looking hard to ensure that you don't use Left anywhere else in
the application, or that there isn't a References problem.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



DC said:
Yep, that did the trick! Thanks so much for that tip. This problem was
literally driving me nuts.

Thanks!
DC

Douglas J Steele said:
So you've checked the references, and nothing shows up as Missing?

See whether Forms![Login].UserName.Value = VBA.Left(sBuffer, lSize) helps

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


DC said:
Doug,

I double checked, just to make sure... But no, I have not used "Left"
in any
way, except in the command. Specifically, the command is:

Forms![Login].UserName.Value = Left(sBuffer, lSize)

Where sBuffer is a string of 255, and lsize is the length of sBuffer

DC
:

Have you used Left as a name for anything in the second database: a field
name, a control name, a variable name, etc?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



I have a similar problem - I have one database with a function that uses
the
LEFT$ command. When I attempted to use this same function in a new
database,
I find that I am unable to. I receive error messages telling me
that an
invalid number of arguments were supplied, or a 'type-declaraction
character
does not match the declared data type'.

I have double/triple checked the list of references, to ensure that the
same
references are checked for both databases. Still, this function
does not
work.....

How can I determine what the missing reference truly is? Why would the
list
of references be the same, and yet one database functions
correctly, and
another does not?

Any help here would be greatly appreciated!

:

Hi,
please look here:
http://www.mvps.org/access/bugs/bugs0001.htm

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


When I use following:

Dim astring as string
astring = Left(Name,3)

I get an errormessage:
"Can?t find project of library"

I have tried to re-install with no change! - what is going on?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top