[AccessD] mscomctl

[Jim Dettman]

Amazing the stuff you can find floating around.

 

I found a Ribbon tool in Brazil that has quite a few features, and is the only one I know of that can handle the backstage menu (for those interested  http://www.ribbons-access.com/index.htm)

 

Jim.

 

From: Paul Wolstenholme 
Sent: Monday, October 18, 2021 5:46 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: Re: [AccessD] mscomctl

 

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 <mailto: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 <https://www.experts-exchange.com/articles/31440/Supporting-serial-communication-devices-in-Microsoft-Access-without-the-use-of-ActiveX-controls.html> 
ion-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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto:AccessD at databaseadvisors.com> 
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com <mailto: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 <mailto:AccessD at databaseadvisors.com> 
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com> 
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com <mailto:AccessD at databaseadvisors.com> 
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com