Hi all,
I'm trying to figure out a way of recording a sound file as a linked OLE object. I have no trouble doing this as an embedded object, but since the file type is .wav, the DB starts to bloat quickly as you can imagine.
In theory, this code should work (Me.soundfile is the bound object frame on my form):
"Run-time error '2101': The setting you entered isn't valid for this property." and it debugs to the .SourceDoc line.
If anyone can help out with this, I'll do time in purgatory for you!
Thanks,
James
I'm trying to figure out a way of recording a sound file as a linked OLE object. I have no trouble doing this as an embedded object, but since the file type is .wav, the DB starts to bloat quickly as you can imagine.
In theory, this code should work (Me.soundfile is the bound object frame on my form):
Dim strpath As String
strpath = "C:\Documents and Settings\celtnots\Desktop\a.wav"
With Me.Soundfile
.Class = "soundrec"
.OLETypeAllowed = acOLELinked
.SourceDoc = strpath
.Action = acOLECreateLink
.Verb = acOLEVerbPrimary
.Action = acOLEActivate
End With
But of course, it doesn't: I getstrpath = "C:\Documents and Settings\celtnots\Desktop\a.wav"
With Me.Soundfile
.Class = "soundrec"
.OLETypeAllowed = acOLELinked
.SourceDoc = strpath
.Action = acOLECreateLink
.Verb = acOLEVerbPrimary
.Action = acOLEActivate
End With
"Run-time error '2101': The setting you entered isn't valid for this property." and it debugs to the .SourceDoc line.
If anyone can help out with this, I'll do time in purgatory for you!
Thanks,
James