Results 1 to 6 of 6
  1. #1
    SlenderSmurf is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    3

    Question Creating Macro to Find and Replace

    I wish to create a Macro that finds records and replaces an entry.

    Before
    Sell? In Possession
    YES Present
    Present
    YES Present
    Present


    After


    Sell? In Possession
    YES Sold
    Present
    YES Sold
    Present


    Any guidence on how to do this would be greatly appreciated.

    Mark

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    You would use an Update query normally.

    Use the Query Builder for a select query, then change to update query.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    then the macro would run the update query.

  4. #4
    SlenderSmurf is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2021
    Posts
    3

    Question

    Quote Originally Posted by ranman256 View Post
    then the macro would run the update query.
    Can you explain how to create a Macro. Access is not the most familiar of software for me.

  5. #5
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Create the update query
    Then create the macro to run it with OpenQuery option
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    There are many tutorials for macro coding on the web. I am sure you could find something that would familiarize you with the basics.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Find and Replace in macro
    By perus josh in forum Macros
    Replies: 9
    Last Post: 03-29-2018, 06:08 AM
  2. Find and Replace in macro code
    By chris.emery in forum Macros
    Replies: 1
    Last Post: 10-11-2015, 08:12 AM
  3. Find and Replace in Macro and VB
    By Baldeagle in forum Macros
    Replies: 4
    Last Post: 01-28-2014, 10:32 AM
  4. Find and Replace Macro
    By TrevorM in forum Macros
    Replies: 11
    Last Post: 12-28-2013, 06:11 PM
  5. Find and Replace Within a Macro
    By bmschaeffer in forum Access
    Replies: 1
    Last Post: 12-20-2011, 11:27 AM

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