Search results

I'm not sure but the command button works perfectly when I open the subform only. Why does it lose focus when I open the mainform and attempt to execute it ?

This is the code I'm using: Private Sub cmdEmail_Click() On Error Resume Next cmdEmail.HyperlinkAddress = "mailto:" & Me!EmailName End Sub

I am trying to email from a subform by using a command button on the subform however it is not working. It works fine when I open the subform by itself but not when I open the mainform. I am pulling the email address from the mainform. When I click on the command button nothing happens. Can...

Jim, thanks again for your help. I was able to pass the variable to the hyperlink by placing the following in the onclick event of one of my fields. Private Sub Dept_Click() Application.FollowHyperlink "\\X\company\Trainings\" & Me![Dept] End Sub It worked like a charm. Thanks again.

Jim, thanks for the quick response and sorry for the lack of info. I guess I'm using a combination of both procedures. In the 'on-click" event of my textbox(filenames) I execute an event procedure: Private Sub Dept_Click() FollowHyperlink strMyDocPath End Sub Private Sub Form_Load()...

I have a form in my "Trainings" db that when opened displays a filenames and an option group (A thru M) for filtering purposes. For example: Button "A" displays files(both Word and Powerpoint files) that begin with the letter "A". I want to link directly to a specific file when that file is...