I have been using a routine from MS Access Inside Out 2003 (also on the Microsoft Website) to insert image paths into a field. I recently converted to MS Access 2010 64bit due to a need for compatibility with AutoCAD Revit 64bit. While the code compiles and the application seems to work, it will not open the file dialog to select a file to insert. The problem occurs in the comdlg module in the following section:
' Display the appropriate dialog.
If bOpen Then
Show = GetOpenFileName(OFN) <--This does not work
Show = GetSaveFileName(OFN)
The attached zip file includes a sample database along with sample images that should be located in a folder labeled "pictures" which is the default location.
I need to know how to open the file dialog box in 64bit VBA. The database will only compile in 64bit due to the declare statement including a PtrSafe function. If this is removed it will run fine in 32bit including the insert photo function.
Thanks for any assistance.