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
|
|||
|
|||
Embedding an image into field
Greetings. Is there any way to DIRECTLY embed an image into an Access (2000)
database field from a camera or scanner? (without saving the image to a folder then using the "insert object" from file!). Many Thanks in advance. |
#2
|
|||
|
|||
Embedding an image into field
Hi Phenix
You "can" insert and store picture in an access DB but that not the best method as your DB will very quickly become very big. (access db's can only only be a maximum of 2gb and for good quality picture this is not very many) But if for some reason you really want to then try this You need to save the original picture on your hard drive and simply show a “thumbnail” Bitmap copy of this on you form that could be used “as-is” or maybe as a hyperlink to open the main picture (using OnClick) Make copies of the pictures you want to link to your records (on C Drive / hard disk) and save them as ThumbnailPicture1, ThumbnailPicture2, ThumbnailPicture3, etc, (or use the ID of the record in the table) If you have a picture processing programme such as Photoshop or Photopaint then use that to resample and convert. If you don’t have one of these programmes: 1 Click start 2 Click My Pictures (if that’s where they are) 3 Right click the picture and select “Open With” 4 Select Windows Office Picture Manager 5 After the picture is open click the Picture Menu then select Resize 6 Resize your picture to the correct size NOTE. You will need to know the pixel size of your OLE box - see below 7 SaveAS a copy of the original (DON’T JUST SAVE or you will ruin the original picture) BMP Windows Bitmap this is best option GIFF CompuServe Bitmap is also OK JPEG’s “will” work but they are not really meant for this type of application REMEMBER that JPEG’s are reducing formats – so each time you change and save you will lose some resolution. Create an OLE field in the table (use this OLE field on your form if you wish to display the picture on a form with a particular record) To link your picture thumbnail with the OLE 1 Open the Table that will hold the data /picture (not the form) 2 navigate to the OLE field on the correct record and Right Click 3 Select Insert Object 4 Select Create From File and then Bitmap and then check the Link option 5 Browse to your picture and select it 6 Click OK 7 “Package” will appear in the field 8 View your image on the form Some notes on the size of your OLE object – regardless of what anyone will tell you there is no way of converting pixels to cm’s – which your OLE object will be sized in, UNLESS you know the size of each pixel or even the screen resolution and as screens are all different sizes and resolutions this simply isn’t possible here, so I have given the APPROXIMATE conversions here you will have to gig about with your thumbnail until it fits your OLE. Better still save all the thumbnails as size that you’re happy with and resize your OLE to fit this. On a screen resolution of 1024 Pixels X 768 (this is standard High Res for a lap top) 5mm = 118 Pixels or 14.173 Points 1cm = 236 Pixels or 28.346 Points So you can work out that say 3.5cm would be 827 Pixels or 99.213 Points - I know this looks rong but remember that when you incease screen res you don't just increase the size you also increase the content!! Hope this helps and points you in the right direction -- Wayne Manchester, England. Enjoy whatever it is you do "phenix" wrote: Greetings. Is there any way to DIRECTLY embed an image into an Access (2000) database field from a camera or scanner? (without saving the image to a folder then using the "insert object" from file!). Many Thanks in advance. |
#3
|
|||
|
|||
Embedding an image into field
A Million thanks for the information, much of it is very helpful and your
answer is appreciated. "Wayne-I-M" wrote: Hi Phenix You "can" insert and store picture in an access DB but that not the best method as your DB will very quickly become very big. (access db's can only only be a maximum of 2gb and for good quality picture this is not very many) But if for some reason you really want to then try this You need to save the original picture on your hard drive and simply show a “thumbnail” Bitmap copy of this on you form that could be used “as-is” or maybe as a hyperlink to open the main picture (using OnClick) Make copies of the pictures you want to link to your records (on C Drive / hard disk) and save them as ThumbnailPicture1, ThumbnailPicture2, ThumbnailPicture3, etc, (or use the ID of the record in the table) If you have a picture processing programme such as Photoshop or Photopaint then use that to resample and convert. If you don’t have one of these programmes: 1 Click start 2 Click My Pictures (if that’s where they are) 3 Right click the picture and select “Open With” 4 Select Windows Office Picture Manager 5 After the picture is open click the Picture Menu then select Resize 6 Resize your picture to the correct size NOTE. You will need to know the pixel size of your OLE box - see below 7 SaveAS a copy of the original (DON’T JUST SAVE or you will ruin the original picture) BMP Windows Bitmap this is best option GIFF CompuServe Bitmap is also OK JPEG’s “will” work but they are not really meant for this type of application REMEMBER that JPEG’s are reducing formats – so each time you change and save you will lose some resolution. Create an OLE field in the table (use this OLE field on your form if you wish to display the picture on a form with a particular record) To link your picture thumbnail with the OLE 1 Open the Table that will hold the data /picture (not the form) 2 navigate to the OLE field on the correct record and Right Click 3 Select Insert Object 4 Select Create From File and then Bitmap and then check the Link option 5 Browse to your picture and select it 6 Click OK 7 “Package” will appear in the field 8 View your image on the form Some notes on the size of your OLE object – regardless of what anyone will tell you there is no way of converting pixels to cm’s – which your OLE object will be sized in, UNLESS you know the size of each pixel or even the screen resolution and as screens are all different sizes and resolutions this simply isn’t possible here, so I have given the APPROXIMATE conversions here you will have to gig about with your thumbnail until it fits your OLE. Better still save all the thumbnails as size that you’re happy with and resize your OLE to fit this. On a screen resolution of 1024 Pixels X 768 (this is standard High Res for a lap top) 5mm = 118 Pixels or 14.173 Points 1cm = 236 Pixels or 28.346 Points So you can work out that say 3.5cm would be 827 Pixels or 99.213 Points - I know this looks rong but remember that when you incease screen res you don't just increase the size you also increase the content!! Hope this helps and points you in the right direction -- Wayne Manchester, England. Enjoy whatever it is you do "phenix" wrote: Greetings. Is there any way to DIRECTLY embed an image into an Access (2000) database field from a camera or scanner? (without saving the image to a folder then using the "insert object" from file!). Many Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|