Search results

  1. C

    Replace works in one DB, error in another

    Finally found the source of the trouble: one database contained an old module with defective code (some lines were red) which had long since been discarded but never deleted. It had gone unnoticed because it had never affected the operation of the DB until I tried to add these functions. Now...
  2. C

    Replace works in one DB, error in another

    just installed SP 3, problem remains.
  3. C

    Replace works in one DB, error in another

    CJ, thank you for your response. I have now imported the table from one DB into the other, and have exactly the same table and query in both databases. The Replace function causes an error message in one, and works perfectly in the other. The only difference in the two databases which I can see...
  4. C

    Replace works in one DB, error in another

    Hi, I am new to this forum, and am still using Access 2003. The following code in a query design window: MyNewString: Replace([MyString],"a","x") replaces all a's with x's in one .mdb database on my computer, but in another similar database it displays the error "Syntax Error in the Visual...
Back
Top Bottom