Results 1 to 2 of 2
  1. #1
    dkj is offline Novice
    Windows XP Access 2003
    Join Date
    Nov 2012
    Posts
    1

    can not change field value by find replace function

    why i can not change my access field value by find and replace command
    some time i can chang this but some time this is not done and a eror come out
    the value you have intered is not valid
    you tried to commit or rollback a transaction without
    Attached Thumbnails Attached Thumbnails access.jpg  

  2. #2
    alansidman's Avatar
    alansidman is offline Indifferent
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,538
    It is not a good database practice to work directly in tables. You should be making these changes through an update query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-07-2012, 07:05 AM
  2. find and replace
    By rohini in forum Access
    Replies: 7
    Last Post: 05-17-2012, 05:23 AM
  3. Find and Replace Within a Macro
    By bmschaeffer in forum Access
    Replies: 1
    Last Post: 12-20-2011, 11:27 AM
  4. Find and Replace
    By Bedsingar in forum Access
    Replies: 1
    Last Post: 08-14-2011, 01:10 PM
  5. Applying a find/replace function
    By Arr in forum Programming
    Replies: 2
    Last Post: 10-12-2009, 12:28 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums