Connect to a weight scale using com port in access form

[shod90]

Dear Gents , I have an electronic scale connected to my PC using RS232 .. I need to make a tiny software that read from scale the weight and insert in a table that weight.
i have been searching a lot for a solution but i didn't find a code except for EXCEL ,, I can't understand well the code written in excel , But when i open that code it works perfectly and read from scale .
The only favor i need is to change the code from excel to be working on access , Can someone do that favor for me?.
Excel COMM interface without 3rd party files.zip

[ranman256]

normally you can import (or copy/paste) the modules into access modules and call them the same way.

Tho my Access 2019 crashes when the com port activates. Older versions of access seem to work, but not 2019.
To get around it, I had to use the excel app (just like yours) to copy the value to clipboard then it pastes it into an access textbox.
It was a long way to get there but it worked.

[Welshgasman]

The code supplied is referring to ranges , so major rewrite needed.
It is also 64bit.

[Gicu]

Please have a look at the attached file, I have converted the Excel code you provided. Please note that it is totally untested as I do not have a COM port on my laptop.

Cheers,
Vlad

[shod90]

Please have a look at the attached file, I have converted the Excel code you provided. Please note that it is totally untested as I do not have a COM port on my laptop.

Cheers,
Vlad

brilliant !!! it starts reading from the scale but it keep reading continuously and with a weird format .

and yes the weight i put on the scale was 0.390 KG
but i only need to be one value without B0 which beside the reading.

[Gicu]

I assume you got that by clicking Connect? The way the original code works is to keep reading from the COM port until you disconnect. A bit later when I get home I'll update the sample to do a one time reading.
Cheers,
Vlad

[Gicu]

Can you please try this one (click the Read Scale button)?

Cheers,
Vlad

[shod90]

Can you please try this one (click the Read Scale button)?

Cheers,
Vlad

Works great , remains some editing on the code to become suitable with my case and that’s my turn .
Thanks alot

[Gicu]

You're very welcome, good luck with your project!
Cheers,

[Umar Yousufzai]

Hello sir
I need the attached file but i cannot download it please help me
umarrahman311@gmail.com

[Umar Yousufzai]

Hi @shod90
I need the access file
When i click on the attachment nothing happens
Please send me the file
Thanks in advance

[Welshgasman]

Hi @shod90
I need the access file
When i click on the attachment nothing happens
Please send me the file
Thanks in advance

Worksfor me?

[Umar Yousufzai]

Ok done.....
I was trying on my phone.
Thanks for your reply.

[Welshgasman]

Ok done.....
I was trying on my phone.
Thanks for your reply.

Strangely enough I tested it on my phone, as I was parked in a hospital car park?