using the Excel Add-in in Access

Tips & tricks for Code 128 in Excel

using the Excel Add-in in Access

Postby brendagundersen » Wed Oct 28, 2009 9:37 pm

Although I understand that the Code128WinLarge font was created for use in Excel, I'm holding out hope that there's a way to make it work in MS Access. I can set the font of an Access report field to the font Code128WinLarge and a barcode is displayed but of course when scanned it doesn't return the value of the barcode (in fact it doesn't return anything at all...) The barcode is visibly different from the same value as a barcode in Excel.
I'm not too familiar with check digits and such so I don't really understand what's happening... any wisdom you can impart here? Am I on a wild goose chase for an easy solution when there is none?

Thanks.
brendagundersen
 
Posts: 1
Joined: Wed Oct 28, 2009 9:19 pm

Re: using the Excel Add-in in Access

Postby bdobson » Thu Oct 29, 2009 12:19 am

Hi Brenda,

The code 128 font is very extensible. I know that the COM DLL available below has been used successfully in Access.

http://freebarcodefonts.dobsonsw.com/preview-code128-net-dll.html

It's easy to call from standard VBA, but I have not used VBA in Access. As far as I know it's no different, you essentially create a reference to it in your VBA project, and call that function from Access.

I found an article on that here:
http://en.allexperts.com/q/Visual-Basic-1048/Call-dll-procedure-MS-1.htm

I'll give some thought to it and perhaps create an add in for Access in the not too distant future...

Thanks for bringing it up!
bdobson
Site Admin
 
Posts: 16
Joined: Sun Jun 14, 2009 3:26 pm


Return to Excel Code 128

Who is online

Users browsing this forum: No registered users and 2 guests

cron