How to add an image to a field in a table

[neelsfer]

I would like to lookup an image from my pc and add it to a specific field in a form.
form name: AddSignaturesF
table: tblImageOLEs
field:signature 1 (OLE object field)
I found this code from "Adezi" from an old post and needs to make more changes to it.
It finds the image, but does not add it to the "signature1 " field

Dim varItem As Variant

With Application.FileDialog(msoFileDialogFilePicker)
   With .Filters
     .clear
   .add "Bitmap Files", "*.bmp"
     .add "JPEG Files", "*.jpg"
     .add "Graphic Interchange Format Files", "*.gif"
   End With
              .AllowMultiSelect = False
       .FilterIndex = 1
       .ButtonName = "Select Graphic"
       .InitialFileName = vbNullString
       .InitialView = msoFileDialogViewDetails
       .Title = "Load Graphic File!"
          If .Show Then
         Me.Signature1 = .SelectedItems(1)
          End If
End With

Any suggestions please. I am pleading stupid here

[ADezii]

It is a little mor4e complicated that that. Assuming that Signature1 is a 'Bound Object Frame' whose Control Source is an OLE Object Field in a Table, then:

Dim varItem As Variant

With Application.FileDialog(msoFileDialogFilePicker)
  With .Filters
    .Clear
      .Add "Bitmap Files", "*.bmp"
      .Add "JPEG Files", "*.jpg"
      .Add "Graphic Interchange Format Files", "*.gif"
  End With
    .AllowMultiSelect = False
    .FilterIndex = 1
    .ButtonName = "Select Graphic"
    .InitialFileName = vbNullString
    .InitialView = msoFileDialogViewDetails
    .Title = "Load Graphic File!"
       If .Show Then
         With Me.Signature2
           .OLETypeAllowed = acOLEEmbedded
           .SourceDoc = Application.FileDialog(msoFileDialogFilePicker).SelectedItems(1)
           .Action = acOLECreateEmbed
         End With
       End If
End With

[neelsfer]

thx Adezi for the effort. Its almost 100%.
The code copies the image into the signature1 field as required, but it is shown as an icon together with the file name. Is there perhaps a setting to be changed on the pc, to display the pic "live" as you open the form?
my purpose - In this instance the person capturing the order, compares the signature of the authorized person on the system, to the person that signed the order off.

[zmbd]

Your last post there reminded me about another old thread that covers part of this: Display dynamic image in MS Access 2007
If you are using V2007 or V2010 then you should be ready to rock-n-roll. I've been using this for the past few months and it is sooooooo much easier than what I had to do in V2003.

[ADezii]

Set the DisplayType Property of the Unbound Object Frame to 'Content'.