<div>
Is there a limit to the length of FollowHyperlink? &nbsp;As I explained, the jpg files would not open but the doc file would. &nbsp;The doc file is called 1.doc. &nbsp;The jpg files are 15-20 characters long. &nbsp;The path where these files are located is &nbsp;about 40 characters long.
</div>


Is there a limit to the length of FollowHyperlink?  As I explained, the jpg files would not open but the doc file would.  The doc file is called 1.doc.  The jpg files are 15-20 characters long.  The path where these files are located is  about 40 characters long.

<div>
I tried to reproduce the problem on another computer but it works fine. &nbsp;The problem computer has Access 2002. &nbsp;The new computer has 2003. &nbsp;
</div>


I tried to reproduce the problem on another computer but it works fine.  The problem computer has Access 2002.  The new computer has 2003.  

<div>
Have you tried the workaround I presented?
</div>


Have you tried the workaround I presented?

<div>
<div class="content wysiwyg-content">
I have a form that has a function GetDirectoryFiles() and populates a listbox. &nbsp;In the listbox, I see each of the files in the directory. &nbsp;It's supposed to work where I can double click on a filename and it will open the file using its associated program.<br />
<br />
Here's the problem. &nbsp;When I double click on any of the jpg files that show up in the listbox, I get a runtime error 490. &nbsp;It's failing at a line of code with followhyperlink. &nbsp;To make things interesting, it does NOT fail with I double click on .doc files. &nbsp;Anything come to mind why that would be? &nbsp;The jpg files are associated with an image viewing program. &nbsp;I actually changed that to use IE but it still fails.<br />
<br />
<br />
<br />

</div>
</div>


I have a form that has a function GetDirectoryFiles() and populates a listbox.  In the listbox, I see each of the files in the directory.  It's supposed to work where I can double click on a filename and it will open the file using its associated program.

Here's the problem.  When I double click on any of the jpg files that show up in the listbox, I get a runtime error 490.  It's failing at a line of code with followhyperlink.  To make things interesting, it does NOT fail with I double click on .doc files.  Anything come to mind why that would be?  The jpg files are associated with an image viewing program.  I actually changed that to use IE but it still fails.





Runtime error 490 and followhyperlink

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.