Cannot assign value to OLE Unbound Frame in Form_Current Event

[pctron]

Hi There,

I am using Access 2003 on Windows XP. I cannot execute this code in any of the form's Open, Load, Activate, Current event.

It gives me the folowing error: The setting you entered isn't valid for this property.

The form does contain a subform, but removing it makes no difference.

 
     If IsNull(Me![SketchImage]) Then
        If cmdLoadSketch.Enabled = False Then cmdLoadSketch.Enabled = True
        cmdLoadSketch.Visible = True
        oleSketch.SourceDoc = sPicPath & "\Placeholder.bmp" ' Ignored
    Else
        On Error GoTo Found_Err
        With oleSketch
            .Enabled = True
            .Locked = False
            sPicPath = Me![SketchImage].Value ' This is /<path>/Picture.bmp
            .OLETypeAllowed = acOLELinked
            .Class = "Paint.Picture"
            .SourceDoc = sPicPath   ' This line gives error
           .Action = acOLECreateLink
        End With
    End If

Me![SketchImage] is a text field in a linked table.

Can anyone please help. We need to be able to store the path to object in the database and then change the contents of the of the form and/or report dynamically at runtime.

[Rabbit]

You said the error is 'The setting you entered isn't valid for this property'

But which setting is it talking about? Which property is it talking about?

[pctron]

You said the error is 'The setting you entered isn't valid for this property'

But which setting is it talking about? Which property is it talking about?

Hi Thanks for reply.

See line 13 in the code snippet above

The property is the SourceDoc property on this line in the code snippet
.SourceDoc = sPicPath ' This line gives error

I am trying to move the code to another location to see if that works.

[Rabbit]

What's oleSketch?

The error message means that there's no property called SourceDoc for that object. This could mean that there really is no property called SourceDoc or that you're missing a reference.

[pctron]

What's oleSketch?

The error message means that there's no property called SourceDoc for that object. This could mean that there really is no property called SourceDoc or that you're missing a reference.

Thanks Rabbit for replying.

I cannot assign a properly formed filepath value to the OLE Unbound Frame (oleSketch ) in the form's Form_Current Event. I use the same code in a command button to load or reload the original picture and then it works. The problem is not that the code does not work. The problem is that it does not work where I want it to work (i.e. automatically).

I just would like to state that I have many years of programming experience including MS Access, so its unlikely I would make silly mistakes.

Thanks

[pctron]

What's oleSketch?

The error message means that there's no property called SourceDoc for that object. This could mean that there really is no property called SourceDoc or that you're missing a reference.

Thanks Rabbit for replying.

I cannot assign a properly formed filepath value to the OLE Unbound Frame (oleSketch ) in the form's Form_Current Event. I use the same code in a command button to load or reload the original picture and then it works. The problem is not that the code does not work. The problem is that it does not work where I want it to work (i.e. automatically).

The problem is that the path of the file as stored in the database was wrong. I did not check for the existence of the file. I confess, I am capable of making silly mistakes.

Thanks

[Rabbit]

No worries, I don't think there's anyone that never makes a silly mistake.

[NeoPa]

...
I just would like to state that I have many years of programming experience including MS Access, so its unlikely I would make silly mistakes.

Thanks

I saw this and immediately thought "but I'm quite experienced too and I make silly mistakes from time to time".
It appears you learned quite quickly from yours ;)
This is not meant unkindly. It's hard to express how much of the subject you understand (to the person trying to help).