[AccessD] VBA Offline Help

Thu Jul 28 20:48:31 CDT 2022

Instead of emails, an alternative would be to set up a simple website or FTP site.
They they should be able to download any files you put up there for them.

Like:
https://camcopng.com/download/BasicHelpDemo.zip

You and your partner do have a registered domain for your business don't you? :)

On 28 Jul 2022 at 21:29, John Colby wrote:

> 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/mali
> > > > > > > ciou 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/05ff9681
> > > > > > > > > 0741 94e2 f6 6f1d 8ee36acceb7a906b 6b/VBA/Offline-Docs
> > > > > > > > > <https://github.com/OfficeDev/VBA-content/tree/05ff968
> > > > > > > > > 1074 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
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com