Run time error 490

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Run time error 490

Post by matthewR »

I have an older database that has a switchboard. One of the buttons takes you to open a file but I am getting a run-time error 490 - cannot open specified file. The second line below is highlighted in yellow. I am using Access 2010. How do I see where the path is?

Public Function OpenOtherDatabase(strName As String)
Application.FollowHyperlink strName
End Function

User avatar
HansV
Administrator
Posts: 78383
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Run time error 490

Post by HansV »

While the code is paused, hover the mouse pointer over the word strName.
Best wishes,
Hans

matthewR
5StarLounger
Posts: 627
Joined: 03 Feb 2010, 15:02

Re: Run time error 490

Post by matthewR »

Thank you. The file had been removed so it couldn't find it.

User avatar
HansV
Administrator
Posts: 78383
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Run time error 490

Post by HansV »

Thanks for the feedback; glad the problem has been solved.
Best wishes,
Hans