You can't use FIND or REPLACE now

[TechGeek]

Good Morning!
I have a form that includes a Subform which shows orders for each company. When I double click on the date of the order in the subform, it takes me to that specific order for that company. Some how it stopped working. Any ideas?

 

[Jack Cowley]

Did you compact and repair the database? Do you get an errror message? Have you put checked your code by putting in a Stop and seeing where it stops executing?

 

[TechGeek]

Hi Jack
Thanks for replying
I did infact compact and repair, but to no avail. I could send you the database if you like! That might help. I am a novice at this. Let me know. Thanks.

 

[Shadez]

I have had a lot of trouble with the replace function.

every now and again it decides to stop working, rebooting the computer fixed this problem most of the time.

I finaly tracked down the cause of this problem to using the defaut search option with the replace function.


try something like

replace(somestring,"nnn","nNn",,,vbtextcompare)


Hope this helps


ShadeZ

 

[Jack Cowley]

TechGeek -

Post the code you are using to open the form. Also, how does your subject (can't use FIND or REPLACE now) fit into your problem?

Jack