Software for Access to Handheld Device
- Thread starter aclemens
- Start date
boblarson
Smeghead
- Local time
- Today, 11:54
- Joined
- Jan 12, 2001
- Messages
- 32,059
Probably because they don't understand that you don't have Pocket Access files. You need something that works with SQL Server CE.
Atomic Shrimp
Humanoid lifeform
- Local time
- Today, 19:54
- Joined
- Jun 16, 2000
- Messages
- 1,954
I've had to set up barcode scanning in several of my past jobs - mainly for stocktaking.
The best handheld barcode scanners I ever found were these:
http://www.barcode.co.uk/products/metrologic-scanpal2.htm
Reason being: They're compact, light, rugged, have excellent battery life (from AAA batteries, so no downtime for charging) and they are moderately programmable as standard.
They can store a lookup table and be configured to capture multiple fields of data for each scanned item
For more advanced use, you can get BASIC and C compilers to create highly-customised capture applications for them.
Because they're a dedicated scanner, as ppposed to a multi-purpose handheld computer, they're also not such a target for theft as some other scanning solutions.
The best handheld barcode scanners I ever found were these:
http://www.barcode.co.uk/products/metrologic-scanpal2.htm
Reason being: They're compact, light, rugged, have excellent battery life (from AAA batteries, so no downtime for charging) and they are moderately programmable as standard.
They can store a lookup table and be configured to capture multiple fields of data for each scanned item
For more advanced use, you can get BASIC and C compilers to create highly-customised capture applications for them.
Because they're a dedicated scanner, as ppposed to a multi-purpose handheld computer, they're also not such a target for theft as some other scanning solutions.
Atomic Shrimp
Humanoid lifeform
- Local time
- Today, 19:54
- Joined
- Jun 16, 2000
- Messages
- 1,954
Are you expecting the device to be able to ask different questions depending on the identity of the item scanned? (within a single outing)
no. it'll be the same questions.
-questions are made on a PC using access
-questions are transferred to scanner
-scanner is used to scan barcodes on inventory
-barcodes work as a identification and store the answers to the questions for the specific inventory
-total inventory questions are compiled and uploaded back into PC with microsoft access
-data is compiled
-questions are made on a PC using access
-questions are transferred to scanner
-scanner is used to scan barcodes on inventory
-barcodes work as a identification and store the answers to the questions for the specific inventory
-total inventory questions are compiled and uploaded back into PC with microsoft access
-data is compiled
Hmm. Just to be absolutely clear as your earlier post left me with an impression that the user would have to input some answers to the questions pertaining to the object being to the scanned. Are you saying it should be completely automated and the user only need to scan the product?
If it's going to be automated and the only thing user needs to do is to just scan the thing, then I would say you don't even need a software to run the program; just send it off to the Access and have code behind the form fire and act upon the input.
If it's going to be automated and the only thing user needs to do is to just scan the thing, then I would say you don't even need a software to run the program; just send it off to the Access and have code behind the form fire and act upon the input.
Atomic Shrimp
Humanoid lifeform
- Local time
- Today, 19:54
- Joined
- Jun 16, 2000
- Messages
- 1,954
Really, that's just a pretty simple data capture job. Almost any kind of handheld scanning device should be able to do it.
this is the most basic way i can explain.......................
-a QA operator sits down at his desk.
-he needs to compile some statistics about the 27 office telephones at work.
-he powers on his PC and opens microsoft access.
-he creates 3 questions using access:
-using software 'x', he transfers his questions from accel on to his barcode scanner.
-he unplugs the scanner.
-he walks over to the first phone and scans a barcode located on its surface.
-the barcode opens up the questions he created in accel on to his hand held pc/scanner.
-he goes down the list and answers the questions using the scanners key pad:
-the answers are stored and he proceeds to the next phone.
-he again, scans the barcode on the phone, goes through the questions, answers them, and stores the data.
-he proceeds to do this for the remaining 25 phones.
-after the 27th phone he connects the hand held pc/scanner back to his computer.
-he opens up software 'x' and tells it to open the data from the scanner into microsoft accel.
-microsoft accel opens up and all of the data from the scanner is in an organized report fashion, ready to be analyzed.
-he prints out the information and shows it to his boss.
-his boss sees that 2 of the phones do not have dial tones and one does not dial out of area.
-he orders two new phones and contacts IT about the one that doesn't dial out of area.
-job well done.
-a QA operator sits down at his desk.
-he needs to compile some statistics about the 27 office telephones at work.
-he powers on his PC and opens microsoft access.
-he creates 3 questions using access:
-he hooks up his hand held pc/scanner to his computer.
-using software 'x', he transfers his questions from accel on to his barcode scanner.
-he unplugs the scanner.
-he walks over to the first phone and scans a barcode located on its surface.
-the barcode opens up the questions he created in accel on to his hand held pc/scanner.
-he goes down the list and answers the questions using the scanners key pad:
-the phone appears to be fully functioning, but doesn't dial out of area.
-the answers are stored and he proceeds to the next phone.
-he again, scans the barcode on the phone, goes through the questions, answers them, and stores the data.
-he proceeds to do this for the remaining 25 phones.
-after the 27th phone he connects the hand held pc/scanner back to his computer.
-he opens up software 'x' and tells it to open the data from the scanner into microsoft accel.
-microsoft accel opens up and all of the data from the scanner is in an organized report fashion, ready to be analyzed.
-he prints out the information and shows it to his boss.
-his boss sees that 2 of the phones do not have dial tones and one does not dial out of area.
-he orders two new phones and contacts IT about the one that doesn't dial out of area.
-job well done.
Last edited:
i'm under the impression that this isn't true, but feel free to tell me if i'm wrong based on the example i just gave. im by no means an expert on this stuff obviously.
this site is blocked at my work.....
http://en.allexperts.com/q/Using-MS-Access-1440/Integrating-Wireless-Barcode-Scanner.htm
http://en.allexperts.com/q/Using-MS-Access-1440/Integrating-Wireless-Barcode-Scanner.htm
boblarson
Smeghead
- Local time
- Today, 11:54
- Joined
- Jan 12, 2001
- Messages
- 32,059
