Re: Help with bar code
- From: "Fred Boer" <Fredboer1@xxxxxxxxxxxxxxx>
- Date: Mon, 9 May 2005 10:15:51 -0400
Dear Al:
It depends on the type of barcode scanner you are using. One of the most
common types is the "wedge" type scanner, as mentioned in the earlier post
by Lance. This type of scanner simulates the keyboard. That is to say, when
you actually scan the barcode, the scanner sends the computer the number
represented by the barcode using the same port as the keyboard. It is as if
the number had been entered on the keyboard.
So, imagine you are using a form with a textbox into which you wish to
insert the barcode number. When the focus is in the textbox, you scan the
barcode. The barcode number is entered into the textbox, just as if you had
entered the number manually using the keyboard. As far as Access is
concerned, the number is being entered by a really fast, accurate typist! ;)
Now, this is true for the simple, wedge type scanner which you connect using
a "Y" splitter cable to the keyboard port. I haven't any experience with
other types.
Also, please note that most scanners have a variety of settings, and can,
for example, be programmed to insert a carriage return after scanning, if
you need that...
HTH
Fred
"Al" <Al@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3CAC0F77-939E-40DE-B1E5-EF831E949C2C@xxxxxxxxxxxxxxxx
>
> thank you for your response. what I need to realy Know and I hope that
> someone can answer is that how is the setup between access and the scanner
> takes place? Say I create a form bound to a table in access , and the
> field
> that stors this data, has the focus. now how is the scanner writes to it
> when
> someone scans? is there a setup on the scanner to make it scan to access?
> do
> I need to do anything in access to recognize the scanner? I need some one
> to
> clarify this for me. thank you.
> Al
> "postman" wrote:
>
>> 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
>> >> 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
>> >> >
>>
>>
>>
.
- References:
- Help with bar code
- From: Al
- RE: Help with bar code
- From: LTofsrud
- RE: Help with bar code
- From: Al
- Re: Help with bar code
- From: postman
- Re: Help with bar code
- From: Al
- Help with bar code
- Prev by Date: Re: RecordSource
- Next by Date: Re: me.undo parent if child is empty
- Previous by thread: Re: Help with bar code
- Next by thread: Re: Help with bar code
- Index(es):
Relevant Pages
|
Loading
