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
[email protected]
"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
|
|
|
