bar code script

  • Thread starter Thread starter shank
  • Start date Start date
S

shank

I need to update a bar codes field for hundreds of records.
Does anyone have a script that I can use to accomplish this in an update
query?
I'd like to generate the digits (not bar code graphic) on the fly.
I have UPC(A) 11 digits + check digit = 12 digits

thanks!
 
Hi,


How do you compute the check digit? it is often a weighted sum of the digits
followed by a modulo, but I am not aware that there is just ONE standard
(and it may be something else than a weighted sum).

Once you know the method to generate the whole set of digits, through a VBA
function in a standard module, it is a matter to use a query like:


UPDATE myTable
SET myNew12digits= myVBAfunction( myOld11digits)
WHERE myNew12Digits IS NULL



I have added a WHERE clause, but it may be not appropriate.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top