By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,500 Members | 830 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,500 IT Pros & Developers. It's quick & easy.

2 more easy-moderate difficult questions

P: n/a
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,searchstring) 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

Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Sat, 24 Jan 2004 22:59:23 GMT, "Jim's wife"
<ta*****@mindspring.com> wrote:
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,searchstring) for both upper and lower and then I do the
replace command. How can I make it so it is not case sensitive? How is it case sensitive? It shouldn't be. What is the code?

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?

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

- Jim

Nov 12 '05 #2

P: n/a
"Jim's wife" <ta*****@mindspring.com> wrote in message news:<fN*********************@news4.srv.hcvlny.cv. net>...
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,searchstring) 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


2. OpenFile API from www.mvps.org/accessweb
Nov 12 '05 #3

P: n/a
Jim's wife wrote:
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,searchstring) for both upper and lower and then I do the
replace command. How can I make it so it is not case sensitive?


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

Nov 12 '05 #4

P: n/a
rkc

"Jim's wife" <ta*****@mindspring.com> wrote in message
news:fN*********************@news4.srv.hcvlny.cv.n et...
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,searchstring) for both upper and lower and then I do the
replace command. How can I make it so it is not case sensitive?


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.
Nov 12 '05 #5

P: n/a
rkc wrote:
"Jim's wife" <ta*****@mindspring.com> wrote in message
news:fN*********************@news4.srv.hcvlny.cv.n et...
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,searchstring) for both upper and lower and then I do the
replace command. How can I make it so it is not case sensitive?


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.


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.

Nov 12 '05 #6

P: n/a
Thanks again all

The 'option compare text' did the trick

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


"Jim's wife" <ta*****@mindspring.com> wrote in message
news:fN*********************@news4.srv.hcvlny.cv.n et...
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,searchstring) 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

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.