2 more easy-moderate difficult questions

[Jim's wife]

Thanks for all your help, you have been helpful and very knowledgeable.

Here are two more for you

1. I am trying to replace a small portion of a large string (memo field),
but I notice it is case sensitive. So I have to test for the two cases, ie.
if instr(string,se archstring) for both upper and lower and then I do the
replace command. How can I make it so it is not case sensitive?

2. How can I set sometihng up on an access 2002 form that will allow the
user to browse to a directory and select a file? Something with the tree
object?

THanks again

[Jim Allensworth]

Re: 2 more easy-moderate difficult questions

On Sat, 24 Jan 2004 22:59:23 GMT, "Jim's wife"
<tabitha@mindsp ring.com> wrote:
[color=blue]
>Thanks for all your help, you have been helpful and very knowledgeable.
>
>Here are two more for you
>
>1. I am trying to replace a small portion of a large string (memo field),
>but I notice it is case sensitive. So I have to test for the two cases, ie.
>if instr(string,se archstring) for both upper and lower and then I do the
>replace command. How can I make it so it is not case sensitive?[/color]
How is it case sensitive? It shouldn't be. What is the code?
[color=blue]
>
>2. How can I set sometihng up on an access 2002 form that will allow the
>user to browse to a directory and select a file? Something with the tree
>object?
>[/color]

http://www.mvps.org/access/api/api0001.htm

- Jim

[Pieter Linden]

Re: 2 more easy-moderate difficult questions

"Jim's wife" <tabitha@mindsp ring.com> wrote in message news:<fNCQb.160 34$O22.9409870@ news4.srv.hcvln y.cv.net>...[color=blue]
> Thanks for all your help, you have been helpful and very knowledgeable.
>
> Here are two more for you
>
> 1. I am trying to replace a small portion of a large string (memo field),
> but I notice it is case sensitive. So I have to test for the two cases, ie.
> if instr(string,se archstring) for both upper and lower and then I do the
> replace command. How can I make it so it is not case sensitive?
>
> 2. How can I set sometihng up on an access 2002 form that will allow the
> user to browse to a directory and select a file? Something with the tree
> object?
>
> THanks again[/color]

2. OpenFile API from www.mvps.org/accessweb

[Salad]

Re: 2 more easy-moderate difficult questions

Jim's wife wrote:
[color=blue]
> Thanks for all your help, you have been helpful and very knowledgeable.
>
> Here are two more for you
>
> 1. I am trying to replace a small portion of a large string (memo field),
> but I notice it is case sensitive. So I have to test for the two cases, ie.
> if instr(string,se archstring) for both upper and lower and then I do the
> replace command. How can I make it so it is not case sensitive?[/color]

See Strcomp() function. use the binary compare option.

[rkc]

Re: 2 more easy-moderate difficult questions


"Jim's wife" <tabitha@mindsp ring.com> wrote in message
news:fNCQb.1603 4$O22.9409870@n ews4.srv.hcvlny .cv.net...[color=blue]
> Thanks for all your help, you have been helpful and very knowledgeable.
>
> Here are two more for you
>
> 1. I am trying to replace a small portion of a large string (memo field),
> but I notice it is case sensitive. So I have to test for the two cases,[/color]
ie.[color=blue]
> if instr(string,se archstring) for both upper and lower and then I do the
> replace command. How can I make it so it is not case sensitive?[/color]

Do you have Option Compare Binary declared at the top of the
code module? If so put the cursor on the end of that line, hit F1
and read the help file.

[Salad]

Re: 2 more easy-moderate difficult questions

rkc wrote:
[color=blue]
> "Jim's wife" <tabitha@mindsp ring.com> wrote in message
> news:fNCQb.1603 4$O22.9409870@n ews4.srv.hcvlny .cv.net...[color=green]
> > Thanks for all your help, you have been helpful and very knowledgeable.
> >
> > Here are two more for you
> >
> > 1. I am trying to replace a small portion of a large string (memo field),
> > but I notice it is case sensitive. So I have to test for the two cases,[/color]
> ie.[color=green]
> > if instr(string,se archstring) for both upper and lower and then I do the
> > replace command. How can I make it so it is not case sensitive?[/color]
>
> Do you have Option Compare Binary declared at the top of the
> code module? If so put the cursor on the end of that line, hit F1
> and read the help file.[/color]

It would be better to put that in a separate module for routines that use
binary compare only....or else use Strcomp(). Changes the Compare may affect
other subs or routines unncessarily with adversely.

[Jim's wife]

Re: 2 more easy-moderate difficult questions

Thanks again all

The 'option compare text' did the trick

Thanks
PS. I posted a new question, take a look




"Jim's wife" <tabitha@mindsp ring.com> wrote in message
news:fNCQb.1603 4$O22.9409870@n ews4.srv.hcvlny .cv.net...[color=blue]
> Thanks for all your help, you have been helpful and very knowledgeable.
>
> Here are two more for you
>
> 1. I am trying to replace a small portion of a large string (memo field),
> but I notice it is case sensitive. So I have to test for the two cases,[/color]
ie.[color=blue]
> if instr(string,se archstring) for both upper and lower and then I do the
> replace command. How can I make it so it is not case sensitive?
>
> 2. How can I set sometihng up on an access 2002 form that will allow the
> user to browse to a directory and select a file? Something with the tree
> object?
>
> THanks again
>
>
>[/color]