How do I add links to files/folders/applications to buttons in access?

[mrushton]

Hi am am trying to add a few functions to buttons on a checklist and am not sure how, I am trying to acheive this...

1. Start a specific application on click

2. Open a specific file on click

3. Open a specific folder on click

4. Add "Browse folder" lookup" to hyperlink field and when user selects file the name is stored in the field

5. Attach specific PDF to outlook email, capturing email address from a specific field

And I would like to automatically update a value in a field based on the user clicking each button (its a checklist so setvalue to "Complete").

Sorry know its alot to ask. I am just new to access but have been asked to achieve these things and don't have any talent here to help me.

Many Thanks
*M


I assume

 

[jimlee]

right click on the button you want to add a link to and choose properties.

on the Format tab there is a hyperlink address property,
if you want to open a specific file then click the builder button (elipses) at the side of the property, (you'll have to click in the property first to see it) and select the relevant file.

if you want your users to open a specific folder or browse then you can do this in the same way as above but just choose a folder to open instead of a file.

to automatically update a value in a field that is on the form add something like

me.YourFieldName = somevalue

to the OnClick event for the button, for example, if you had a check box called Check1 then your code would read

 me.Check1 = true

hope this points you in the right direction


jimlad

"There is more to life than simply increasing its speed."
-Mahatma Gandhi

 

[mrushton]

Thanks I found the hyperlinks option right after I sent this. I will try the update now.
*M