Re: Access newbie picture question

From: Stephen Lebans (ForEmailGotoMy.WebSite.-WWWdotlebansdotcom_at_linvalid.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 17:39:50 -0400

While the DBPix control is an excellent reccomendation your statement
that it supports forms in Continuous view is incorrect. Yes I have seen
the example on the DBPix control Web site but it is not a form in
Continuous view.

Another solution to allow for the storage of the original Image directly
within a table without the OLE object overhead is here:
http://www.lebans.com/loadsavejpeg.htm
LoadSaveJpeg.zip contains a database demonstrating how to use the Intel
Jpeg library with Access. Jpeg files are stored in their original
compressed state within a Binary OLE avoiding the Ole object "bloat"
issue. 

--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Pete Davis" <pdavis68@hotmail.com> wrote in message
news:28152ea947a0939165715017cedfdefe@news.meganetnews.com...
> Jamie,
>
>    Thanks for the information. Another newbie question, what's a
"continuous
> form"?
>
>    I have three forms. It's for a real estate company. They have a
Rental
> Form and a For Sale form. Both of these forms use a Property Details
form as
> a sub form for the data they share in common. The pictures would go on
the
> Property Details form.
>
> Pete
>
> --
> http://www.petedavis.net
> "Jamie" <filminformation@NOSPAMblueyonder.co.uk> wrote in message
> news:u4qqmEy9DHA.568@TK2MSFTNGP09.phx.gbl...
> > There's an article and example download here:
> > http://jamiessoftware.tk/articles.html
> > See an example of the code for the FileOpen dialog in the getBinary
> > download.
> >
> > Storing the images as BLOBs will work fine but images can only be
> displayed
> > on single view forms not continuous. See also
> > http://www.mvps.org/access/bugs/bugs0044.htm for info on the GPF
fault bug
> > encountered when moving to the next image too quickly.
> >
> > If you want to use continuous forms/reports to display images then
> consider
> > the DBPix control (starts at $99 and is easier for a novice to use):
> > http://www.ammara.com/
> >
> > Jamie
> > www.jamiessoftware.tk
> >
> >
> > "Pete Davis" <pdavis68@hotmail.com> wrote in message
> > news:2c36f0a2de4303c8d27b2a8f726af701@news.meganetnews.com...
> > > I have to store some pictures in the database. Storing them in the
> > > filesystem is unacceptable for various reasons.
> > >
> > > I have done very little access programming, but I'm trying to help
a
> > client
> > > get this set up.
> > >
> > > What I need s a simple way to add a new image to the database. I
have a
> > > field for placing the filename and then a button that I want them
to
> press
> > > to import the data, and that's where I'm stuck. How, in access, do
I
> read
> > in
> > > the file and place the data into the appropriate field?
> > >
> > > My table is called Picture and has the following:
> > >
> > > PictureID: Autonumber
> > > PropertyDetailsID: Number   (reference to the record the picture
is
> > > associated with)
> > > PictureNumber: Number   (used to number the pictures associated
with the
> > > property, beginning at 1.
> > > PictureData : OleObject   (The actual picture data).
> > >
> > > So, after pressing the button, how do I move the data from the
file to
> the
> > > database?
> > >
> > > The second question is, is there a way to display the FileOpen
dialog
> from
> > > within access instead of requiring the user to type in the
filename?
> > >
> > > Thanks.
> > >
> > > Pete
> > >
> > > --
> > > http://www.petedavis.net
> > >
> > >
> >
> >
>
>