?
Solved

MS Access database and Metrologic Barcode Scanner Issue.

Posted on 2011-09-10
9
Medium Priority
?
1,041 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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
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…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

801 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