[AccessD] VBA Offline Help

[Stuart McLachlan]

I've just run into one backward incompatibility.

I've occasionally used DAO  with COM (DAO.DBEngine) in 32bit compiled applications to 
connect to a .accdb.

Now that I'm  finally working primarily in 64bit Office it no longer works. 

(A side effect of the old - you can't have 32bit ans 64bit Office versions on the same 
machine)
 
I'll have to use ODBC from now on :(


On 28 Jul 2022 at 7:34, Jim Dettman via AccessD wrote:

> 
>  One of the things that is often overlooked with Access; fantastic
>  backward
> compatibility.
> 
>  It was not too long ago that I took a client from Access 2000 to
>  O365;
> MDB's are still running as MDB's, and there was not one iota of code
> change.
> 
> Jim.
> 
> -----Original Message-----
> From: AccessD On Behalf Of Stuart McLachlan
> Sent: Thursday, July 28, 2022 2:00 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] VBA Offline Help
> 
> Nope, I've just tested in 2021 and it still works well with a .CHM
> file I built years ago/
> 
> On 28 Jul 2022 at 1:31, John Colby wrote:
> 
> > Back in the day one could set help file names and numbers which
> > indexed into the file.  AFAICT MS abandoned all that.
> > 
> > On Thu, Jul 28, 2022 at 1:22 AM Paul Wolstenholme <
> > Paul.W at industrialcontrol.co.nz> 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/05ff9681074194
> > > > > > e2 f66f1d 8ee36acceb7a906b 6b/VBA/Offline-Docs
> > > > > > <https://github.com/OfficeDev/VBA-content/tree/05ff968107419
> > > > > > 4e 2f66f1 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
> > >
> > 
> > 
> > -- 
> > 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
>