Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access database and Metrologic Barcode Scanner Issue.

Posted on 2011-09-10
9
Medium Priority
?
1,067 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:Kinlene
  • 5
  • 4
9 Comments
 

Author Comment

by:Kinlene
ID: 36516289
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
0
 
LVL 58
ID: 36516414
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.
0
 

Author Comment

by:Kinlene
ID: 36516959
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.
0
Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

 
LVL 58
ID: 36522586
<<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.
0
 

Author Comment

by:Kinlene
ID: 36522911
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.
0
 
LVL 58
ID: 36522994
<<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.
0
 

Accepted Solution

by:
Kinlene earned 0 total points
ID: 36547332
This issue was resovled by a Honeywell Tech.  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). Users must open the application "Softwedge" and disable the CR and LF suffix on the main window that opens. as well as the scanner firmware by scanning the codes.  It doesn't work when you only disable one you must disable both.

Honeywell Tech; "You need to turn off the CR and LF in softwedge as well.  Right "click" on the blue and black ball in the system tray by the clock on your monitor.  Go to connect serial.  Turn it off in there."

Problem Solved.
0
 

Author Closing Comment

by:Kinlene
ID: 36565549
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.
0
 
LVL 58
ID: 36548735
<<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.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question