Solved

MS Access database and Metrologic Barcode Scanner Issue.

Posted on 2011-09-10
9
1,005 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 57
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
 
LVL 57
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

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 57
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 57
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now