If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Lottery ticket Inventory

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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 03:47.
Reply With Quote
  #2 (permalink)  
Old
L33t Helpa Munky
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old
L33t Helpa Munky
 
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
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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 02:38.
Reply With Quote
  #6 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,307
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.
__________________
Is taking part in the 'Distinguished Gentlemans' ride. Being neither distinguished nor a gentleman, but I am keen to raise funds for Prostrate Cancer research. At present I'm threatening to ride a Norton 961 wearing a kilt. If you would like to contribute to Prostrate Cancer research then please consider donating via this page:-
http://www.gentlemansride.com/rider/healdem
Reply With Quote
  #7 (permalink)  
Old
Moderator
 
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)
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On