Re: Help with bar code

I too need to implement barcodes at some stage, so am interested in
responses to this thread.
As much as I understand, a BC scanner is interpreted by the os as "like" a
keyboard input, as if you where typing in numbers.
To say that wherever your curser has focus would be where the data is
inputted, be it in any text application. Of course I have only just started
looking into this, I have a cheap scanner from e-bay it reads & prints codes
to a receipt printer when connected to it ok, but I have yet to hook it up
to Access.
I'll stay tuned
Thanks.


"Al" <Al@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C64CCF25-0934-43A9-A110-D8F7393E3ECF@xxxxxxxxxxxxxxxx
> Thank you very much this was very helpful. I learned from both replies.
> However, I still do not understand, how the scanning works with access.
> what
> I mean is this. we are going to have 2 scanners to scan medication bar
> code
> that is already on the containers, when the scanners scan the bar code how
> does it get into access. what are the necessary steps that I need to do to
> capture what the scanner scans?
> thanks
> Al
>
> "LTofsrud" wrote:
>
>> Hi Al,
>>
>> I have been on several projects that have required bar code technology
>> and
>> here are a couple of suggestions that you should consider after you have
>> done
>> a bit of research:
>>
>> 1) Most people adopt the Code128 format for simplicity and it is usually
>> more than enough for most people
>>
>> 2) A good vendor that I have used is for all of my projects is Seagull
>> Scientific(http://www.seagullscientific.com/aspx/welcome.aspx). They
>> make a
>> product called BarTender that is great for creating barcodes. I have
>> used
>> different versions of their software and depending on your needs, I have
>> found it excellent for both small VB/Access applications where I used it
>> for
>> just creating a format that can print single label to sending batches
>> through
>> a command line. In Enterprise situations where you need a client server
>> or
>> n-tier solution, I used their Enterprise edition to host and send large
>> batches of labels to a dedicated barcode printer. Personally, I strongly
>> suggest staying away from the free fonts that you find on the web. I had
>> nothing but problems with them.
>>
>> 3) If you are thinking of using a 'regular' printer for sending your
>> print
>> jobs to, purchase some Avery or similar labels and test them first with
>> whatever barcode hardware you are going to be using. Sometimes not all
>> of
>> the inks can be read by the reader.
>>
>> 4) If you are only using a single entry point for barcode reading, you
>> can
>> go the easy route and use a barcode wedge which allows you to attach it
>> to
>> the keyboard port (there is also a Y-splitter you can use so that you
>> don't
>> lose the keyboard altogether). If the user needs mobility (say for
>> getting
>> up high or longer distances than the tether will afford), then look at
>> either
>> a wireless device or a handheld device. A great wireless device that I
>> have
>> purchased in the past is the Symbol wireless Phaser units (P370 I think).
>> May be a bit of overkill, but you can make that decision. If you are in
>> a
>> warehouse type of situation where they will be gone for extended periods
>> of
>> time, try a handheld PDA such as the Intermec 700 series. I did this on
>> one
>> project where they then placed the PDA into a docking device with a modem
>> and
>> they transferred it via modem to an Access database. Of course it adds a
>> bit
>> of extra coding since you need a UI and backend on the PDA (Intermec
>> offers a
>> software development package called MCL but I would stay away from it;
>> easy
>> but it was Alpha quality when we used it - go with AppForge Crossfire
>> instead).
>>
>> Thats about all I can think of for now, but while it is really cool
>> developing applications that use this technology, it can also be
>> frustrating
>> if you don't do the research ahead of time.
>>
>> Let me know if you have any other questions in regards to my post.
>>
>> Lance
>>
>>
>> "Al" wrote:
>>
>> > My company decided to incorporate a bar code system into our access
>> > database.
>> > I have been an access programmer for long time, but I have never worked
>> > with
>> > bar code. Does any one know how it works with access? Is there a
>> > literature
>> > on how to incorporate this into access database. I work in access2002
>> > Thanks
>> > AL
>> >


.

Relevant Pages

  • RE: Help with bar code
    ... that is already on the containers, when the scanners scan the bar code how ... > whatever barcode hardware you are going to be using. ... > a wireless device or a handheld device. ... >> My company decided to incorporate a bar code system into our access database. ...
    (microsoft.public.access.formscoding)
  • RE: Help with bar code
    ... whatever barcode hardware you are going to be using. ... a wireless device or a handheld device. ... > My company decided to incorporate a bar code system into our access database. ...
    (microsoft.public.access.formscoding)
  • Re: barcode
    ... Then in the central office through bar code readers the date will be ... identifyable by HTML FONT tags) barcode font installed on the clinet ... computer or b) use something that generates the barcode graphic on the ... In the US you can get a inexpensive scanner through CDW ...
    (comp.lang.php)
  • Re: barcode
    ... Then in the central office through bar code readers the date will be ... identifyable by HTML FONT tags) barcode font installed on the clinet ... computer or b) use something that generates the barcode graphic on the ... In the US you can get a inexpensive scanner through CDW ...
    (comp.lang.php)
  • Re: CASH REGISTER/POS Filemaker Integration
    ... Just wanted to add that I have done someting similar to a POS system. ... scanner should be well worth it. ... If you test the input from e.g. a EAN-13 bar code in TextEdit, ... With at least some barcode scanners, you can use a barcode in the ...
    (comp.databases.filemaker)
Loading