from file to ole object

Kirk

I have the location of a jpeg in a access database (imported from a
sql database). I need to know how to turn this file location into a
ole object. the file is pictures of employees so there is over 1300
records.
IF anyone has any suggestion I would be very thankful
thanks
Kirk

Nov 12 '05 #1

Subscribe Post Reply

6176

xzzy

if the paths to the pictures are in a file, then

Me.ctlIImage.picture = MySet!PATH

John Bickmore
www.BicycleCam.com
www.Feed-Zone.com

"Kirk" <Ki*********@NAV-INTERNATIONAL.com> wrote in message
news:ee**************************@posting.google.c om...

I have the location of a jpeg in a access database (imported from a
sql database). I need to know how to turn this file location into a
ole object. the file is pictures of employees so there is over 1300
records.
IF anyone has any suggestion I would be very thankful
thanks
Kirk

Nov 12 '05 #2

Larry Linson

The sample databases at http://accdevel.tripod.com have examples of three
approaches to handling images in Access. You may, after reading the article
included in the download, want to consider other options besides OLE
Objects. It is certainly not the only way to display, and often is not the
best way, either. There is VBA code showing acquiring an image file to
create an OLE Object, BTW, if that is the approach you really want to use.

Larry Linson
Microsoft Access MVP

"Kirk" <Ki*********@NAV-INTERNATIONAL.com> wrote in message
news:ee**************************@posting.google.c om...

I have the location of a jpeg in a access database (imported from a
sql database). I need to know how to turn this file location into a
ole object. the file is pictures of employees so there is over 1300
records.
IF anyone has any suggestion I would be very thankful
thanks
Kirk

Nov 12 '05 #3

by: simon place | last post by:

is the code below meant to produce rubbish?, i had expected an exception. f=file('readme.txt','w') f.write(' ') f.read() ( PythonWin 2.3 (#46, Jul 29 2003, 18:54:32) on win32. ) I got...

Python

file object as container class

by: Matthew Wilson | last post by:

I have a bunch of classes that track data for time series. The classes are really just glorified dicts where the key is a date object, and the value is the value as of that date. I want a way...

Python

Difference between readlines() and iterating on a file object?

by: Richard | last post by:

Hi, Can anyone tell me what the difference is between for line in file.readlines( ): and for line in file:

Python

deepcopy and file object attributes

by: Dan Perl | last post by:

Here is some code to illustrate a problem that I have: import copy class myc: def __init__(self): self.myf=file('bar.txt',"w") def foo(self): self.myf.write('hello world!') # it's going...

Python

Questions about file object and close()

by: John Marshall | last post by:

Hi, Does anyone see a problem with doing: data = file("tata").read() Each time this is done, I see a new file descriptor allocated (Linux) but not released. 1) Will there ever be a point...

Python

Problem deriving a class from the built-in file object

by: Pierre Rouleau | last post by:

Hi all! I'm trying to extend the functionality of the file object by creating a class that derives from file. MyFile class re-implements __init__(), write(), writelines() and close() to augment...

Python

reading a python file object in c extension crashes python

by: travis ray | last post by:

Hi, I have an extension in which a file object is created in python and passed down to a c extension which attempts to read from it or write to it. Writing to the file pointer seems to work...

Python

How to get underlying Xslt content from XslTransform object

by: shell shell via .NET 247 | last post by:

How do you get the underlying Xslt stylesheet content from an XslTransform object that has been created and loaded with a stylesheet file or some text? Assume a method will create an XslTransform...

.NET Framework

Check if variable is an instance of a File object

by: sc_wizard29 | last post by:

Hi everyone, Maybe these questions will sound strange to you, but I sometime have a hard time switching from Java to Python ;-) Let's say I have a function like this : def show_lines(file):...

Python

inherit from file and create stdout instance?

by: MisterPete | last post by:

How can I inherit from file but stil create an instance that writes to stdout? ----------- I'm writing a file-like object that has verbosity options (among some other things). I know I could just...

Python

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Similar topics