[AccessD] Need Open File Dialog Box

Stuart McLachlan stuart at lexacorp.com.pg
Tue Aug 7 18:15:23 CDT 2018


This site actually shows you which Longs you need to change in OPENFILENAME :)

https://gpgonaccess.blogspot.com/2010/03/work-in-progress-and-64-bit-vba.html

On 8 Aug 2018 at 8:53, Stuart McLachlan wrote:

> >  I added the PtrSafe and changed the declarations of Long to
> >  LongPtr. 
> 
> Be careful with Long/LongPtr.  You should only change those Longs
> which are actual pointers to memory locations or handles.  All the
> others need to stay as Long.
> 
> On 7 Aug 2018 at 14:48, Rocky Smolin wrote:
> 
> > 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