[AccessD] Need Open File Dialog Box

Rocky Smolin rockysmolin at bchacc.com
Tue Aug 7 18:38:42 CDT 2018


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



More information about the AccessD mailing list