[AccessD] Adding Bar Coding and Scanners to an Access Application

Brad Marks BradM at blackforestltd.com
Tue Feb 19 13:23:12 CST 2013


John,

Good point.  Obtaining a Bar Code font and installing it was easy.

My next step is to experiment with a scanner, but currently I do not
have one to play with.

If anyone has a recommendation of an inexpensive scanner to pick up for
some initial testing, I would appreciate it.

Thanks,
Brad

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
Sent: Monday, February 18, 2013 4:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Adding Bar Coding and Scanners to an Access
Application - Thanks!

Printing the bar codes is the easy part.  Scanning them into Access is
more complex, depending on 
the needs.  I did this in the nineties down in Mexico.  I ended up using
a serial port scanner so 
that I could have absolute control on the read and getting the data to
the right place.  These 
'keyboard wedges' work but can be problematic.

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 2/18/2013 5:19 PM, Brad Marks wrote:
> All,
>
> Thanks to everyone who shared their ideas and insights about Bar
Coding
> and Scanners.
>
> I now have an Access Report with Bar Codes (downloaded a font from the
> Internet).
>
> I really appreciate the assistance.
>
> Brad
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
> McLachlan
> Sent: Thursday, February 14, 2013 3:28 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Adding Bar Coding and Scanners to an
> AccessApplication
>
> I'd recommend 3 of 9 coding.  Google "frree 3of9".   There are quite a
> few fonts out there.
>
> Pick one that you like and download and instal it.   The rules for
3of9
> are very simple, you just
> use an asterisk as a stop and stsart character. So to put JobNum  on a
> report, set a textbox
> to ="*" & Jobnum & "*"  set it's font to 3of9
>
>
> On 14 Feb 2013 at 12:25, David McAfee wrote:
>
>> There was even a free 3 of 9 font that I downloaded and used in one
of
> my
>> projects.
>>
>> This was the site listed in the readme:
>> http://www.squaregear.net/fonts/(which is now blocked at my company).
>>
>> If you can't find it online anywhere, I have the zip file which
> contains
>> the font.
>>
>> HTH,
>> David McAfee
>>
>> On Thu, Feb 14, 2013 at 12:11 PM, Arthur Fuller
> <fuller.artful at gmail.com>wrote:
>>> It's been a while since I've done bar codes, too. But I do recall
> that
>>> there are several such fonts, and they are all unique, reflecting
> different
>>> schemes. One was called Code 3 of 9, IIRC.
>>>
>>> A.
>>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list