Chr(0) throws and error
- Thread starter DanielR
- Start date
- Local time
- Today, 12:11
- Joined
- Jan 23, 2006
- Messages
- 15,499
What does chr(0) mean to you? -that is what is your intent with -
Are you reading some file? If so could you tell us about the data in that file?
Code:
[COLOR="DarkOrchid"]GetLogonName = Left(lpBuff, InStr(lpBuff, Chr(0)) - 1)[/COLOR]Are you reading some file? If so could you tell us about the data in that file?
- Local time
- Tomorrow, 04:11
- Joined
- Jan 20, 2009
- Messages
- 12,834
Chr(0) returns the Null character. I expect the code is looking to remove the last character from a Null terminated string if it is present.
The expression will throw an error is there is no Null in the string because Instr would return zero passing a -1 to Left().
When searching for an optionally present character, always concatenate the search character onto the end of the string to avoid errors if it isn't already present.
The expression will throw an error is there is no Null in the string because Instr would return zero passing a -1 to Left().
When searching for an optionally present character, always concatenate the search character onto the end of the string to avoid errors if it isn't already present.
Code:
GetLogonName = Left(lpBuff & Chr(0), InStr(lpBuff & Chr(0), Chr(0)) - 1)
- Local time
- Today, 11:11
- Joined
- Feb 28, 2001
- Messages
- 30,560
To be pedantically correct, Galaxiom, Chr(0) returns the NUL character, using the US-ASCII name for that particular bit pattern. We might colloquially call it Null, but it really isn't Null, it is NUL.
If Chr(0) actually returned a Null, then you would probably get "Invalid use of null" as an error. Speaking of which, ...
DanielR - you say you get an error and you told us where. But you didn't identify WHICH error you get. Please advise us.
If Chr(0) actually returned a Null, then you would probably get "Invalid use of null" as an error. Speaking of which, ...
DanielR - you say you get an error and you told us where. But you didn't identify WHICH error you get. Please advise us.
The error came up when I deployed the access app to another machine using SSE Setup -> exe file install, etc.
I also got a missing: Microsoft office 15.0 object library
This might be causing the chr(0) error.
I have split the database into front end and back end.
I wound up creating a shortcut to the front end and coping that onto users machine and it works fine. No Chr(0) errors.
I also got a missing: Microsoft office 15.0 object library
This might be causing the chr(0) error.
I have split the database into front end and back end.
I wound up creating a shortcut to the front end and coping that onto users machine and it works fine. No Chr(0) errors.
I installed Microsoft runtime for access2013...I developed the app in access 2013. They should have been in line with each other. How do you perform late binding? Would that just be going into the reference section of the app and binding?
