Creating a command button to open up a file listed in a textbox?

[Guest]

What would the code be for a command button to open up the file that is in a
text box location. For example, lets say i have a text box called "file
location" i want it that when i click on the command button, it will luanch
the file listed in that text box. Each record will have a diffrent file.
Also is there a way for me to do this "be able to launch the file" while in
datasheet view?
Also is there a way that i can have an "open" type box appear for me to
select the file, rather then me having to type the whole thing in manually?

thaknx

 

[David Lloyd]

The following KB articles may be a good reference for you.

http://support.microsoft.com/default.aspx?scid=kb;en-us;824272
http://support.microsoft.com/default.aspx?scid=kb;en-us;303066

Regarding launching the file from Access, there are different ways you can
do this depending on the exact type of file.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


What would the code be for a command button to open up the file that is in a
text box location. For example, lets say i have a text box called "file
location" i want it that when i click on the command button, it will luanch
the file listed in that text box. Each record will have a diffrent file.
Also is there a way for me to do this "be able to launch the file" while in
datasheet view?
Also is there a way that i can have an "open" type box appear for me to
select the file, rather then me having to type the whole thing in manually?

thaknx

 

[Guest]

Thank you. But I have multiple records, if i do it like in the first way, it
places it in all of the records. I want it to place it only in that record
location, and also for it to save it, so later on i can view it. and
regarding opening it, they will mostly be media files. basically i am
creating a databse to keep track of my media files. and i want to save the
locations of dioffrent ones, then click "open" to run them.

thankx