[AccessD] Wireless Scanner

Rocky Smolin at Beach Access Software rockysmolin at bchacc.com
Tue Jun 26 21:03:51 CDT 2007


The site is in Waukegan so I can't really get on-site to make a
determination.  But, it seemed from my discussions with the contact that
this would be a bit of overkill.  After all, a truck pulling up to the dock
with a variety of parts would have a bill of lading which could be used as a
manual transmittal document to the work station to do the receiving.  Other
parts will come in by variou7s shipper but all will have packing lists. 

I'm a firm believer in the system being the solution, not hardware and
software.  Good manual systems are effective.  At the point where the volume
of transactions overwhelms the ability of the people to keep up, THEN you
stick a computer in the loop.  But computers do nothing more than mimic
human activity.  If you have a bad manual system, you'll have a bad
automated system.

For companies like this one which are not in full production mode yet, I
always recommend manual systems.  Forces them to define the work and
information flow and gets them rolling. 

Rocky



 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
Hawkins
Sent: Tuesday, June 26, 2007 5:58 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Wireless Scanner

Rocky, what's the business case for this wireless implementation?  Does your
client really need someone roaming free or is is more of a "parts cage" type
implementation?

-C-

----------------------------------------

From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
Sent: Monday, June 25, 2007 11:19 PM
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Wireless Scanner 

Flattery will get you everywhere. :)

I guess I'd better press this guy to tell me which scanner vendor he's going
to use. 

Bet you a dollar at the end of the day he abandons the idea. First problem
is that after he scans the item number he has to input a quantity. Now he
could hold one of those laminated cards with bar code numbers but that's
awkward. The whole idea is, I think, a bit misguided. They should just route
the paperwork to the computer. They're just starting up and numbers of
transactions will be low.

But if they're intent on doing it, I'll do it.

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, June 25, 2007 5:09 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Wireless Scanner

Hi Rocky:

That is correct. In Grocery stores, using the latest equipment, for example,
when scanning the shelves, there is just has remote hand-held scanner/pad
and a central station with a wireless wedge attached. A single fellow can do
an isle in about 20 minutes.

There are some larger sites that have multiple handhelds with a single
station that has a system which identifies which hand-held from which
check-out or pad is calling and then re-directs the scanned items details
back to the appropriate check-out station.... but that can be a fairly
pricey configuration... though the price is coming down.

All this is done with hardware and at the most, a minimum of software.

The hardware just passes the information to the station as if it was being
keyed in. About the most you have to do is to configure the equipment to add
a LF/CR or tab to the input. You can also set the system up to send a key
which may automatically drop the scanned/translated value into the field at
the top of the page. 

All this is fairly rudimentary for a programmer of your caliber. 

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, June 25, 2007 3:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Wireless Scanner

SO the wireless scanner is like a portable phone? You still have the 'wedge'
between the keyboard and the computer, but you can roam with the scanner?

Rocky

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Monday, June 25, 2007 1:39 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Wireless Scanner

Hi Rocky:

That should be no problem. There will have to be a base station attached
either to the network hub or the station that will be receiving the barcode
information.

In other words it is the same as a standard hardware connection for
scanners. They either are directly connected to the computer or through a
wedge attached to the keyboard.

There may be some software/driver, if the receipt or sending unit does not
already have firmware built in the handle the barcode to number conversions,
with most products of this nature that is the case. 

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: Monday, June 25, 2007 12:43 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Wireless Scanner

I just had a call from a prospect who wants to use wireless barcode scanning
to scan part numbers. Does anyone have any experience with this? Has anyone
interface one of these with an Access app?

MTIA,

Rocky


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

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.9.8/869 - Release Date: 6/25/2007
5:32 PM
 




More information about the AccessD mailing list