Deleting last word from string.

  • Thread starter Thread starter HarveyDeloya
  • Start date Start date
H

HarveyDeloya

I posted this reply a couple of days ago, and the
response was to use InstrRev. It didn't work in an
update query, probably because I use Access 2000 on
windows 2000 and access didn't recognize the command. Any
help would be appreciated. I want to eliminate the last
word. Please try it out before answering. Below are the
examples.

Four addresses and what I want the update field to look
like.

123 Main Street 123 Main
345 East 25th Avenue 345 East 25th
678 North St. Marks Road 678 North St. Marks
 
Hi,

Your issue is related to the following knowledge base article:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;225956

Your workaround would be:

Create a custom function in a module that uses the built-in Visual Basic
for Applications function. Then call this function where you need the
expression. For example, create the following function

Function MyInStrRev(strRev)
MyInStrRev = InstrRev(strRev, stringmatch[, start[,
compare]])
End Function

After you have created the function as it was recommended in the previous
post in your UpdateQuery do something like

UpDateTo: MyInStrRev([fieldName])

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| Content-Class: urn:content-classes:message
| From: "HarveyDeloya" <[email protected]>
| Sender: "HarveyDeloya" <[email protected]>
| Subject: Deleting last word from string.
| Date: Wed, 16 Jun 2004 15:51:51 -0700
| Lines: 16
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcRT9INundE4+WM2SCq1mOrylkhJlg==
| Newsgroups: microsoft.public.access.gettingstarted
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.gettingstarted:151079
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.access.gettingstarted
|
| I posted this reply a couple of days ago, and the
| response was to use InstrRev. It didn't work in an
| update query, probably because I use Access 2000 on
| windows 2000 and access didn't recognize the command. Any
| help would be appreciated. I want to eliminate the last
| word. Please try it out before answering. Below are the
| examples.
|
| Four addresses and what I want the update field to look
| like.
|
| 123 Main Street 123 Main
| 345 East 25th Avenue 345 East 25th
| 678 North St. Marks Road 678 North St. Marks
|
|
|
 
Back
Top