Link to home
Start Free TrialLog in
Avatar of Barsham
BarshamFlag for Australia

asked on

save an OLE 'Microsoft Photo Editor' Photo into file

Hi! I Have a DB in ACCESS and photo filed are PHOTO Editor OLE Object but I Use Office 2003 & i have not "Photo Editor OLe" in office 2003 but In my Forms Pictures are Displayed
how can i write some code to Save This Field's Image into file ?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Barsham,

You were not very clear in your post.

I have lots of questions:

<photo filed are PHOTO Editor OLE Object >
A FIELD Data Type in Access can be "OLE Object". I have never heard of a Field Data Type of: "PHOTO Editor OLE Object"?
Could you please explain what this is?

<i have not "Photo Editor OLe" in office 2003 >
Do you mean that you do not have the Photo Editor *PROGRAM* installed in Office 2003?

<but In my Forms Pictures are Displayed>
If your Pictures display properly, then what is the problem?

<Save This Field's Image into file >
What do you mean by this?

Jeffrey Coachman

Avatar of Barsham

ASKER

my dear friend
<photo filed are PHOTO Editor OLE Object >
My Field Type is "OLE Object" when i Tell "PHOTO Editor OLE Object " what do u think field type is maybe "MEMO" ha ?

<i have not "Photo Editor OLe" in office 2003 >
i told that DATABASE have fields that have "PHOTO Editor" object in content
db made& filled in office 2000 & i must save Pictures (picture is the name not type) of this db on local drive


<but In my Forms Pictures are Displayed>
PHOTO editor not installed but theses images are displaying in OFFICE - ACCESS 2003 Forms

<Save This Field's Image into file >
what do u mean of what is this complex "Save Fields DATA to File on local drive" ?!

thank u any way
Barsham,

I'm confused... If you already have the images displaying on your forms and stored in your database as OLE objects then they are already "Saved to a file"

If they are not already files, then how did they get into your database?

What is your ultimate goal here?

Jeffrey Coachman
Avatar of Barsham

ASKER

my friend
 I Have over 3500 Images in 1 file(my database.mdb)
my goal is have 3500 files on local hard disk like image01.jpg,image02.jpg & ..... for sample on Drive C:
my images displayed on MS-ACCESS Forms not anywhere else like VB6.0 or VB.NET
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Barsham

ASKER

thank u my friend that's all i needed