Re: Help with bar code
- From: "Al" <Al@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 9 May 2005 06:00:02 -0700
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
> >> >
>
>
>
.
- Follow-Ups:
- Re: Help with bar code
- From: LTofsrud
- Re: Help with bar code
- From: Fred Boer
- Re: Help with bar code
- 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
- Help with bar code
- Prev by Date: Re: Option Group Coding
- Next by Date: RE: Show Form While Processing
- Previous by thread: Re: Help with bar code
- Next by thread: Re: Help with bar code
- Index(es):
Relevant Pages
|
