Access/VBA doesn't understand ComPort data after upgrade to Win11.

Praedico

New Member
Joined
Jul 17, 2008
Messages
43
I have an Access DB that can (in Windows10) get data from a GPS receiver assigned to a com port.
The organization has decided to upgrade our computers to Windows 11, now Access/VBA no longer understands the data coming from the GPS receiver.
I am adding an image showing the "data" Access sees when it looks at the com port. Basically, a bunch of squares instead of the alphanumeric data that normally comes through.

Any ideas on how I can get it to understand the data again?

Thanks in advance
 

Attachments

  • VBA_Screenshot.png
    VBA_Screenshot.png
    13.7 KB · Views: 7

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Is that your actual output? The vbe cannot replicate certain fonts, although I think it usually represents them as question marks (can't remember exactly but they might be upside down). When Window version was updated you may have lost a driver for the port(s). I'd check to see if any drivers are listed as missing or whatever the classification is. A post here suggests getting the latest driver
 
Upvote 0
Is that your actual output? The vbe cannot replicate certain fonts, although I think it usually represents them as question marks (can't remember exactly but they might be upside down). When Window version was updated you may have lost a driver for the port(s). I'd check to see if any drivers are listed as missing or whatever the classification is. A post here suggests getting the latest driver
Yes, those squares in the image are what Access/VBA is interpreting from the com port. It works fine in other software, it's only broken in the Office products (I get the same result for similar code in Excel). I agree it's probably a driver issue. I'll give it to the smarter people in our organization to see if they can solve it. I'll leave this open for a bit longer to see if anyone pops on with a different insight, and/or reply to myself with the fix if/when I find one.
Thank you.
 
Upvote 0

Forum statistics

Threads
1,223,162
Messages
6,170,432
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top