OLE Object (Bitmap Image) Type?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JohnG (JohnG_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 11:13:04 -0700

Hi

I am having trouble returning a bitmap image from a field stored in my
database. The field's Tpye is a OLE Object and it holds a Bitmap Image, Im
trying to display the image on a Form after it has been retrieved using the
Dlookup funtion I've tried to assign a variable (rtImage)with various object
types with no joy. I keep getting a Tpye mismatch error message when I try to
link the field.

for instance:

Dim rtImage As Long

rtImage = DLookup("Product_Name", "[Main _ products]", "Product_Image =" &
Me.OpenArgs)

can Anyone help?

Thanks John

Relevant Pages

  • Re: Displaying Long Binary Data in a Report
    ... PrintFailure.zip is an Access97 MDB containing a report that fails during ... which populates ClassHistory - the StudentSign field is ... the field will display "Bitmap Image" rather than "Long Binary Data". ... that my app has loaded into the OLE Object field? ...
    (microsoft.public.access.reports)
  • Re: Sql statement for OLE objects
    ... Let me take a step back, I was looking to send the ole object (a bitmap image ... of a signature) as an embedded ole object in the database in order to have ...
    (microsoft.public.vb.database.ado)
  • Re: OLE Object (Bitmap Image) Type?
    ... You have to use an OLE Frame control to display an OLE object. ... > I am having trouble returning a bitmap image from a field stored in my ... I keep getting a Tpye mismatch error message when I ...
    (microsoft.public.access.formscoding)