Solved

Error:  The PhotoDraw MIX File import filter couldn't load.  Try reinstalling Microsoft Office...

Posted on 2004-10-25
387 Views
Last Modified: 2008-01-09
Hi guys,

I am using picture placeholders in my forms.. I am using MS Access 2003 on both of my pcs.
On my home pc, my access database works just fine.. no errors.
However, on my work pc., I get the following error when the form is loading.

Error:  The PhotoDraw MIX File import filter couldn't load.  Try reinstalling Microsoft Office...

Now, the pictures load and everything., but I get that error every time.
I am using .jpg's ., I have tried using  .bmp's , I get the same result.
I have searched the internet high and low and I cannot find an exact match on this problem.

My guess is , is that it's a registry key or something like that..

Any ideas ?

Thanks,
Kevin Rea
kevinrea@adelphia.net

0
Question by:kevinsrea
    17 Comments
     
    LVL 9

    Expert Comment

    by:tonydemarco
    Kevin,

    Remove and replace the pics.
    The PhotoDraw MIX File import filter may not be in the same place on both computers.

    HTH

    Tony
    0
     

    Author Comment

    by:kevinsrea
    Hi Tony,

    thanks, but I had already tried that.
    did  not make any difference.
    any other ideas ?

    kevin
    0
     

    Author Comment

    by:kevinsrea
    Also Tony,

    I removed all the pictures, and then when I go to add back in just one picture, it give me the error two times, after clicking on the ok button to clear the errors, the picture loads just fine.

    still trying to figure this one out.

    kevin
    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    Lets try going to the Visual Basic Editor (Alt-F11) and look in the "Tools" and "References" list for any "MISSING" references and unchecking the boxes.

    Tony
    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    Describe the "picture placeholders" that you are using in your forms.

    Are the pictures linked or embedded?

    Tony
    0
     

    Author Comment

    by:kevinsrea
    hi again tony,

    no missing references.

    here is the code for the picture placeholders, and they are linked,not embedded.

    -------------------------------------------------------------------------------------------------------
    Private Sub AddPictureButton_Click()
           
        getfilename
    End Sub

    Sub getfilename()
        Dim fileName As String
        Dim result As Integer
        With Application.FileDialog(msoFileDialogFilePicker)
            .Title = "Select The Bathroom 1 Picture"
            .Filters.Add "All Files", "*.*"
            .Filters.Add "JPEGs", "*.jpg"
            '.Filters.Add "Bitmaps", "*.bmp"
            .FilterIndex = 3
            .AllowMultiSelect = False
            .InitialFileName = CurrentProject.path
            result = .Show
            If (result <> 0) Then
                fileName = Trim(.SelectedItems.Item(1))
                Me![ImagePath].Visible = True
                Me![ImagePath].SetFocus
                Me![ImagePath].Text = fileName
                Me![Photo1].Value = -1
                Form_InspectionMain.SetFocus
                Form_InspectionMain.Address1.SetFocus
                Form_Bathroom1.ImageFrame.Visible = True
                Form_InspectionMain.Address1.SetFocus
                Form_Bathroom1.Location.SetFocus
                Form_Bathroom1.ImagePath.Visible = False
            End If
        End With
    End Sub

    Private Sub Form_AfterUpdate()
        On Error Resume Next
           
            showImageFrame
            If (IsRelative(Me!ImagePath) = True) Then
                Me![ImageFrame].Picture = path & Me![ImagePath]
            Else
                Me![ImageFrame].Picture = Me![ImagePath]
            End If
    End Sub

    Sub hideImageFrame()
        ' Hide the image control
        Me![ImageFrame].Visible = False
    End Sub

    Function IsRelative(fName As String) As Boolean
        ' Return false if the file name contains a drive or UNC path
        IsRelative = (InStr(1, fName, ":") = 0) And (InStr(1, fName, "\\") = 0)
    End Function

    Sub showImageFrame()
        ' Display the image control
        Me![ImageFrame].Visible = True
    End Sub

    -------------------------------------------------------------
    i hope that helps.., and i hope i put all the stuff in.
    kevin
    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    1. Try putting a resume after the button click just to see if this is the problem area. ie.

    Private Sub AddPictureButton_Click()
    On Error Resume Next


    2. Try putting a resume next on the On Load Event of the form. ie.

    Private Sub Form_Load()
    On Error Resume Next
    End Sub

    tony
    0
     

    Author Comment

    by:kevinsrea
    Hi Tony,

    I tried putting inthe  On Error Resume Next..
    it did not help.

    kevin
    ps.. thanks for trying to help me with this tony, i know it is not an easy one.

    kevin rea
    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    1. Try uninstalling PhotoDraw

    2. Try isolating the error by copying the offending form to experiment with.
    Open the copy to make sure that you get the same error.
    Systematically remove one control at a time until the error stops.

    3. Send me the zipped files to tony_demarco@hotmail.com
    0
     

    Author Comment

    by:kevinsrea
    hi tony,

    how do i uninstall photo draw ?

    is it a part of ms office 2003 pro ?

    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    Kevin,

    Microsoft discontinued Microsoft PhotoDraw® on May 31, 2001

    To uninstall PhotoDraw using the Control Panel, follow these steps:
    1. On the Windows Start menu, point to Settings, then click Control Panel.  
    2. In Control Panel, double-click Add/Remove Programs.  
    3. Select Microsoft PhotoDraw 2000 in the list and click Add/Remove.  
    4. In PhotoDraw setup, click Remove All.  
    5. Follow the instructions displayed on the screen.  
    6. When setup is complete, restart Windows

    Tony
    0
     

    Author Comment

    by:kevinsrea
    Hi Tony,

    There is no Microsoft PhotoDraw listed in my listing of installed programs.
    I think it is a part of ms office.

    kevin
    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    You can remove MSOffice programs by either the Add/Remove Programs in control panel
    or you can insert the program disk and unselect the program from the list of programs.

    Tony
    0
     

    Author Comment

    by:kevinsrea
    Hi tony,

    yes, i know all of that, however, when you go into the office 2003 pro setup, and add/remove, and then look at every little thing that it can install or uninstall, the PhotoDraw is not one of the items., so, it must be an imbedded thing or something.


    kevin

    0
     
    LVL 9

    Expert Comment

    by:tonydemarco
    kevin,

    Try going to explore (right click "start" button and "explore".
    Go to "Tools" then "Folder Options" then "File Types" leaf and search for
    any association to a "MIX" file. (type "M" in the window) Then delete this association completely.

    Next look for any PhotoDraw association to JPEG JPG BMP files and change them to another installed graphic software.

    -------------------------------------------
    If no luck try previous suggestion:

    Try isolating the error by copying the offending form to experiment with.
    Open the copy to make sure that you get the same error.
    Systematically remove one control at a time until the error stops.

    Uninstall and Reinstall MS Access, maybe this will unassociate the filter with the program.

    All out of ideas at this point

    Tony
    0
     

    Author Comment

    by:kevinsrea
    thanks for all the ideas tony, . nothing has worked though.
    i even searched the registry for photodraw, there are no entries.

    must be an imbedded part of office 2003 pro.

    kevin
    0
     

    Accepted Solution

    by:
    PAQed with points refunded (500)

    modulo
    Community Support Moderator
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…

    884 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now