Barcode scanner

[ChadMan]

I took a Access college course some time ago. Haven't used it much.
Need some advice. I want to track serial numbers scanned in from a barcode
reader by date. The only info I need for data is the date and the serial
number. I need a form that inputs the barcode when scanned, changes focus to
the date input so the user types the date, hits enter and the data is
stored. I also need a form or the same form to be able to recall the date
when a serial number is put in.

Do I need access or excel or both to do this? Do I need to make a worksheet
in excell and then link it to an access form?

I have 100,000's of serial numbers, how does the 32,000 entries affect this
in my databases/worksheets?

TIA for any help

ChadMan

 

[Tony Toews]

I took a Access college course some time ago. Haven't used it much.
Need some advice. I want to track serial numbers scanned in from a barcode
reader by date. The only info I need for data is the date and the serial
number. I need a form that inputs the barcode when scanned, changes focus to
the date input so the user types the date, hits enter and the data is
stored.

Access can do this just fine. You probably want to program the
scanner so after it scans some data it presses Tab or Enter to go to
the next field. Which, in your case, is the date field.

Barcodes mean

1) a means of reading them. These devices usually fit between your
keyboard and your computer and mimic someone keying in the code
directly. All you need to do in your app is a little forms design to
ensure someone can continuously feed bar codes into your app and
change the quantity occasionally.

2) A means of printing them. Choose the proper barcode and locate an
appropriate font. Place the font file on all the systems which will
be printing bar codes. On the report(s) change the font on a field to
use the bar code font. Some bar codes like having *s before and after
while others like check digits.

For more info and links see the Using bar codes within an application
page at my website at http://www.granite.ab.ca/access/barcode.htm

I also need a form or the same form to be able to recall the date
when a serial number is put in.

This is just a standard search form of some type with a bit of code or
some lookup combo boxes on it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[ljb]

I took a Access college course some time ago. Haven't used it much.
Need some advice. I want to track serial numbers scanned in from a barcode
reader by date. The only info I need for data is the date and the serial
number. I need a form that inputs the barcode when scanned, changes focus to
the date input so the user types the date, hits enter and the data is
stored. I also need a form or the same form to be able to recall the date
when a serial number is put in.

Do I need access or excel or both to do this? Do I need to make a worksheet
in excell and then link it to an access form?

I have 100,000's of serial numbers, how does the 32,000 entries affect this
in my databases/worksheets?

TIA for any help

ChadMan

I'd make the serial number field the key and a date field that has a default
value of the vba function Now(). When the new record is created the date is
always entered. Believe it or not I once hacked a Radio Shack CueCat bar
code reader to do something very similar. Radio Shack gave them away free
for scanning the bar code in their catalogs and take the user to a web site.
Its been a few years ago but I think the VB source code is still available
here http://www.michaelchaney.com/downloads/

LJB

 

[ChadMan]

This is just a standard search form of some type with a bit of code or
some lookup combo boxes on it.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Thank you very much! I will absorb and conquer (more like trial and error)!
Hopefully!

Very nice info, will pass it on. I'm using Seagull Scientific's "Bar Tender"
label software. Have a working serialized barcode. I have 50 products with
prefixes + 4 or 5 digits like: ESS3XXXX or similar. The prefix determines
the product.

My form I was thinking would be similar to this:

**************************************************

Warranty Database

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

Scan serial # and input date installed

Serial number:______ Date installed:______

[add serial #]
--------------------------------------------------

To check a warranty enter serial number

Serial number____ Product:____ Date installed:____

[check serial #]
**************************************************

Maybe two forms, one for checking and one for adding.

I'd like to have the serial number on the "warranty check" cause the date
and product to display. I can see the date is a simple lookup. But the
product determined by the prefix of the serial number, not sure how to do
that. Do I need a VB script maybe? Any samples anywhere I can look at that
would give me an idea?

They are using excel to put the serial numbers and dates in manually so I
might like to link to that data as well. I'm trying to automate it a bit to
make it easier for the girls who have to sort warranty cards.

Anyways thank for the info!
ChadMan

 

[ChadMan]

I'd make the serial number field the key and a date field that has a
default
value of the vba function Now(). When the new record is created the date
is
always entered. Believe it or not I once hacked a Radio Shack CueCat bar
code reader to do something very similar. Radio Shack gave them away free
for scanning the bar code in their catalogs and take the user to a web
site.
Its been a few years ago but I think the VB source code is still available
here http://www.michaelchaney.com/downloads/

LJB

I have another one around somewhere. It was so simple to do. I need to input
the date installed, not todays date. Or am I misunderstanding? Not familiar
with vba functions. Yet.

See my reply to MVP Tony. That's kind of what I need. I figure it will be
and excell document linked, maybe a table, 2 forms and a simple switchboard.

Will look the link over to see what I can learn.

Thank you!
ChadMan