Results 1 to 4 of 4
  1. #1
    Propaganistas Guest
    Windows 7 Access 2010 (version 14.0)

    Creating a '+1'-button

    Hi everyone,

    I'm setting up a form and I'd like to get the following:



    Once a button has been clicked on, it has to update a numeric field of the selected record by a simple math operation: +1.

    Unfortunately, I don't know anything about VB. Can anyone help me out getting the necessary button-code? The table is called Dance and the field that needs the math operation is called Pop

    Thanks!
    Propa

  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,640
    It sounds like the field is on the form; if so it's simply:

    Me.TextboxName = Me.TextboxName + 1
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    And MVP Allen Browne has a more universal approach: http://allenbrowne.com/ser-02.html

  4. #4
    Propaganistas Guest
    Windows 7 Access 2010 (version 14.0)
    Thanks a lot!

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

Similar Threads

  1. Replies: 1
    Last Post: 07-27-2010, 02:27 PM
  2. Replies: 3
    Last Post: 02-23-2010, 06:32 PM
  3. Creating a difficult qry
    By Aubreylc in forum Queries
    Replies: 8
    Last Post: 02-11-2010, 12:13 PM
  4. Replies: 6
    Last Post: 02-09-2010, 07:53 AM
  5. Replies: 3
    Last Post: 01-14-2010, 08:32 AM

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