Results 1 to 2 of 2
  1. #1
    Andyjones is offline Advanced Beginner
    Windows Vista Access 2010 32bit
    Join Date
    Sep 2011
    Posts
    76

    vba coding help for points field stored in table. access 2010

    Access 2010 form help

    Hi Could somone please figure this out scratching my head with it now

    On the Match Date form when I select Home for match type and then enter player name score then opp player Name and score it should auto populate with 2 points if its an away home win and 3 points if it is an away win per player.

    If my player points at home =21 then my player will receive 2 points and if my player away score is 21 then my player received 3 points.

    It all works up until i delete the test data to start entering actual data, could someone take a look and try and figure it out please.

    Attached Files
    new test1.zip (383.8 KB, 6



    Attached Files



  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    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. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  2. Calculated Count Field in Access 2010 Table
    By johnsmith1 in forum Access
    Replies: 12
    Last Post: 03-28-2012, 05:00 AM
  3. Ranking by points office 2010
    By Andyjones in forum Queries
    Replies: 1
    Last Post: 03-17-2012, 02:27 PM
  4. Execute MySQL Stored Procedure with Access 2010 VBA?
    By DanielHofer in forum Programming
    Replies: 5
    Last Post: 01-23-2012, 01:08 PM
  5. Replies: 5
    Last Post: 12-10-2011, 11:49 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