Re: Microsoft Access has bad image import, and no image transparen

From: Larry Linson (bouncer_at_localhost.not)
Date: 11/30/04


Date: Mon, 29 Nov 2004 19:52:24 -0600


"Dave" wrote

> OLE Objects cannot have transparent
> areas, at all.

OLE Objects simply wrap various types of files and store them. They do not
modify the internals of the wrapped files. OLE Frames employ the registered
software to display the file from the OLE Object. It is possible, of course,
that the combination of OLE Frames and the software registered for the file
type does not support transparency.

> I imagine that you are not making very
> fancy reports.

You are correct -- my clients don't pay for "fancy", and they don't pay for
"glitz and glitter". They pay for solutions to their rather normal, modest
business issues.

> Want to put a transparent PNG in front
> of some report data? Sorry, you can't.

No, I have never had a need to use a PNG, much less a transparent one.

> I'm not using Access for "image
> processing". I'm using it to generate
> creative mail pieces and statements
> which require subreports.

It certainly reads to me that "image processing" is exactly what you want to
do. Perhaps a database is not the appropriate tool for creative mail
pieces -- or perhaps someone here could direct you to where on the Microsoft
site they maintain a "wish list" into which you could place a request for
some specific enhancements to image handling in reports.

Nothing you have described prevents using subreports.

> > What is your definition of a "Lock
> > Object feature"? I'm not certain what you
> > want.
>
> Off-topic, but I would like to be able to
> lock items from accidental movement. My
> reports are complex (mail merge letters,
> statements, etc.).

I don't think that is off-topic at all. You can prevent users from modifying
the design:

  You can create an MDE, which locks down the
  design view of any object that can have an
  associated module -- including reports and
  forms.

  You can apply Access security and not give
   users permission for design view, if you have
   a compelling need to maintin the MDB
   form. You can even use this to block yourself
   from modifying the design of a particular
   report. But it is not as easy as a single-click to
   lock the object would be.

> I wonder if Word will handle transparent images...
> but I know it won't handle subreports.

Because Word is not a database program, I don't even see how subreports
apply. Word doesn't "handle reports", either; it handles documents. In
regard to Word handling transparent areas in images, that would be a good
question to ask in one of the microsoft.public.word... newsgroups.

> > P.S. This isn't a good place to get an
> > answer to "why does" or "why
> > doesn't"... the Access product managers
> > and planners are not often in these
> > newsgroups, and may not be at liberty
> > to discuss the reasoning behind design
> > decisions, in any case.
>
> Of course not; that would be productive.

Well, it is a good thing we are at liberty to politely disagree, because I
certainly disagree. In a previous incarnation as a mainframer and
microcomputer developer, I have been involved in the architecture and design
of software. There are many, many factors in a particular architecture or
design decision, and, in my experience, the decision was recorded but not
the debate leading to it.

It would have been extremely counterproductive to put us in a position of
trying to explain and defend every design decision to anyone who chose to
second-guess, as would be the case if the Access design team responded to
"why" questions in newsgroups.

One major factor is the intended user audience; and, I suspect, developers
of creative mail pieces are a rather small part of the expected user
audience for what was, after all, thought to be just a nice little desktop
database (and surprised everyone, including its developers, with the breadth
of functionality that it actually had).

  Larry Linson
  Microsoft Access MVP



Relevant Pages

  • Re: Access 2003 running very slowly in Report design view, help!
    ... My problem is trying to move, copy, format etc in Reports design view. ... "david epsom dot com dot au" wrote: ... Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: FE Running Slow with BE on Network
    ... There are no action queries to run. ... they want additional reports. ... I just copied a 91 MB file to the server and with a rough "head" count, ... Or if I take the MDB file off site to design at ...
    (microsoft.public.access.tablesdbdesign)
  • Re: RoomCap Antenna
    ... How about a design that is small in size, loads the feedline, lights up ... 20:17 G4KHM, 57, John, nr. ... 21:11 SP8TDV, 57, Adam, Lublin, Poland ... The reports are pretty lackluster I'd say... ...
    (rec.radio.amateur.antenna)
  • Re: Problems with Making Hidden Fields Visible Based on Values of othe
    ... > make forms, and reports, and quiries and stuff, but I have never done coding ... In Design view, right click on the combo box. ...
    (microsoft.public.access.forms)
  • Re: read-write mutex
    ... reading from a variable while another thread is or might be modifying ... The program crashes. ... That sounds like a bad design. ...
    (comp.programming.threads)