Search results

  1. N

    Need feedback on database

    This will be done only 1 time a day and that is at night. That's it, we only scan the ticket which is currently in the box at night. The tickets are sold using the different upc, and that's a breeze. That's not the issue here, also I'm not telling anyone to scan each ticket sold that's bonkers.
  2. N

    Need feedback on database

    I've tried it before but I think that not that many people are on this forum that are familiar or have any interest in the field I am in. Also I know that I am not much on how to explain what I want thing I want to do properly.
  3. N

    Need feedback on database

    Yes you're correct, there is a reason for have that formula, there are 2 different size barcodes. The Lottery started implementing new barcode number that has different length then previous one. So I've to have iff statement just in case they can scan old one but still get the correct pack...
  4. N

    Need feedback on database

    I have a store where we sell scratch tickets, there are 53 boxes with different tickets in each. So at night after closing we used to write down ticket number and subtract the ticket number from previous day to get the number of tickets sold today. Then multiplying it with the $ amount of...
  5. N

    Need feedback on database

    Thank you for the reply, I understand not everyone know about how we do things with lottery. I know my db is missing all the relations, but I couldn't figure a way to do it properly. Every information in this db is taken from a barcode from the back of the lottery, Like this the one at the...
  6. N

    Need feedback on database

    I am kinda new to MS Access, and don't have very much knowledge on VB and SQL. There are 54 box of scratch-off tickets, everynight I scan the ticket barcodes and dB will separate the ticket number and pack no from the scanned barcode. Scratch off Dollar value = Total Number of tickets in a...
  7. N

    Report shows blank with no data

    Thank you. 👏
  8. N

    Save an Access Report to a PDF using the Windows File SaveAs Window

    Is there a way to open to "This PC" rather than some particular location.
  9. N

    Report shows blank with no data

    On form I've hidden yesterdaysdate with "=[TodaysDate]-1". and on the report it's only DoCmd.OpenReport "rpt_DailySalesAmount", acViewReport DoCmd.Maximize As I said if I open the report directly and enter the dates manually it's shows fine, also I use the same form to open another report...
  10. N

    Report shows blank with no data

    I am having this problem, If I click to open a report from a form, no data. But if I open the report directly it shows perfectly.
  11. N

    Need help creating a database for tracking lottery ticket sales.

    This is how the tickets get scanned 9905060170059983751013 18912261900032 It needs iif formula to get the pack number and ticket number. The tickets have two separate upc codes, one like above and another one(might be code128 or something like that).
  12. N

    Need help creating a database for tracking lottery ticket sales.

    This is what my excel file looks like, I'm manually putting the ticket numbers in. So I have 54 boxes that has 54 different scratch offs, if you been to a gas station you might have seen those. So every night we take the number and subtract it from last night's number and figure out how many...
  13. N

    Need help creating a database for tracking lottery ticket sales.

    Sorry the naming of table here in the form is just to explain. I don't have any "&" or anything like this but I do have "_". I can't seems to think what is wrong in this database.
  14. N

    Need help creating a database for tracking lottery ticket sales.

    This is the way I have the tables Table 1 Table 2 Table 3 Table 4 Box Number Box Dollar Amount Game Name & Game Number Date & Daily Ticket Number & Calculated Ticket Number
  15. N

    Need help creating a database for tracking lottery ticket sales.

    I am trying to create a daily lottery counting database, in which I can scan the lottery everynight and at the end it tells me how many tickets I sold and the dollar amount. I am using excel as of right now. I've got it nailed down in excel but I have to enter all the number manually. Now for...
  16. N

    Connected table search

    Reason for the combo box was for new vendors to be added later, and available right away for entry. But I understand.
  17. N

    Connected table search

    I am not much familiar with sql in vba, I'm still learning. This is what I currently have in the db, tbl_vendor -ID (PK) -Vendor Names tbl_vendorinvoice -Vendorname (Dropdown list from tbl_vendor, saves number as a referance to one of the record from tbl_vendor Vendor Names). how should I put...
  18. N

    Connected table search

    That solves the problem with vendor but as none of the other field's results shows up now. What I would like is to type in any one or multiple fields like invoice number, date, vendor name etc., and if they all match with one or multiple records they show up in the query. But that doesn't...
  19. N

    Connected table search

    I have the following items in the database Tables 1. tbl_VendorList (ID=PrimaryKey, Vendors(Names) 2. tbl_VendorInvoice (Vendor field = [ID from Table 1] you can see the names but they're all connected to VendorList tbl, also contais other information) Queries 1. frm_Search Forms 1...
Top Bottom