If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
.jpg pictures are allowed to store as OLE objects?
Can we stick limited formats of pictures on the field attributed as ""OLE"
in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
#2
|
|||
|
|||
It's not always the case that JPG files appear as icons -- it depends on
your individual setup. There's more informatioin on this in Microsoft's KB article Q258644. "ylmxw" wrote: Can we stick limited formats of pictures on the field attributed as ""OLE" in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
#3
|
|||
|
|||
The format of the image file is completely independant of Access. It is
the responsibility of whatever Image/Paint program is currently registered with WIndows to view the Image file types and act as the OLE server for the object inserted into the OLE object field. MS Photo Editor is generally used as the OLE server for Access. It must be setup and registered to handle the selected image file types. Before I explain how to setup Photo Editor to be registeredd for the relevant Image file types one note of caution. Images embedded as OLE objects will quickly fill up your MDB. A small 40KB JPG can end up consuming several MB's in storage space. If you are planning on storing a large number of images or even a few extremely high resolution images then you should not be using OLE. Why do Images embedded as OLE objects take up so much storage space? In a nutshell: An Image inserted as an OLE object is no longer the same size as the original file. It is converted to a DIB(uncompressed Bitmap) and then wrapped in a EMF(Enhanced Metafile). THe EMF is then wrapped within the OLE stream. Further, if the original Image was not a Bitmap or Metafile, then another full size DIB preview is inserted into the OLE stream. THe only reasons to use an OLE object field are if you requi 1) The ability for your users to Edit the Image in the Program that acts as the OLE server. 2) The ability to view the Images with a Form in Continuous View. 3) The Images are embedded for security concerns. In reality, the enormous OLE file size "bloating" stops most users from inserting more than a few images. With the exception of viewing the images with a Form in Continuous view, coding solutions for the other 2 issues are available. The most common solution is to simply keep the images in a seperate folder storing the filenames only in a Text field. Using the Current event of the Form or the Format event of the relevant section on a Report, place a line of code to load the picture into the standard Image control NOT the OLE Frame control. Me.NameOfPictureControl.Picture = Me.NameOfTextBoxBoundToFileNameField There is lots of sample code out there complete with error checking. Search GoogleGroups. ********************************************* Here is a previous post of mine on for how to setup MS Photo Editor: Message 4 in thread From: Stephen Lebans ) Subject: Inserting picture into an access form View this article only Newsgroups: microsoft.public.access.activexcontrol Date: 2004-11-12 19:43:08 PST In this case the OLE server is simply an Image/paint program that: 1) Can function as an OLE Image server 2) Is registered to handle the specific Image file types you want to insert into the OLE obect field. In most cases, MS Photo Editor is used as the OLE Server program. It must though, be setup as the default/registered handler for the image file types in question. MS Photo Editor is no longer included with Office 2003. YOu will have to find you Office XP or WIn2K disks and install MS Photo Editor only! The simplest method to associate a program with a specific file extension(BMP,JPG,etc.) is to: 1) Open a folder containing the Images you want to insert. 2) Right click on a file while holding down the SHift key. 3) From the popup menu select "Open With". 4) Scroll down the Open With Dialog window until you find MS Photo Editor and select it. 5) Check the Always use this program to open this file type CheckBox control. 6) Click OK. Repeat the steps once for each different type of Image file you want to embedd in your table. ********************************************* -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "ylmxw" wrote in message ... Can we stick limited formats of pictures on the field attributed as ""OLE" in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
#4
|
|||
|
|||
Will the database grow dramastically even if I just store the path to the
pictures in a table and then use the unbound object control to show the pictures in a continuous form? If so, are there any better ways to show pictures in a continuous form? Regards, Patrik "Stephen Lebans" skrev: The format of the image file is completely independant of Access. It is the responsibility of whatever Image/Paint program is currently registered with WIndows to view the Image file types and act as the OLE server for the object inserted into the OLE object field. MS Photo Editor is generally used as the OLE server for Access. It must be setup and registered to handle the selected image file types. Before I explain how to setup Photo Editor to be registeredd for the relevant Image file types one note of caution. Images embedded as OLE objects will quickly fill up your MDB. A small 40KB JPG can end up consuming several MB's in storage space. If you are planning on storing a large number of images or even a few extremely high resolution images then you should not be using OLE. Why do Images embedded as OLE objects take up so much storage space? In a nutshell: An Image inserted as an OLE object is no longer the same size as the original file. It is converted to a DIB(uncompressed Bitmap) and then wrapped in a EMF(Enhanced Metafile). THe EMF is then wrapped within the OLE stream. Further, if the original Image was not a Bitmap or Metafile, then another full size DIB preview is inserted into the OLE stream. THe only reasons to use an OLE object field are if you requi 1) The ability for your users to Edit the Image in the Program that acts as the OLE server. 2) The ability to view the Images with a Form in Continuous View. 3) The Images are embedded for security concerns. In reality, the enormous OLE file size "bloating" stops most users from inserting more than a few images. With the exception of viewing the images with a Form in Continuous view, coding solutions for the other 2 issues are available. The most common solution is to simply keep the images in a seperate folder storing the filenames only in a Text field. Using the Current event of the Form or the Format event of the relevant section on a Report, place a line of code to load the picture into the standard Image control NOT the OLE Frame control. Me.NameOfPictureControl.Picture = Me.NameOfTextBoxBoundToFileNameField There is lots of sample code out there complete with error checking. Search GoogleGroups. ********************************************* Here is a previous post of mine on for how to setup MS Photo Editor: Message 4 in thread From: Stephen Lebans ) Subject: Inserting picture into an access form View this article only Newsgroups: microsoft.public.access.activexcontrol Date: 2004-11-12 19:43:08 PST In this case the OLE server is simply an Image/paint program that: 1) Can function as an OLE Image server 2) Is registered to handle the specific Image file types you want to insert into the OLE obect field. In most cases, MS Photo Editor is used as the OLE Server program. It must though, be setup as the default/registered handler for the image file types in question. MS Photo Editor is no longer included with Office 2003. YOu will have to find you Office XP or WIn2K disks and install MS Photo Editor only! The simplest method to associate a program with a specific file extension(BMP,JPG,etc.) is to: 1) Open a folder containing the Images you want to insert. 2) Right click on a file while holding down the SHift key. 3) From the popup menu select "Open With". 4) Scroll down the Open With Dialog window until you find MS Photo Editor and select it. 5) Check the Always use this program to open this file type CheckBox control. 6) Click OK. Repeat the steps once for each different type of Image file you want to embedd in your table. ********************************************* -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "ylmxw" wrote in message ... Can we stick limited formats of pictures on the field attributed as ""OLE" in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
#5
|
|||
|
|||
The only method to display Images for a form in Continuous view is to
use an OLE Frame control bound to an OLE field. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "Patrik" wrote in message ... Will the database grow dramastically even if I just store the path to the pictures in a table and then use the unbound object control to show the pictures in a continuous form? If so, are there any better ways to show pictures in a continuous form? Regards, Patrik "Stephen Lebans" skrev: The format of the image file is completely independant of Access. It is the responsibility of whatever Image/Paint program is currently registered with WIndows to view the Image file types and act as the OLE server for the object inserted into the OLE object field. MS Photo Editor is generally used as the OLE server for Access. It must be setup and registered to handle the selected image file types. Before I explain how to setup Photo Editor to be registeredd for the relevant Image file types one note of caution. Images embedded as OLE objects will quickly fill up your MDB. A small 40KB JPG can end up consuming several MB's in storage space. If you are planning on storing a large number of images or even a few extremely high resolution images then you should not be using OLE. Why do Images embedded as OLE objects take up so much storage space? In a nutshell: An Image inserted as an OLE object is no longer the same size as the original file. It is converted to a DIB(uncompressed Bitmap) and then wrapped in a EMF(Enhanced Metafile). THe EMF is then wrapped within the OLE stream. Further, if the original Image was not a Bitmap or Metafile, then another full size DIB preview is inserted into the OLE stream. THe only reasons to use an OLE object field are if you requi 1) The ability for your users to Edit the Image in the Program that acts as the OLE server. 2) The ability to view the Images with a Form in Continuous View. 3) The Images are embedded for security concerns. In reality, the enormous OLE file size "bloating" stops most users from inserting more than a few images. With the exception of viewing the images with a Form in Continuous view, coding solutions for the other 2 issues are available. The most common solution is to simply keep the images in a seperate folder storing the filenames only in a Text field. Using the Current event of the Form or the Format event of the relevant section on a Report, place a line of code to load the picture into the standard Image control NOT the OLE Frame control. Me.NameOfPictureControl.Picture = Me.NameOfTextBoxBoundToFileNameField There is lots of sample code out there complete with error checking. Search GoogleGroups. ********************************************* Here is a previous post of mine on for how to setup MS Photo Editor: Message 4 in thread From: Stephen Lebans ) Subject: Inserting picture into an access form View this article only Newsgroups: microsoft.public.access.activexcontrol Date: 2004-11-12 19:43:08 PST In this case the OLE server is simply an Image/paint program that: 1) Can function as an OLE Image server 2) Is registered to handle the specific Image file types you want to insert into the OLE obect field. In most cases, MS Photo Editor is used as the OLE Server program. It must though, be setup as the default/registered handler for the image file types in question. MS Photo Editor is no longer included with Office 2003. YOu will have to find you Office XP or WIn2K disks and install MS Photo Editor only! The simplest method to associate a program with a specific file extension(BMP,JPG,etc.) is to: 1) Open a folder containing the Images you want to insert. 2) Right click on a file while holding down the SHift key. 3) From the popup menu select "Open With". 4) Scroll down the Open With Dialog window until you find MS Photo Editor and select it. 5) Check the Always use this program to open this file type CheckBox control. 6) Click OK. Repeat the steps once for each different type of Image file you want to embedd in your table. ********************************************* -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "ylmxw" wrote in message ... Can we stick limited formats of pictures on the field attributed as ""OLE" in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
#6
|
|||
|
|||
Okej.
Thanks, Patrik "Stephen Lebans" skrev: The only method to display Images for a form in Continuous view is to use an OLE Frame control bound to an OLE field. -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "Patrik" wrote in message ... Will the database grow dramastically even if I just store the path to the pictures in a table and then use the unbound object control to show the pictures in a continuous form? If so, are there any better ways to show pictures in a continuous form? Regards, Patrik "Stephen Lebans" skrev: The format of the image file is completely independant of Access. It is the responsibility of whatever Image/Paint program is currently registered with WIndows to view the Image file types and act as the OLE server for the object inserted into the OLE object field. MS Photo Editor is generally used as the OLE server for Access. It must be setup and registered to handle the selected image file types. Before I explain how to setup Photo Editor to be registeredd for the relevant Image file types one note of caution. Images embedded as OLE objects will quickly fill up your MDB. A small 40KB JPG can end up consuming several MB's in storage space. If you are planning on storing a large number of images or even a few extremely high resolution images then you should not be using OLE. Why do Images embedded as OLE objects take up so much storage space? In a nutshell: An Image inserted as an OLE object is no longer the same size as the original file. It is converted to a DIB(uncompressed Bitmap) and then wrapped in a EMF(Enhanced Metafile). THe EMF is then wrapped within the OLE stream. Further, if the original Image was not a Bitmap or Metafile, then another full size DIB preview is inserted into the OLE stream. THe only reasons to use an OLE object field are if you requi 1) The ability for your users to Edit the Image in the Program that acts as the OLE server. 2) The ability to view the Images with a Form in Continuous View. 3) The Images are embedded for security concerns. In reality, the enormous OLE file size "bloating" stops most users from inserting more than a few images. With the exception of viewing the images with a Form in Continuous view, coding solutions for the other 2 issues are available. The most common solution is to simply keep the images in a seperate folder storing the filenames only in a Text field. Using the Current event of the Form or the Format event of the relevant section on a Report, place a line of code to load the picture into the standard Image control NOT the OLE Frame control. Me.NameOfPictureControl.Picture = Me.NameOfTextBoxBoundToFileNameField There is lots of sample code out there complete with error checking. Search GoogleGroups. ********************************************* Here is a previous post of mine on for how to setup MS Photo Editor: Message 4 in thread From: Stephen Lebans ) Subject: Inserting picture into an access form View this article only Newsgroups: microsoft.public.access.activexcontrol Date: 2004-11-12 19:43:08 PST In this case the OLE server is simply an Image/paint program that: 1) Can function as an OLE Image server 2) Is registered to handle the specific Image file types you want to insert into the OLE obect field. In most cases, MS Photo Editor is used as the OLE Server program. It must though, be setup as the default/registered handler for the image file types in question. MS Photo Editor is no longer included with Office 2003. YOu will have to find you Office XP or WIn2K disks and install MS Photo Editor only! The simplest method to associate a program with a specific file extension(BMP,JPG,etc.) is to: 1) Open a folder containing the Images you want to insert. 2) Right click on a file while holding down the SHift key. 3) From the popup menu select "Open With". 4) Scroll down the Open With Dialog window until you find MS Photo Editor and select it. 5) Check the Always use this program to open this file type CheckBox control. 6) Click OK. Repeat the steps once for each different type of Image file you want to embedd in your table. ********************************************* -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. "ylmxw" wrote in message ... Can we stick limited formats of pictures on the field attributed as ""OLE" in access? In fact we know .BMP pictures are allowed. Now is .jpg Format allowed in Access? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Where does Outlook store my pictures? | Hashem Ouaida | General Discussion | 2 | September 7th, 2004 01:06 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |
How to store text and pictures for Web Application? | Siegfried Heintze | Database Design | 1 | August 26th, 2004 04:02 PM |