I have inherited an Access 2000 database that has a text box where you click on a file path that is already entered there and it is suppose to bring up a Word or Adobe file.
Sometimes the file will open and other times Adobe will open and the document will flash on the screen and then Adobe closes. If the document will not open then I get a Runtime Error '490'. I have verified that the files exist and that the users have permissions to the files.
I'm not all that familiar with VB, so can someone tell me if the code below is causing the problem? If so, what can I do to fix it.
Private Sub form_location_Click() 'follow Hyperlink to form location If Me.form_location = "" _ Or IsNull(Me.form_location) _ Then Else Application.FollowHyperlink Me.form_location End If End Sub