I am newbie to barcode but I need to generate barcode for my invoice with the invoice something likes W12675679. Just want to know how to generate barcodes based on that type of invoice number, and how to store barcodes in ACCESS 2003! Thanks a lot for any ideas!!
Question How to generate barcodes
- Thread starter rickyfong
- Start date
Thanks Uncle Gizmo. However, Uncle Gizmo only gave an idea of how to store it. In fact, I don't know what's barcode font either!! After some wondering in this site, I still don 't have any idea of how to create a barcode based on my invoice number. I got some hints is to involve a ActiveX. But it seems this is a add-in function or component provided by third parties but not parts of VBA!! Any further ideas?? Thanks a lot!!
AccessBlaster
Be careful what you wish for
- Local time
- Today, 01:17
- Joined
- May 22, 2010
- Messages
- 7,572
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.
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.
- Local time
- Today, 09:17
- Joined
- Feb 19, 2013
- Messages
- 17,759
just found this thread which may be of interest
http://www.accessforums.net/code-repository/adding-code-128-39-barcodes-access-reports-33878.html
http://www.accessforums.net/code-repository/adding-code-128-39-barcodes-access-reports-33878.html
Barcode font seems is font for watching and printing barcode. However, I still don't get any idea of how to create a barcode when a new invoice with invoice such as W1234334 created!!?? Any further ideas? Thanks a lot!!
I stored invoice number in an invoice file which store unique data such as invoice date and invoice total etc, and in a transaction file with all relevant transaction data record! What I want is to create a bar code for my staff to just scan and can get all invoice data for a particular invoice number! This is my basic idea!! Thanks a lot!! My doubt is :
1. how to create barcode based on invoice number
2. how store it or how print it out
3. using which type of scanner to do the scan!?
Thanks a lot!!
1. how to create barcode based on invoice number
2. how store it or how print it out
3. using which type of scanner to do the scan!?
Thanks a lot!!
I have created a new ID in the Accessforums.net, for the above post. WHen I tried to download one of the Zip file in the above post, the system rejected me and explained that I am not have the right to download and access that post!! Is there anyone kind enough to download that Zip file for me!! Thanks a lot!!
AccessBlaster
Be careful what you wish for
- Local time
- Today, 01:17
- Joined
- May 22, 2010
- Messages
- 7,572
Also you will need a module to help translate the barcode font. See CJ_London's link http://www.accessforums.net/code-repository/adding-code-128-39-barcodes-access-reports-33878.html or PM me for a code-39 module.
I have created a new ID in the Accessforums.net, for the above post. WHen I tried to download one of the Zip file in the above post, the system rejected me and explained that I am not have the right to download and access that post!! Is there anyone kind enough to download that Zip file for me!! Thanks a lot!!
AccessBlaster
Be careful what you wish for
- Local time
- Today, 01:17
- Joined
- May 22, 2010
- Messages
- 7,572
After you unzip the font...
Try "right" clicking on the font, it may have a install option.
AccessBlaster
Be careful what you wish for
- Local time
- Today, 01:17
- Joined
- May 22, 2010
- Messages
- 7,572
Yes, I see that now
WHen I unzipped the file, it got 2 font files, fre3of9x.ttf and free3of9.ttf, which one should I need?? Thanks!!
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!?
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!?
