Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2008
    Location
    Rhode Island USA
    Posts
    3

    Lottery ticket Inventory

    Hi
    I am trying to create a database in access to keep track of my lottery tickets. the tickets have a game # that i can use as a primary key. i have started with a table called packs this is where i enter the Game Number, Game Name, Game Value and Pack Value. from here i then have a Received Date table that has a Receive Date ID, Game Number that I was able to create a relation one to many, Game Name and received Date. I would like to track Activation Date and Settlement Date as well. I am an a trail and error type learn system that can be very ###### ##. I have created queries to try to auto fill the forms and also dabled with the switch board. I have been playing with access for some time now but just can never completly finish a project I always revert back to excel.i always come back to acccess because I know its a better way. Please help me learn. there is a lot i would like to do with database this is just the begining. I have lottery books that are made up of tickets and i need to keep track of this to prevent the the tickets from grow legs and walking away. trully in need of help.
    Last edited by dbjunky; 12-19-08 at 04:47.

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So... what... you need help to learn Microsoft Access? I would be looking for "microsoft access training" in google, not on a forum

    Makes me want to finish mine though

    You could post your ERD (relationship window) and a statement of what it is you are trying to achieve with the database and I am sure you would get tips that might nudge you in the right direction.

    Try to bear in mind that not everyone knows what you are really trying to do. For example, you said you would like to track Activation Date... what exactly is an activation date when it comes to lotto? Same with "settlement date".

    And glad to hear you are sticking with it and not reverting back to Excel!!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Aug 2008
    Location
    Rhode Island USA
    Posts
    3

    procedure

    Receive Lottery Pack ex: 1 pack has an Game number, Game name, Ticket value, Pack value ( Game Number 272-001051 Game Name Pin Ball Wizard Game Value $10.00 Pack Value $300 So this gets entered into a inventory table lets call it Packs. Then I need to track the date I receive it on my property lets call that Received Date, Then I have a date that the pack is activated call that Activation Date this is when the pack come out of inventory and is scaned at the lottery terminal and activated so it can be sold. last the pack is settled called Settlement Date this is when the lottery charges for the pack. this pack would have 30 tickets in it that eventually i would like to try to link the sale of the indvidual ticket to the database these tickets would be numbered 0-29 which makes it fun because 0= 1 ticket i have 6 packs out at one time. I hope this helps it sometimes difficult to explain this way thanks for looking and I appreciate your response

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sorry, I'm on holidays, I really don't want to design this for you. As I said, try looking on google for some Access training material, get a grip on relationships, come back, paste your relationship diagram and I will advise you further.

    Someone else with more time might want to design it with you on a forum though.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Aug 2008
    Location
    Rhode Island USA
    Posts
    3

    Thanks

    i am new to forums so how would i copy my relationship diagram I have been working on this and have come up with something that is allowing me to to track my pack, now i am trying to break it dowm to indavidual tickets. I have a fare understanding about access i have studied many books and CD's no formal classes, I just get confused because there seems to be more then one way to skin a cat. right now i have two tables (Packs) and (Log Table) with a one to many relation from GameNumber in Packs to GameNumber in Log Table. i have mad a switchboard and been able to enter information and produse a report. this is more then i had and it is helping. trying to copy relationship diagram with (Print Screen function) does't seem to be woking. I'll take any help i can get when ever you are ready.
    Last edited by dbjunky; 12-22-08 at 03:38.

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,517
    select the realiton ship window in Access
    press concurrently the control, shift, and print screen keys, this transfers a copy of the screen image to the paste buffer

    open a photo editing program (or a word processor at a pinch)
    create a new image or document
    then paste the screen image from the paste buffer into that image or document

    there is rarely only one way to solve a db problem, like real life itsefl what works for some people is an abomination to others. the key is understandign what works for you.
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,925
    I'm curious, What's the difference between control-shift-printscreen and just print-screen. I know the alt-printscreen will just take a snapshot of the current popup box.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •