input a picture to a table in a form

  • Thread starter Thread starter dcstall
  • Start date Start date
D

dcstall

Guest
I have a data imput form, how do i input the address of a picture to go along with that record, for display later in a report. I can manaully go into the table and to it but i want to do it from the form.
 
Use Bound Object Frame and bound it to the OLE field.
Try these codes to update the picture:

Sub UpdatePict()

With OLE1
.Class = "MSPhotoEd.3"
.OLETypeAllowed = acOLEEmbedded ' Specify type of object.
.SourceDoc = "C:\WINDOWS\0232.jpg"
.Action = acOLECreateEmbed ' Create linked object.

End With


End Sub

Thx
Rilles E.P.
 

Users who are viewing this thread

Back
Top Bottom