[AccessD] Need Open File Dialog Box

David Emerson newsgrps at dalyn.co.nz
Tue Aug 7 20:00:37 CDT 2018


I have found that as long as you build in the earliest version you are ok
when it is run on later versions.

It is only when it is run on earlier versions does the problem start with
referencing.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand




-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Stuart McLachlan
Sent: Wednesday, 8 August 2018 12:47 p.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Need Open File Dialog Box

The gotcha will be when you  distribute your application.

Office.FileDialog relies on a reference to the Microsoft Office Object Model
library, which is 
version specific.

So it will be problematic if you build  in one version of Office and run it
in another (especially if 
you are distributing an accde!)


On 7 Aug 2018 at 16:38, Rocky Smolin wrote:

> David:
> 
> I fixed it by using the Office.FileDialog object.  Simple and
> effective.  So far.  Don't know what kind of gotchas accrue to this
> object but it's working. :)
> 
> Best,
> 

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




More information about the AccessD mailing list