D dcstall Guest May 8, 2001 #1 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.
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.
R Rilles Guest May 11, 2001 #2 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.
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.
E ElsVanMiert Registered User. Local time Today, 08:58 Joined Dec 14, 2000 Messages 152 May 14, 2001 #3 Have a look at the Graphic wizard (ACCESS Powerup) at www.unsoftwareag.com.
