using the Excel Add-in in Access

[brendagundersen]

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.

[bdobson]

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!