Results 1 to 2 of 2
  1. #1
    BrianF is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2011
    Posts
    6

    SetValue Macro


    I need to set the value of my 'City' field in my database. I have some 1300 records, and they all need to be set as the same. What is the best way to do this? Can i even use the SetValue action?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    An update query would be the easiest way to set them all.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 10
    Last Post: 08-01-2012, 11:32 AM
  2. Any replacement for the old SetValue
    By toniartist in forum Access
    Replies: 1
    Last Post: 03-17-2012, 08:58 PM
  3. SetValue Macro action
    By rkalapura in forum Programming
    Replies: 3
    Last Post: 12-19-2011, 11:54 AM
  4. No SetValue in Macro editor
    By asabri in forum Programming
    Replies: 2
    Last Post: 09-21-2011, 01:39 PM
  5. Problem with SetValue Macro on Form
    By Accidental DBA in forum Forms
    Replies: 3
    Last Post: 04-01-2011, 01:48 PM

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