[AccessD] Need Open File Dialog Box

Charlotte Foust charlotte.foust at gmail.com
Tue Aug 14 09:25:55 CDT 2018


Office.FileDialog is what I've been using for years.  It works as
advertised without any problems I have encountered.  However, I have never
worked in 64 bit Office.

Charlotte Foust
(916) 206-4336

On Tue, Aug 7, 2018 at 4:38 PM, Rocky Smolin <rockysmolin at bchacc.com> 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,
>
> r
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> David Emerson
> Sent: Tuesday, August 07, 2018 3:10 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Need Open File Dialog Box
>
> Hi Rocky,
>
> What does that function actually do - does it just return the path of a
> folder or file, or does it actually open a selected file?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Rocky Smolin
> Sent: Wednesday, 8 August 2018 9:48 a.m.
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Need Open File Dialog Box
>
> Dear List:
>
>
>
> A client has me adding some functions to a legacy app that was written in
> 32
> bit Access. So it has trouble running on the 64 bit Access he has on his
> machine.  Switching to 32 bit is not an option.
>
>
>
> The adh common open file dialog function which has been working so nicely
> no
> longer works - it uses comdlg32.dll.
>
>
>
> Declare PtrSafe Function adh_apiGetOpenFileName Lib "comdlg32.dll" _
>
> Alias "GetOpenFileNameA" (ofn As tagOPENFILENAME) As Boolean
>
>
>
> I added the PtrSafe and changed the declarations of Long to LongPtr.  But
> no
> cigar.
>
>
>
> So I'm looking for a replacement open file dialog box function that might
> work on both 232 and 64 bit boxes.
>
>
>
> Any help greatly appreciated by me and my client who HAS to get a report
> out
> this week. L
>
>
>
> MTIA
>
>
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 760-683-5777
>
>  <http://www.bchacc.com> www.bchacc.com
>
>  <http://www.e-z-mrp.com> www.e-z-mrp.com
>
> Skype: rocky.smolin
>
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> 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