John,
THANKYOU! I have completely lost my mind. I forgot the dang way to do the arguments. It's not the ending point, it's the length of the string. Duh duh duh duh duh! I am soooo glad I had your pair of eyeballs.
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, July 25, 2011 2:27 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] crazy making substring stuff
Liz-
The string is obviously only 221 characters long. If you ask for more than is
remaining, you'll get what's left, not what you asked for.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Monday, July 25, 2011 11:15 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: [MS_AccessPros] crazy making substring stuff
Pros, I have been working for a half day Friday and all day today on substring
stuff, and can't seem to debug. Here's what I'm actually finding out in my
immediate window"
?len(mid(rsOpsYN("scrMisc2Inst"),97,197))
125
Isn't that insane?
Has anyone else experienced this?
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar