[MS_AccessPros] Re: Open html file from a message box.

 

Jim

I was just about to suggest that when I got pulled away to do some real work.Glad you got it on your own.

-Bill

---In MS_Access_Professionals@yahoogroups.com, <luvmymelody@yahoo.com> wrote :

Hello,

I have added the following code to open a html page located in a network folder. The html page is a link to an online documentation for our database. The code opens internet explorer but not the html file. 

Is there something that I am missing? 

Thank You for your help

Jim Wagner

response = MsgBox("The query named qryCurrentTitlesUnmatched behind this message box" _

& "is the Title that could be a title not found in the Performance Evaluations. Do you want to see how this query works, Click Yes", vbYesNoCancel, "Unmatched query")

If response = vbYes Then

Dim ProjPath

ProjPath = "W:\DATA MANAGEMENT SERVICES\Database Mappings and Documents\PeopleSoft Datawarehouse\Html files\Unmatched Titles Process.htm" '& Me.PolicyNo.Value

Shell "C:\Program Files\Internet Explorer\iexplore.exe """ & ProjPath & "", vbNormalFocus

End If

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (3)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___