OLE Object's Images

Gimp

New member
Local time
Today, 00:05
Joined
Apr 12, 2003
Messages
9
Hi
For some reason I am unable to open a JPG images into the OLE object
I did everything as described here
Tried loading the jpg without the dialog and it wont show. I have Access XP.
TIA.
 
Try this

Hello Gimp,

I had never tried the ActiveX Dialog, since Office has its own
if you use the following code, you must set a reference to the Office Library.
Copy this code behind a button, or in the OnEnter event of your Ole field, or where ever you need.

Code:
Dim dlgBox As FileDialog
    
    
        Set dlgBox = Application.FileDialog(msoFileDialogOpen)
        With dlgBox
            .AllowMultiSelect = no
            .Show
        End With
       
    Me.MyOlefield = dlgBox.SelectedItems(1)

Good Luck

Estuardo
 
I get an undefined type for the FileDialog

nm got it to work

however it wont load anything
 
Last edited:
Are you using Office or stand alone Access?

If it is stand alone Access you will need to install the 'jpeg Interchange format' filter.
 
ive installed pretty much everything but ill try that
 

Users who are viewing this thread

Back
Top Bottom