[AccessD] Need Open File Dialog Box

[Stuart McLachlan]

Just ran into anotheer wrinkle with PtrSafe and LongPtr two days ago..

One of the test team for an application I am working on has Office 2007 and it spat the 
dummy on the 32/64 GetFileName() code.

To get it working  on A2007 as well as both 32 and 64bit A2010 onwards, I had to use:

#IF VBA7
   Declare PTRSAFE Function .......
   ......LONGPTR.....
#ELSE
  Declare Function....
 .....LONG......
#END IF



On 14 Aug 2018 at 7:25, Charlotte Foust wrote:

> 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
> >
> >
> >