Results 1 to 2 of 2
  1. #1
    DataDoggy is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2018
    Posts
    1

    MMORPG Inventory/Sales Tracking Tool

    Hello everyone! A few friends of mine and I have been working on an inventory and sales management tool for a game we play. We're having some difficulty due to our inexperience with Microsoft Access and the unique tracking and inventory distribution we're trying to implement and manage.




    To clarify what we're doing: We're playing an MMORPG that has groups consisting of multiple players to attend an event to generate items that can be sold for gold. We'd like to track the group attendance and the items sold for gold, and associate the gold earned with each player as unique player accounts, as well as a total guild bank account. We want to be able to associate the item sales with each event/player in order to track their accumulated donations as well as what they are owed. We're trying to set up a foundation for our guild to allow accountability and transparency for guild efforts and investments.


    Here is the process in which we'd like to track:


    1: Log the players that attends an event.
    2: Log the item(s)generated from that event.
    3. Log player decision to donate their share to guild bank or keep for themselves (split).
    4: Log the sales for guild bank items.


    Ideally, we'd like this all to be automated, where the only manually entries would be the steps listed above: Event/Participants, Items, Donate/Split (per player), Sales. Below is the file we're been working on. Any assistance is greatly appreciated. Thank you so much for any consideration!

    https://drive.google.com/file/d/13vj...ew?usp=sharing

  2. #2
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    659
    Automation in access can be done easily with the timer property on the form. you enter the timeout of the timer in milliseconds. set it to 30000 for it to trigger every 30 seconds. have your update logic there.

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

Similar Threads

  1. Inventory Sales: Product made of Parts
    By Justin_Cap in forum Access
    Replies: 1
    Last Post: 05-07-2018, 03:53 PM
  2. Replies: 8
    Last Post: 12-19-2017, 09:09 AM
  3. Replies: 5
    Last Post: 02-13-2017, 04:29 PM
  4. Sales and Inventory DB
    By Dig in forum Access
    Replies: 8
    Last Post: 11-17-2014, 12:49 PM
  5. Inventory Tracking
    By PUDrummer in forum Access
    Replies: 3
    Last Post: 10-10-2012, 05:42 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