[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Find and Replace not working on a form within DataSheet view

I have a form that displays several fields using a Datasheet view.

If I change something manually everything - no problem.  However, if I use the Find & Replace function, I can see everything change as it should on the screen, but when I reload the form - the changes have not been stored.

Any ideas (it's confused the heck out of me)?
0
Andy Brown
Asked:
Andy Brown
  • 3
  • 2
1 Solution
 
GRayLCommented:
If you examine your table more closely you will probably find you have set an index on the field you are updating and when you re-open the form, if you scroll long enough you will find your edited records.
0
 
GRayLCommented:
I have a table with over 15000 records and only three values in the first field, indexed and copies allowed.  I changed 3 records, closed the form, reopened and the 'changed' fields seemed to have disappeared.  However after scrolling to the bottom of that particular value I found the three records I had changed using the Replace tool.
0
 
Andy BrownDeveloperAuthor Commented:
Thanks for your response on this, but that isn't it.  I have setup some test records that I always check and it's definately not working (with the Find & Replace function).  I have found via Google, that this is a known issue - but have yet to find a solution.

I am probably going to write a work-around unless someone comes up with a genius idea.

Thanks again.
0
 
Andy BrownDeveloperAuthor Commented:
In the end I simply created used query and modified the task bar to limit control.

This worked perfectly - thank again for your help on this.
0
 
GRayLCommented:
Thanks, wish I had helped ;-)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now