Dan
Premium Member
Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
|
Can anyone shed some light on how I can do this..
I need to use a barcode scanner to log tools in and out, and to a job number.
So I want to scan a job number barcode, scan the tool barcode, and it logs as being on that job. Then scan it again and it will take it off that job.
How can I do this??
Adult GiftsClick here to vist us
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
With a Macro and a Form
|
Dan
Premium Member
Registered: 22nd Apr 02
Location: Gorleston on Sea, Norfolk
User status: Offline
|
What would be involved in making it work, is it a big task?
Adult GiftsClick here to vist us
|
willay
Moderator
Organiser: South East, National Events
Premium Member
Registered: 10th Nov 02
Location: Roydon, Essex
User status: Offline
|
Using Microsoft Excel/Access
|
evilrob
Premium Member
Registered: 16th Mar 12
Location: Your mum's house
User status: Offline
|
How does your barcode scanner work? Does it automatically type into whatever text box / application you have in focus at the time, or does it go into the clipboard so you can paste it in or what?
Some sample Job IDs / tool IDs would be handy.
It doesn't sound like a difficult job.
|
Nismo
Member
Registered: 12th Sep 02
User status: Offline
|
Most barcode scanners are just text input so you would click into the excel cell and then scan the barcode and to will input the code straight in.
|
