[AccessD] VBA Offline Help

[John Colby]

Yep, except we have no access to a client's machine.  We have to send
everything as an attachment.  Which means it is subject to attachment
stripping. Change the extension to something innocuous.  You know the
drill. These are laptops assigned to the client, kinda like IBM would do.

On Thu, Jul 28, 2022 at 8:40 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> A simple test would be to locate (or place) any CHM file on a client's
> machine and try
> opening it.
>
>
>
> On 28 Jul 2022 at 20:17, John Colby wrote:
>
> > My read is that it uses IE to render the file.  If so it probably
> > won't work at this client since it shut down my access IE control when
> > IE tried to open in the control.  Their IT somehow figures out that IE
> > is trying to open and prevents it.
> >
> > That is why I went with my XMLHttp thing.  My partner is supposed to
> > get my code tested for that but so far has not.
> >
> > On Thu, Jul 28, 2022 at 7:53 PM Stuart McLachlan
> > <stuart at lexacorp.com.pg> wrote:
> >
> > > Doh!
> > >
> > > WinHlp32.exe was used for .hlp files.
> > >
> > > .chm files are opened by hh.exe (Microsoft HTML Help Executable)
> > >
> > > --
> > > Stuart
> > >
> > > On 29 Jul 2022 at 9:49, Stuart McLachlan wrote:
> > >
> > > > If it's your own .CHM, there is no danger - the danger is from
> > > > third party .CHM files of unknown provenance :)
> > > >
> > > > Yes, they still work from inside Access, at least in my case.
> > > > Check out the sample I posted (URL in a previous message).
> > > >
> > > > CHM files are opened with winhlp32.exe.
> > > >
> > > > --
> > > > Stuart
> > > >
> > > > On 28 Jul 2022 at 19:01, John Colby wrote:
> > > >
> > > > > So with all the dangers, do CHM files still work from inside of
> > > > > Access FEs?  It seems to indicate perhaps it is viewed by IE
> > > > > which at least on my client's systems, the IT department has
> > > > > locked out. Or is the CHM file now opened by edge or something?
> > > > >
> > > > > On Thu, Jul 28, 2022 at 6:11 PM Stuart McLachlan
> > > > > <stuart at lexacorp.com.pg> wrote:
> > > > >
> > > > > > Not just GMail:
> > > > > >
> > > > > > "Microsoft now considers .chm files to be potentially
> > > > > > dangerous. In fact, they are blocked by Outlook, Microsoft´s
> > > > > > email client."
> > > > > >
> > > > > > https://www.comparitech.com/blog/information-security/maliciou
> > > > > > s-ch m- files/
> > > > > >
> > > > > > --
> > > > > > Stuart
> > > > > >
> > > > > >
> > > > > > On 28 Jul 2022 at 8:24, John Colby wrote:
> > > > > >
> > > > > > > Do you have any idea why .chm files would be considered
> > > > > > > dangerous by gmail?  It complained when I tried to attach
> > > > > > > these file to send to a colleague.
> > > > > > >
> > > > > > > On Wed, Jul 27, 2022 at 10:51 PM Stuart McLachlan
> > > > > > > <stuart at lexacorp.com.pg> wrote:
> > > > > > >
> > > > > > > > Some clown at MS decide that anyone using an Access
> > > > > > > > version after 2013 would always have a good internet
> > > > > > > > connection and made F1 go to an MS website for every
> > > > > > > > little syntax lookup in VBA. They didn't think about
> > > > > > > > people like me :(
> > > > > > > >
> > > > > > > > (Just like the drive to force everyone to Office365! )
> > > > > > > >
> > > > > > > > I get really p***ed of when I just want to look up
> > > > > > > > something basic.
> > > > > > > >
> > > > > > > > I've just found a site with the last version of VBA
> > > > > > > > offline Help for Access, Powerpoint,Word and Excel Object
> > > > > > > > models converted to .CHM.
> > > > > > > >
> > > > > > > > It's not perfect, but at least I can now lookup a lot of
> > > > > > > > things when developing if the internet is down (not
> > > > > > > > uncommon) or when I am out of range of  any internet
> > > > > > > > connection (very common when travelling around PNG).
> > > > > > > >
> > > > > > > >
> > > > > > > > https://github.com/OfficeDev/VBA-content/tree/05ff96810741
> > > > > > > > 94e2 f6 6f1d 8ee36acceb7a906b 6b/VBA/Offline-Docs
> > > > > > > > <https://github.com/OfficeDev/VBA-content/tree/05ff9681074
> > > > > > > > 194e 2f 66f1 d8ee36acceb7a906b6b/VBA/Offline-Docs>
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > 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
> > > > > >
> > > > >
> > > > >
> > > > > --
> > > > > 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
> > >
> >
> >
> > --
> > 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