By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,761 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,761 IT Pros & Developers. It's quick & easy.

Barcode Generation using Report in MSaccess 2003

P: 222
Hello everybody

Does someone have a VB module and FONT for windows XP SP2 to import into a MSaccess (2003) to print a barecode ...

Please leave me any comments about barecode generation or anything u know about barecode...
Jun 2 '07 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 295
Yes I do!!! but I can't attach the file. I am currently not at home, But when I get home I will attach the file you will need to do this, in addition a script that will check to make sure that it exist will also be included.
Jun 2 '07 #2

Expert 100+
P: 295
First you will have to load this code on the form on load. It uses does scripting to do this function.

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2. On Error GoTo err_form_Load
  3. Dim stAppName As String
  4. HideAccessCloseButton
  5.     stAppName = "\\itdc01\opsupt\data\Asset Tracking\Fonts\font.cmd"
  6.     'Call Shell(stAppName, 1)
  7.     Me.txtPassword.SetFocus
  9. Exit_Form_Load:
  10.     Exit Sub
  11. err_form_Load:
  12.     MsgBox Err.Description
  13.     Resume Exit_Form_Load
  15. End Sub
stAppName should be set to the location where your database will reside.

The second part to get this to work is modify the file called font.cmd. Goto the file named font.cmd and right click on it and goto edit.

Expand|Select|Wrap|Line Numbers
  1. echo on
  2. if exist c:\windows\fonts\FRE3OF9X.TTF goto ttf
  3. :ttf
  4. if exist c:\windows\fonts\FREE3OF9.TTF goto done
  5. xcopy "\\itdc01\opsupt\data\Asset Tracking\Fonts\*.ttf" c:\windows\fonts
  6. :done
  7. exit
goto the xcopy part and modify the location where the .ttf file exist on your network and you will be done.

afte this when you open access you can select the actual font to use as the barcode. good luck!
Attached Files
File Type: zip (16.9 KB, 233 views)
Jun 2 '07 #3

P: 222
It woked very well ............. Thank you Very Very Very Very much
Jun 2 '07 #4

P: 222
I have to add something to this subject ... When you want to use these fonts your ascii or you number or whatever the symbol is must be wrote between to stars for example if you want to print the barecode of ABC27001 you have to write *ABC27001* ...

NB: Barcode reade will just read ABC27001

anyway thank you again for the one that he helped me to find these fonts ....
Jun 20 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.