[AccessD] VBA Offline Help

[Stuart McLachlan]

It is the certainly of use if you want to create instructions for users. 

The  HelpFIle property is for setting your own application Helpfile.

If you create a CHM  application Help file with a third party tool such as WinCHM (my 
go-to), place it in the same directory as your .accdb file and set the file name in the form's 
HelpFIle property,  it will open when you hit F1 while you are on the form.

While you can't set it globally AFAIK, It is not very onerous to set it for each form where you 
want context sensitive help.

If you have set  Context Ids in the .CHM file (WInCHM does that automatically for each 
page you create) and on controls, the Helpfile will open to the appropriate entry if you hit F1 
while a control has the focus.


-- 
Stuart


On 28 Jul 2022 at 17:21, Paul Wolstenholme wrote:

> I've always wondered whether the .HelpFile property is of any
> practical use.  It exists at least for Forms, Reports and the Err
> object but I see no information on setting it globally or inheriting a
> default.
> 
> Paul Wolstenholme
> 
> On Thu, 28 Jul 2022 at 15:29, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > Unfortuantely not, but I'v pinned the CHM file to the taskbar so
> > that I can call it up easily when needed. :)
> >
> >
> >
> > On 27 Jul 2022 at 22:57, John Colby wrote:
> >
> > > Way cool.  Thanks for sharing.  Does this integrate back into the
> > > respective app by any chance?
> > >
> > >
> > > 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/05ff9681074194e2f6
> > > > 6f1d 8ee36acceb7a906b 6b/VBA/Offline-Docs
> > > > <https://github.com/OfficeDev/VBA-content/tree/05ff9681074194e2f
> > > > 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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>