471,077 Members | 754 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,077 software developers and data experts.

Barcode Generation using Report in MSaccess 2003

222 100+
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
4 2987
maxamis4
295 Expert 100+
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
maxamis4
295 Expert 100+
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
  8.  
  9. Exit_Form_Load:
  10.     Exit Sub
  11. err_form_Load:
  12.     MsgBox Err.Description
  13.     Resume Exit_Form_Load
  14.  
  15. End Sub
  16.  
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
  8.  
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 Fonts.zip (16.9 KB, 259 views)
Jun 2 '07 #3
wassimdaccache
222 100+
It woked very well ............. Thank you Very Very Very Very much
Jun 2 '07 #4
wassimdaccache
222 100+
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.

Similar topics

1 post views Thread by Aaron Bronow | last post: by
reply views Thread by Dilip | last post: by
reply views Thread by =?Utf-8?B?QWJieQ==?= | last post: by
7 posts views Thread by divyac | last post: by
6 posts views Thread by Robocop | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.