[AccessD] mscomctl

[Paul Wolstenholme]

Jim,

I used
http://www.billproduction.com/
The solution is cheap (free for testing and a small charge for a licence
for each computer lasting its lifetime).
The product is quite flexible but the complexity of the options is
compensated by the free quick support that is offered.  It has a minimal
footprint - no bloat or product creep.
The way I chose to use it wasn't quite one of his recommendations - I have
Access write a file that is immediately interpreted as a command to 'type'
the characters of the weight.
It is readily configured to show the live weight reading in a button that
floats over a specified Access window.

Next month one of the weighbridges is being updated with TCP/IP replacing
RS232.  The software from BillProduction will handle it with a
configuration change.  Access users without the weighbridge or with older
weighbridges are unaffected.

I chose that software because it is what google could find for me at the
time (2013).

Apologies to John for this having digressed from his original question.

Paul Wolstenholme


On Tue, 19 Oct 2021 at 00:22, Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
> Curious as to what you used.
>
> I helped someone in Australia with a weigh bridge, but I replaced the com
> control with Win API calls:
>
>
> https://www.experts-exchange.com/articles/31440/Supporting-serial-communicat
> ion-devices-in-Microsoft-Access-without-the-use-of-ActiveX-controls.html
> <https://www.experts-exchange.com/articles/31440/Supporting-serial-communication-devices-in-Microsoft-Access-without-the-use-of-ActiveX-controls.html>
>
>  I think though that EE is back to everything being behind a paywall, so
> that link may not work.
>
> Jim.
>
>
>
> -----Original Message-----
> From: AccessD On Behalf Of Paul Wolstenholme
> Sent: Monday, October 18, 2021 2:01 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] mscomctl
>
> .. and that is exactly the same reasoning why I replaced the 3rd party
> serial communications add-on I inherited.  I replaced it with a wedge
> application that interacts with the OS rather than with Access.  It
> presents the current weight on the weighbridge as if they were typed
> characters and Access (with the cursor already positioned using vba code)
> accepts that as input.
>
> Paul Wolstenholme
>
> On Sun, 17 Oct 2021 at 02:32, John Colby <jwcolby at gmail.com> wrote:
>
> > Yea I agree.  As much as I would like colors, fonts and highlights, it's
> > just not worth the headache.
> >
> > On Fri, Oct 15, 2021 at 7:22 PM Anita Smith <anita at ddisolutions.com.au>
> > wrote:
> >
> > > I've completely stopped using anything not built in. It's not worth the
> > > hassle.
> > >
> > > I use subforms instead of listboxes in many cases.
> > >
> > > I'm currently busy removing a third party listbox from my largest
> > > application as I'm worried it's going to stop working any day.
> > >
> > > Anita
> > >
> > >
> > >
> > > -------- Original message --------
> > > From: John Colby <jwcolby at gmail.com>
> > > Date: 16/10/21 7:57 am (GMT+10:00)
> > > To: Access Developers discussion and problem solving <
> > > accessd at databaseadvisors.com>
> > > Subject: [AccessD] mscomctl
> > >
> > > Does anyone use this with Access 2019?  I see so many references to it
> > > breaking with updates...
> > >
> > > I'd like to use the ListView control so I could use formatting but...
> not
> > > if it breaks every few months.
> > >
> > > --
> > > John W. Colby
> > > Colby Consulting
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > https://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> >
> > --
> > John W. Colby
> > Colby Consulting
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>