Reading data from a scale via serial port

%3CLINGO-SUB%20id%3D%22lingo-sub-2792764%22%20slang%3D%22en-US%22%3EReading%20data%20from%20a%20scale%20via%20serial%20port%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2792764%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%20I%20am%20trying%20to%20find%20some%20way%20to%20write%20data%20coming%20from%20a%20scale%2C%20device%20that%20reads%20weights%2C%20into%20a%20data%20field%20for%20an%20already%20created%20form.%20The%20scale%20would%20be%20connected%20to%20a%20computer%20via%20a%20serial%20port.%20User%20open%20up%20the%20form%20with%20fields%20filled%20in%20by%20the%20user%2C%20the%20form%20references%20a%20unique%20id%20(that%20was%20inserted%20by%20the%20user)%2C%20that%20unique%20id%20is%20used%20to%20pull%20the%20correct%20weight%20data%20from%20the%20scale%20and%20populate%20onto%20the%20form.%26nbsp%3B%20I%20have%20read%20that%20I%20need%20to%20create%20an%20application%20via%20VBA%20using%20MSCom%20but%20I%20dont%20see%20them%20connecting%20VBA%20application%20with%20Access%20form.%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2792764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20stream%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emscom%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eserial%20port%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EVBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2806254%22%20slang%3D%22en-US%22%3ERe%3A%20Reading%20data%20from%20a%20scale%20via%20serial%20port%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2806254%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1169187%22%20target%3D%22_blank%22%3E%40cheo_fpc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20links%20may%20help%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.windmill.co.uk%2Faccess.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.windmill.co.uk%2Faccess.html%2C%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.granite.ab.ca%2Faccess%2Fserialport.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.granite.ab.ca%2Faccess%2Fserialport.htm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2892021%22%20slang%3D%22en-US%22%3ERe%3A%20Reading%20data%20from%20a%20scale%20via%20serial%20port%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2892021%22%20slang%3D%22en-US%22%3Ein%20place%20of%20this%20if%20the%20manufacturer%20sells%20software%20to%20translate%20data%20is%20this%20reaching%20the%20same%20goal%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello all I am trying to find some way to write data coming from a scale, device that reads weights, into a data field for an already created form. The scale would be connected to a computer via a serial port. User open up the form with fields filled in by the user, the form references a unique id (that was inserted by the user), that unique id is used to pull the correct weight data from the scale and populate onto the form.  I have read that I need to create an application via VBA using MSCom but I dont see them connecting VBA application with Access form. Any help would be appreciated.

3 Replies
in place of this if the manufacturer sells software to translate data is this reaching the same goal?
Welcome back after a month. I had thought you weren't going to reply!

Sorry but I'm not sure what you are asking. 'Translate the data?
The links may provide an interface that will save you needing to create your own application.
I've never needed to do this so can't tell you whether it will suit your purposes