João serras-pereira
asked on
opening file dialog in VBA
Hi -
I am revamping a 6 year old app (never touched again on it...) for ms/access 64 bit and polishing interface, adding functionality and ruggedising a bit. The app used to store documents in a master folder and a reference to them in the DB. In those days I used a function that I picked from some sample (maybe EE...), named FileToOpen(searchFolder) that would show a dialog and, if the user selected a file would return the path to it, or an empty string.
Now in 64 bit, I did put the PtrSafe, but the function quickly (In a flash that we may see or not) just does nothing.
So I am asking it someone has an example similar to the function, that I could use in ms/access 2016 - 64 bit and (I can dream), I could also use to show the file inside a form? (namely for PDF files that would represent 90% of all files)
any help is welcome
I am revamping a 6 year old app (never touched again on it...) for ms/access 64 bit and polishing interface, adding functionality and ruggedising a bit. The app used to store documents in a master folder and a reference to them in the DB. In those days I used a function that I picked from some sample (maybe EE...), named FileToOpen(searchFolder) that would show a dialog and, if the user selected a file would return the path to it, or an empty string.
Now in 64 bit, I did put the PtrSafe, but the function quickly (In a flash that we may see or not) just does nothing.
So I am asking it someone has an example similar to the function, that I could use in ms/access 2016 - 64 bit and (I can dream), I could also use to show the file inside a form? (namely for PDF files that would represent 90% of all files)
any help is welcome
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER