Help with Barcode

[lookforsmt]

Hi! everyone

Request help on barcode, without the font, in other words is there a function or vba code as an alternate to replace the barcode font.
Can the QR barcode be used in access

I have attached db. The barcode length is too long. can this be smaller in length or QR barcode which are smaller in size

regards

 

[Ranman256]

download and install the font
increase the text size of the barcode field to max 255

 

[lookforsmt]

hi, thankyou for your response

I have a table with say 100 records. It has below fields:

Id: Auto number
RefNos: EN
Date: Entry Date (format: dd/mm/yyyy)
barcode: 14 digits

EN-141216-0001
EN-141216-0002
EN-141216-0003
EN-141216-0004
EN-141216-0006
EN-141216-0099
EN-141216-0100

how can I auto fill the barcode field with above code picked from RefNos+Date+RunningNos

The RunningNos should be based on that particular day row count and add it in the barcode field as mentioned above

Can anyone assist me in this pls

Thanks

 

[AccessBlaster]

Once your barcode is installed, place a textbox on a report. Change the default font for this textbox to your new barcode font. Then bring up the properties for the textbox and change the control source to the table field where this is stored>EN-141216-0001.

The control source may require a bit more tweaking like:

=BCW_Code128B([Asset Tag])

 

[lookforsmt]

Hi! I have two fields in table as, barcode and routing.

Barcode field is updated via barcode scanner, once the data is updated the focus is set on routing. This is working perfectly.

Routing is updated via keyboard reader which reads below and updates the Routing field.

e<628684:802020125:<7100540010<r0

But the problem is, once the data is updated, I want the focus to move back to Barcode field which does not happen.

Can this be done through vba code. I have tried afterupdate, on change, on enter, but it does not give he desired results.

Request if i can get any help.

 

[lookforsmt]

Hi! I have two db, one for printing lables and second one for printing reports
check this out
I have copied this from one of the post