Error Message in Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Montana Rain - 18 May 2008 15:06 GMT

Let me start off by saying I do not know anythig about code. I
received help on this site to connect a jpg file to my data base by
using MyPic MyPath code. It was working fine even after I added Access
2007. This morining I deleted my XP Office softare so that the 2007
Office package would the only one on my system. That is when my
problem started. When I double click on "MyPic" now I get the
following message:

Runtime error '4866.
No program is registered to open this file

When I hit the debug button (as if I would know what to do) the code
pops up and the line "Application.FollowHyperlink Me.MyPath &
Me.MyPic, , , , , msoMethodGet" is highlighed in yellow.

Private Sub MyPic_DblClick(Cancel As Integer)
Application.FollowHyperlink Me.MyPath & Me.MyPic, , , , , msoMethodGet
End Sub

What can I do to salvage my code?

Thanks in advance

Reply to this Message

Douglas J. Steele - 18 May 2008 16:24 GMT

I'm guessing that you deleted Picture Manager when you deleted Office 2003,
so you now don't have any application linked to the specific file type.

What happens if outside of Access you navigate to the file and double-click
on it? Assuming I'm correct, set up a file association, and you should be
fine.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Let me start off by saying I do not know anythig about code. I
> received help on this site to connect a jpg file to my data base by
[quoted text clipped - 18 lines]
>
> Thanks in advance

Reply to this Message

Montana Rain - 18 May 2008 16:43 GMT

On May 18, 10:24 am, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> I'm guessing that you deleted Picture Manager when you deleted Office 2003,
> so you now don't have any application linked to the specific file type.
[quoted text clipped - 31 lines]
>
> - Show quoted text -

I went to the folder where I keep all of my jpg files and the image on
the individual jpg files had change. When I double clicked on one of
them it opened. When I closed it, All of the images had changed back
to the typica jpg icon. When I went back to my Access program, the
double click function with the code worked again. I do not really
understand why, but thank you very much for your input.

Reply to this Message