Opening files from a folder path stored in Access

#1

I know not to store files in Access, only the path to the file. I know
how to save the path into a text field.

So, can I create a button to Open that file from Access? These will be
like pdfs, Excel, TIFs.

I'm a little stuck. Any help is appreciated.

#2

musicloverlch <lhowey (AT) gmail (DOT) com> wrote in
news:d4d9a767-2d4a-4cb4-99eb-639da452c7cd (AT) f17g2000yqh (DOT) googlegroups.co
m:

Quote:

I know not to store files in Access, only the path to the file. I
know how to save the path into a text field.

So, can I create a button to Open that file from Access? These
will be like pdfs, Excel, TIFs.

I'm a little stuck. Any help is appreciated.

There's code for the Windows API for the FileOpen dialog on the
Access web:

http://access.mvps.org/access/api/api0001.htm

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#3

If I understand you correctly, if the full path is stored in variable
strFile, you'd use

Application.FollowHyperlink strFile

"musicloverlch" wrote in message
news:d4d9a767-2d4a-4cb4-99eb-639da452c7cd (AT) f17g2000yqh (DOT) googlegroups.com...

I know not to store files in Access, only the path to the file. I know
how to save the path into a text field.

So, can I create a button to Open that file from Access? These will be
like pdfs, Excel, TIFs.

I'm a little stuck. Any help is appreciated.

#4

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Opening files from a folder path stored in Access

comp.databases.ms-access comp.databases.ms-access

Opening files from a folder path stored in Access - 09-20-2011 , 02:22 PM

Re: Opening files from a folder path stored in Access - 09-20-2011 , 04:14 PM

Re: Opening files from a folder path stored in Access - 09-20-2011 , 06:39 PM

Re: Opening files from a folder path stored in Access - 09-29-2011 , 03:05 PM