welcome to just answer. it would be my pleasure to help you
can you send me the access file so i can take a look
to do so please use http://www.4shared.com/ to upload the file and then you will be given a download link
paste it here so i can get the file
http://www.4shared.com/file/46mbRn1J/tickets.html Here you go
ok got it. i will check it and get back to you
trying to create a form for a ticket to be scanned at a gate. If the barcode scanned matches a number in the ticket table I wan the form to auto populate another field in the form that says valid ticket if it does not match I want the field to be populated with invalid ticket.
ok working on it now
i will finish it and send the file back to you
Thank you. Is there any way to compare the scanned ticket numbers and if there is a duplicate number to list that in the form filed?
i didn't get this last part
the table that holds the ticket information should have only one unique record for a ticket
how can there be a duplicate
if there is a fake ticket presented with a copied barcode.
so you say that each ticket scanned would be with a unique barcode right?
we would have two scenarios of fake tickets. One would have a completely inaccurate barcode and the second would have a copied barcode from a real ticket.
so there never should be a duplicate barcode in the database, right?
Yes that is correct
I think one of the solutions would be to have a field in the original ticket table to mark the ticket as previously scanned
and every time a new ticket is scanned we should check the ticket record and wether it has been scanned before or not
That would work
would this handle the duplicates case?
you can have a rest once i post the answer, you will be notified by email.
I'm Lindie, and I’m a moderator for this topic. I've been working hard to find a professional to assist you right away, but sometimes finding the right professional can take a little longer than expected. I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you. Thank you!
Hi Lindie, I really needed an answer to this question yesterday. It looked like I would have something soon but I have had to figure it out on my own. Please cancel the question and refund my money