Link to home
Start Free TrialLog in
Avatar of Kinlene
KinleneFlag for United States of America

asked on

MS Access database and Metrologic Barcode Scanner Issue.

To whom it may concern:

I am not new to MS Access, however, I am new at trying to integrate a barcode scanner as a data entry device for MS Access.  I have spent the better part of the day reading everything I can find about my specific scanner (Metrologic MS1633 Bluetooth) to no avail.  My basic problem is this;  Every time I scan an item into a combo box lookup field  the field goes blank and the field doesn't execute the look up.  If I select another field on the form, and then return to the lookup field, the scanned information shows up mysteriously and the field executes the lookup showing the data I was looking to retrieve in the first place.  WTF.  I have tried to set the focus back to the field, even set the focus to a different field programmatically and then back to the original field via code and that didn't work.  I have turned off all the carriage returns and the auto tabs that the barcode scanner is capable of sending and that didn't work.   The problem has been frustrating to say the least.  Oh, it gets better.. I have a USB Wedge version that connects via a cable and it works as programmed.  The problem is I need to use the wireless bluetooth equivalent for my application.  The bar code scanner works exactly like the other functioning scanner on a regular "Note Pad" form, but as soon as I try it within my database, BAM! it doesn't work.
Barccode-issue.txt
Avatar of Kinlene
Kinlene
Flag of United States of America image

ASKER

I finally was able to upload my database.  The form with the mis fireing control is; ADPE Inventory Inspection.  The field combo28.  I plan on correcting combo 30 as well.  Thanks for any assistance you can provide.  I am really hoping for a programming solution as looking into changing the barcode scanner programming seems futile. Any advice you can provide will be greatly appreciated.

Ed
ADPE-Database-.accdb
Avatar of Jim Dettman (EE MVE)
Ed,

<<Oh, it gets better.. I have a USB Wedge version that connects via a cable and it works as programmed.  >>

<<I am really hoping for a programming solution as looking into changing the barcode scanner programming seems futile. Any advice you can provide will be greatly appreciated.>>

 Sorry to say, but from what you've said, it's the scanner that's at fault.

<<The bar code scanner works exactly like the other functioning scanner on a regular "Note Pad" form, but as soon as I try it within my database, BAM! it doesn't work. >>

  That was a good thought, but Notepad can't show data in hex and you'll need that to show non-visible characters.  If you do, what your going to find is that the scanner is transmitting something additional besides the characters you see and this:

<< If I select another field on the form, and then return to the lookup field, the scanned information shows up mysteriously and the field executes the lookup showing the data I was looking to retrieve in the first place. >>

 Confirms that along with the fact that another scanner works as it should.

Jim.
Avatar of Kinlene

ASKER

The problem is, I have already attempted to turn off everything on the scanner that may be transmitting extra characters.  I have even created barcodes without anything extra in them to see if it was the barcodes itself (PDF 417).  I made some progress by turning off the carriage return suffix and the auto tab suffix I also explored some possible prefix characters.  The barcode is being transmitted to the computer but with error.  I have restored the factory settings on the scanner multiple times and programed each barcode type that I need one at a time testing each one.  It doesn't seem to matter weather it is a PDF, Data matrix, Code 39 , 2 of 5, Postal, UPC etc.  They all seem to be transmitting a extra something.  This something is the same for all of them.  Nothing in the literature provided on the web or which the equipment offers a working solution.  I was hopping that some code in access could undo what the scanner is doing.  This is why I referenced that fact that when I change the focus to another field and then back to the combo box that the data execute correctly.  I just can't figure out what code would do what I am trying to do.   I explored set focus and different calls (On Exit) etc.
<<I was hopping that some code in access could undo what the scanner is doing. >>

  Hard to say what that might be unless you know what the scanner is doing.

  A hex editor would be best, so you could see the actual characters.  You might want to try this one:

  http://www.ultraedit.com , which is a popular one, but there are many out there.

  Lacking that, I would make a form with two text controls on it, and place a STOP in one controls KeyDown, KeyUp, KeyPress,  and OnChange events (the second is just so it has some place to move focus to).  I'd also place one in the BeforeUpdate, AfterUpdate, Lostfocus, and Exit Events so you know when/how the control was trying to be exited (ie. does it loose focus without being exited).

  When you hit those stops, you should be able to see each and every character that comes across.  If you don't, then it's some type of control/special character (such as an esc).  In that case, you may might try turning on the forms KeyPreview and trapping the keystrokes in the Up/down and press events at the form level.

  If you don't get anywhere with that, I'll dig into the docs for the scanner and see if I can figure otu what might be causing the problem.

Jim.
Avatar of Kinlene

ASKER

My next quesition is this... If their is other charaters that the barcode scanner is sending, then why, when I select a different field and then select the barcode lookup combo box does the search execute successfully?  If I had other "invisable charaters" wouldn't the executed search fail?  In my case it succeed each time.  Isn't this unusual?  I can provide every document I have read on the subject of my scanner if you wish.
<<If I had other "invisable charaters" wouldn't the executed search fail?  In my case it succeed each time.  Isn't this unusual?  I can provide every document I have read on the subject of my scanner if you wish. >>

  The characters don't end up in the control as data, but rather cause Access or the form to take some type of action.  It may be something like an F5 or F9, but it's hard to say exactly what.

  Also you indicated that with a USB wedge device your combo/scan worked correctly.  That implies that your combo and form programming are correct and it's the scanner that is doing something extra.

  Keep in mind that as far as Access is concerned, it's just sitting there waiting for input (I'm assuming you've written no special code for including this blue tooth scanner).  It doesn't know that the data is coming from a scanner vs being typed at the keyboard.

Jim.
ASKER CERTIFIED SOLUTION
Avatar of Kinlene
Kinlene
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kinlene

ASKER

I only wish to provide the Expert Exchange community the solution.  I didn't see a way to withdraw my question.  I due belive the solution will help someone else.  It took a week of trouble shooting and three different agencies to solve the problem.  I give the solution an "A" and every one involved helped lead to resolution.
<<The barcode scanner wasn't the trouble at all.  In this case it was the software application named "Softwedge".  (Bridge between the USB and the Bluetooth radio).>>

  Well in a sense that is the "scanner", because without the software in there, you would not see scans in Access (software + hardware = ability to scan).  Probably could have gotten there had you mentioned that there was additional software between the hardware and the Access app.  I assumed a simple driver was at work, which was my fault.

  Glad to hear you found the problem though and are working.

Jim.