Barcodes

[lead 27]

Hi

I have just been having a look at some of the past threads and I am hoping that what i want to do is possible however I am just wanting to check that it is possible and how hard it is?

I already have a database which controlls all of our stock however the quantaties have to be manually updated so I would like to give each item a barcode and use a handheld scanner so that the users can just scan what they have taken and then at the end of the day upload it to the database and all the quantaties will change.

My questions are is this possible and how hard would it be for a beginer?

Thank you

 

[spowers21]

It's actually pretty easy to implement barcodes into your db. You can download for free a 3 of 9 barcode font. The only requirement is when you print the barcode on a report you have to concatenate an * on either end of the field ... "*"&[fieldname]&"*"

 

[lead 27]

Would it be possible so that if the scanner stored all the data through out the day and then plug it in at the end of the day it reduces the qty of the items that you have scanned? So kind of how a shop would do it but just slower as it wouldnt be instant.

 

[RuralGuy]

Have a look at this article by MVP Allen Browne.