Re: Convert jpg to bmp

Jim.
Something that worked for me was to:
1) Place the jpg file on the same directory as the appication
2) Insert an image in your form, select the image you want to display and
set all properties like size, borders, etc.
3) Under the Form_Open Sub add a line of code like: MyImageName.Picture =
Application.CurrentProject.Path & "\MyImage.jpg"
4) Go back to the inserted image, right click and select properties
5) On the Format tab, first line, remove whatever it says and answer yes
when asked to confirm (this will remove the jpg from the database). This way
the actual picture is not part of the database and if you have many pictures
it will keep the database smaller.
Any time you open the form it will automatically call the image to display
from the current directory
I use this in an application with multiple forms, where I place a company
logo in all forms
Cesar


"Jim Jackson" wrote:

Please forgive my "Old-Timer's" acting up. I found the thread I had
mentioned and found that my memory was off. I also found references to
"OnCurrent" and "AfterUpdate" which work beautifully. In fact I was able to
run an Excel Macro to list all the jpeg files in the folder, combine the
filenames with path info and paste them right into the text box in the
database so I now have over 5000 entries with a relatively small size
database.

Thanks for your replies and the link you provided. You have been a great
help in getting me on the right path.
--
Best wishes,

Jim


"Stephen Lebans" wrote:

Unless the 3,000 images are quite small and low color depth there is
absolutely no way you will be able to insert them directly into a table via
OLE. Depending on the amount of compression you may be able to insert them
as raw binary data via the Long Binary field data type. The majority of
users simply load the externally stored images at runtime as required via
the Image control's Picture property. There is code posted basically every
single day in the NG's demonstrating how to load a disk based image into the
Image control.

Either search via GoogleGroups or start here and follow the links:
http://www.mvps.org/access/forms/frm0030.htm


--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Pops Jackson" <PopsJackson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E2023152-47D8-46DA-9046-02850585E2DC@xxxxxxxxxxxxxxxx
Stephen,

Thank you for your reply. I will appreciate any advice you have to offer
regarding my task. I thought I had read in previous posts that BMP was
the
way to go with inserting pictures, at least better than JPG. I tried
using
an EMF file in the OLE cell but only to have the filename show, which was
a
gateway to opening the actual file.

Is there a better choice than the OLE?

Thanks again,
--
Pops Jackson


"Stephen Lebans" wrote:

There will be no significant difference in size between the EMF and the
BMP.
As for the conversion process, there are several Free Graphics Converters
on
the Net that can easily convert batches(folders) of images from JPG to
BMP.

But how will you be inserting the BMP's? If you are planning to use OLE
then
you will quickly find that your table will exceed the 1GB limit.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Jim Jackson" <JimJackson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B6B376A6-6BEC-4A9F-B128-449FE067FEFA@xxxxxxxxxxxxxxxx
I have seen Stephen Lebans' conversion tool for converting jpg to emf
but
cannot figure how to take that to converting to bmp in order to
efficiently
place pictures in the Access database I have built. There could be
3,000
or
more pictures when I have finished with it so manually opening and
doing
saveas is out of the question.

Thanks for any help.
--
Best wishes,

Jim






.

Relevant Pages

  • Re: JPEGS stored in a general field displaying .BMP
    ... You can play several tricks with the JPG files. ... On one database I used ... using the general field and got out of that habit. ... where all my JPG pictures are and can use them as needed. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: BLOB fields and Microsoft Access
    ... Try in your code when you are accessing a database which has pictures ... wrapped by OLE to set the startindex to 78 and the length than to -78. ...
    (microsoft.public.dotnet.framework.adonet)
  • Pictures
    ... I have a database with several fields - 2 of them are OLE for adding ... This has worked fine, however, it is now 1.7 Gig. ... I need a fairly straight forward solution that allows me to add 2 Pictures ...
    (microsoft.public.access.forms)
  • Cannot Add Pictures Anymore - WHY ?
    ... I have two fileds in my database for pictures - both are OLE. ...
    (microsoft.public.access.forms)
  • Re: JPG, OLE, Questions on how to best use images in ACCESS
    ... First you can export all of the embedded JPG images to disk. ... Add a standard Image control(NOT an OLE Frame control) ... > want to use a OLE to imbed my JPG's into my database records.... ...
    (microsoft.public.access.forms)