i can't understand it. how to solve it.

Shafique

Board Regular
Joined
Nov 23, 2018
Messages
119
i have to save the weight a stack of sheets. So i want to do it in MS Access that's why i create a database with only one table named "tblweight"
i set three fields in my table
1..........ID.........Autonumber
2..........QTY.....number
3.........weight...number

In QTY textbox i put the number of sheets of every stack
here i want a after update event on [QTY] that get that weight scale data into [WEIGHT] textbox that connected with my PC via a COM Port
i search the solution on internet and get this code but it is not compiling. how its works

any solution or suggestion
 

Attachments

  • error.jpg
    error.jpg
    128.8 KB · Views: 30
  • error2.jpg
    error2.jpg
    111.2 KB · Views: 29
Well I would expect you would need to open the port, before you can read from it?
You would most likely need to write first for whatever is on the other end to tell it to send the data?, so you need to read up on the device instructions?
 
Upvote 0

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Well I would expect you would need to open the port, before you can read from it?
You would most likely need to write first for whatever is on the other end to tell it to send the data?, so you need to read up on the device instructions?
this is my ................ device :)
 

Attachments

  • WhatsApp Image 2022-09-17 at 5.25.31 PM.jpeg
    WhatsApp Image 2022-09-17 at 5.25.31 PM.jpeg
    135.8 KB · Views: 12
  • WhatsApp Image 2022-09-19 at 8.07.49 PM.jpeg
    WhatsApp Image 2022-09-19 at 8.07.49 PM.jpeg
    78.5 KB · Views: 12
Upvote 0

Forum statistics

Threads
1,214,972
Messages
6,122,530
Members
449,088
Latest member
RandomExceller01

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