Solved

MS Access database and Metrologic Barcode Scanner Issue.

Posted on 2011-09-10
9
1,029 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

707 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