ACCESS FEED: [MS_AccessPros] RE: RE: Smartphone Barcode Scanner with Access

Senin, 25 November 2013

[MS_AccessPros] RE: RE: Smartphone Barcode Scanner with Access

Thanks, sorry for the lateness. Real busy with a lot of projects and items. I'll look into those options as well. I'm familiar with ID Automation software. I downloaded the free version, but it puts the word "DEMO" at the beginning of the barcodes, this is irrelavent as I can take that out through the split function so it wont used. I only need to be able to scan the datamatrix barcodes to verify the cardholder in the database.

---In MS_Access_Professionals@yahoogroups.com, <yahoo@...> wrote:

Brad, there are a number of ways to go when using a webcam for your purposes.

Your choice will depend on your skills and how much time and/or money you are prepared to invest. Best Price/value way might be to take a look at viscomsoft's OCX which in the basis version enables you to capture images from the WebCam which you might then pass through a bar/Q-Code recognition module to recognise/extract the card data. They do however also do a version, possibly the easiest solution, which will read barcodes from the captured images thiscosts a bit more money but less of your time. The barcode capable version I have not personally tested, the capture version(s) I have used. At the other end of the scale there's the "do it all yourself with the help of available open-source and/or code-examples" which is the way to go if your time is cheap and your ingenuity unbounded :-)

(this is my third attempt to reply, Yahoo's software refuses to work with my Firefox and now rejects my email responses, so, here I am in Chrome again... did Google buy Yahoo?!?)

---In ms_access_professionals@yahoogroups.com, <drc0369@...> wrote:

I need to be able to scan a ID card so the card info will pull up the card holder's record in access through VBA. Never thought about using a webcam, I do have an old Logitech QuickCam. How would I set it up to read data matrix barcodes? Would it automatically work as a scanner and auto scan it?

---In MS_Access_Professionals@yahoogroups.com, <yahoo@...> wrote:

I may be misunderstanding your question but, aside from the question as to how you might expect your idea to work (somebody would have to write an App and if they are writing an App they would probably implement the whole thing just as many many apps have done already), why would you want to do this? A WebCam is cheaper than a smartphone and you can attach it to your Access database using available OCXs.

However, I did actually write a mobile, windows mobile, App to scan RFID Tags and where I currently work they use a movbile device to scan barcodes which are then entered, via WLAN/WiFi into a text file which is then read by a server task and further processed into database (actually SQL Server but it could have been Access.) That's why I ask if I've understood your question/application properly.

---In ms_access_professionals@yahoogroups.com, <drc0369@...> wrote:

Hello all,

I've tried searching to see if there are solutions to use a mobile device's barcode scanner app to scan barcodes into access, but found none. Is this possible yet? Aside from creating a mobile app to work specifically with Access.