Question How to generate barcodes

[Uncle Gizmo]

I used Google Search, it took me a matter of seconds and I found this information on the Microsoft website about installing and uninstalling fonts. I suggest you try using a bit of Google Power yourself.

http://windows.microsoft.com/en-gb/windows7/install-or-delete-fonts

 

[rickyfong]

Sorry Uncle, I meant I could download the font, but don't know which location in my PC should I have to store it and unzipped it !!

 

[Minty]

Control Panel¬ Fonts

 

[rickyfong]

MY PC doesn't have Fonts directory under Control Panel!

 

[AccessBlaster]

MY PC doesn't have Fonts directory under Control Panel!

After you unzip the font...

Try "right" clicking on the font, it may have a install option.

 

[Uncle Gizmo]

After you unzip the font...

Try "right" clicking on the font, it may have a install option.

That suggestion is also the instructions given on the Microsoft website for which I provided a link earlier "Install or delete fonts" , so I should think it's a good bet that's the thing to do....

 

[AccessBlaster]

That suggestion is also the instructions given on the Microsoft website for which I provided a link earlier "Install or delete fonts" , so I should think it's a good bet that's the thing to do....

Yes, I see that now

 

[rickyfong]

Sorry both gentlemen! I had overlooked Uncle's command! I supposed it meant to search the font instead of storing the font!! Sorry about that!!

 

[rickyfong]

First you need to download a barcode font and install it onto your system. Here is an example of a free barcode font code 39.
http://www.barcodesinc.com/free-barcode-font/

Once it's installed, you need to change the font setting for the texbox on your report, label to match your font.

WHen I unzipped the file, it got 2 font files, fre3of9x.ttf and free3of9.ttf, which one should I need?? Thanks!!

 

[rickyfong]

Step 1 - Paste the function below into a VBA Module.
Step 2 - In your Reports, create a Text Box with the dimensions you want the barcode to fill.
Step 3 - Set the Text Box's Visible Property to No.
STEP 4 - In the Report Detail's On Print Event, add Result = Barcode_39(Me!MyTextBox, Me) (instead of Barcode_128()). You may need to Define the variable Result as a Boolean first.

Firstly, My idea is to involve a barcode in a form, store it in ACCESS, export data and print them out in Excel! As such, should I still need to generate a textbox in my form!?

 

[GCU]

There are free barcode fonts like free3of9 and fre3of9x who can be downloaded.
On your report set this barcode as font and enter the invoice number surrounded by * in a textbox. Make sure the textbox is large enough and the fontheight is set to at least 24 to have a readable barcode.
So get your invoicenumber in a query with a calculated field "*" & InvoiceNr & "*" will give *W1234334* to be used in your report's barcode textfield.
The asterix (*) is used to wrap the barcodevalue in code 39. There will be barcodes shown if you don't use it, but no scanner can read the created barcodes without these signs.