How do I use Scanners....

[dfate]

Hi all,
I'm looking for some information, links etc. on how to use the following
with Access and any help would be GREATLY appreciated!

1. How do I pop an Access form and pull up records based on the incoming
phone number from callerid? I'm basically looking to trigger a query on a
form to select where phonenumber = (caller id from incoming call)
2. How do implement a barcode scanner (usb...) to scan inventory in a point
of sale application?
3. How would I integrate a credit card machine for billing?

-THanks! Dave

 

[James Hahn]

1. Call management software includes procedures for issuing calls to all
standard database applications, including ACCESS, and detailed procedures
for implementing these routines are provided with the software. For
instance:
http://www.sqlphone.com/ivr-phone-answering-software.htm

2. Scanners usually work as a replacement for the keyboard, so no special
procedure is required to access scan data - it is fed to your application
exactly as if someone was typing it at a keyboard. If your application has
more extensive requirements then some scanners support additional modes of
data transfer. Contact your scanner supplier for details.

3. Credit card machines vary enormously in type and mode of data transfer.
They range from simple keyboard wedge devices (much like a scanner) through
to custom interfaces using a serial port or USB interface, with a wide range
of mechanisms for integrating with existing software. Contact your credit
supplier for details of the interfacing capabilities of their different
models of machines.