Re: How to split a field into parts

From: John Nurick (j.mapson.nurick_at_dial.pipex.com)
Date: 03/08/05 

Date: Tue, 8 Mar 2005 15:04:33 -0000

"Brendan Reynolds" <anonymous at discussions dot microsoft dot com> wrote in
message news:%239G1399IFHA.4092@tk2msftngp13.phx.gbl...
> InStrRev *is* in Access 2000 - it was one of the new string functions that
> were added to VBA 6, and Access 2000 was the first version to use VBA 6.
> Some of those new functions could not be used directly in a query, though,
> and I believe InStrRev was one of those. You'd have to write a custom VBA
> function to call InStrRev, and then call the custom function from your
> query.

These functions seem to be properly available on Office 2000 installations
with recent service packs and/or Jet versions (I've never really used Office
2000 and don't know the details.)

Relevant Pages

  • Re: ARGH! SQL query sorted by last name when all I have is full name?
    ... I'd recommend changing the table to have separate fields ... You could then use a query using InStrRev to ... parse the existing data *within Access* before trying to use it in your ASP ... > engine doesn't support the InstrRev function... ...
    (microsoft.public.access.queries)
  • Re: InstrRev error
    ... "david" wrote: ... InstrRev was a VB function that was only added to Access VBA ... there was a list of safe expressions that you can use in a query. ...
    (microsoft.public.access.queries)
  • Re: InstrRev error
    ... InstrRev was a VB function that was only added to Access VBA ... there was a list of safe expressions that you can use in a query. ... Unless you allow unsafe expressions, ...
    (microsoft.public.access.queries)
  • Re: for
    ... >> Steve Clark, Access MVP ... >>> into a query and this gave me exactly what I was looking for ... ... >>> 'InStrRev' in expression. ... >>> Chris ...
    (microsoft.public.access.queries)
  • Re: for
    ... I try to grab the records from this query into an Excel workbook using odbc ... > InStrRev ... > Public Function MyInstrRev(strIN As String, strMatch As String, _ ...
    (microsoft.public.access.queries)