Link to folder from Access form

[RichP]

Hi there,
I'm fairly new to access, and can't work out how to make something work, any help gratefully received.

I have a database of projects (listing dates, teams, etc), and in a separate folder (c:\Project_Files) I keep a folder for each project (c:\Project_Files\Project A, Project B, etc) with all the documentation related to it (name of folder = name of project).

I use a form to review the basic information on each project, but I would like to add a button that will open up the folder for the project that I am looking at (eg an open command, or a hyperlink). I know I can add a label, and put the address into its properties, but since the address is different for each entry, how can I make it open the folder for the project that I am looking at (something like c:\Project_Files\{field project name})?

Many thanks,
RichP

 

[amigos]

You can do this using a short VBA code

Insert new Command Button on form, in design view open its properties and go to Event>On Click>[...] >Code Builder and insert code below to make it look like:

Private Sub NameOfYourCommandButton_Click()

NameOfYourCommandButton.HyperlinkAddress = "c:\Project_Files\" & NameOfControlWhichDisplaysProjectName.Value

End Sub


HTH

 

[RichP]

Amigos,
thanks for the help, this is what I was after.

Rgds,
RichP