Macro for Control Button to excel file or Outlook

[Koggala]

I am a complete Access novice, creating my first DB. I want to set up a control button on a form to open a particular excel file. I have looked through help and my physics degree does not help.

Also i want to create an email button that opens a new email in outlook with the email address already written in the to field.

How do i do it? I warn you now, i do not know VB at all. ray:

 

[bat17]

Your easist option for excel is to use a hyperlink in a lable rather than a button.
Create a lable and add the text to it that you want to show on the form, then click the build button ... againt the "hyperlink Address" field in the lables properties and use the dialog box to navigate to your file.

For the email button you use the "SendObject" method of Docmd. Look it up in help for the various arguments for it.

HTH

Peter

 

[Koggala]

Thanks for this solution, just what i wanted. Thanks again