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
|
|||
|
|||
Problem with images in forms
I have a problem with Microsoft Access 2010 and 2007: there is a possibility
to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. |
#2
|
|||
|
|||
Problem with images in forms
Instead of an OLE field, store the picture in the file system, and use a
text field to show the path. Then apply it to an image control. For an example, see: http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Tytus" wrote in message ... I have a problem with Microsoft Access 2010 and 2007: there is a possibility to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. |
#3
|
|||
|
|||
Problem with images in forms
also you could use the attachment field type. i dont know what image formats
will carry over but i have used JPG. hope one of these suggestions helps. "Arvin Meyer [MVP]" wrote: Instead of an OLE field, store the picture in the file system, and use a text field to show the path. Then apply it to an image control. For an example, see: http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Tytus" wrote in message ... I have a problem with Microsoft Access 2010 and 2007: there is a possibility to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. . |
#4
|
|||
|
|||
Problem with images in forms
The attachment datatype only works in the ACCDB file type of 2007/2010, not
the MDB file type. Further, while it doesn't bloat anywhere near as much as an OLE field, it's still much, much bigger than saving a path in a text field. Further, you cannot sort or index an attachment datatype, and it is non-standard, so you cannot export to another format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "tighe" wrote in message ... also you could use the attachment field type. i dont know what image formats will carry over but i have used JPG. hope one of these suggestions helps. "Arvin Meyer [MVP]" wrote: Instead of an OLE field, store the picture in the file system, and use a text field to show the path. Then apply it to an image control. For an example, see: http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Tytus" wrote in message ... I have a problem with Microsoft Access 2010 and 2007: there is a possibility to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. . |
#5
|
|||
|
|||
Problem with images in forms
The problem is that I have a database, which I started some time ago, on
Windows XP. Inserting images in OLE field worked then. I would like to continue this database, so changing it does not work for me. I do not want to reinsert 1000+ images once again. Inserting images in OLE field works in Windows XP, even in XP Mode in Windows 7, but only with bmp files. Unfortunately, I was unable to make it work on Windows 7--so definitively it is the problem with Access 2007/2010 on Windows 7. |
#6
|
|||
|
|||
Problem with images in forms
"Tytus" wrote in message
... The problem is that I have a database, which I started some time ago, on Windows XP. Inserting images in OLE field worked then. I would like to continue this database, so changing it does not work for me. I do not want to reinsert 1000+ images once again. Inserting images in OLE field works in Windows XP, even in XP Mode in Windows 7, but only with bmp files. Unfortunately, I was unable to make it work on Windows 7--so definitively it is the problem with Access 2007/2010 on Windows 7. However, if you have the images in a folder(s), the code in PictureMgr will collect them all in a few seconds and build the table, inserting all the paths and file names. The paths of thousand images of any filetype, will still take less than 30 seconds. Have a look and try it out. Run it, and if it works the way you require, you can import the table and all or part of the objects. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
#7
|
|||
|
|||
PictureMgr and backend db
I am using your PictureMgr and love it - everything is working fine with it, but I want to create the table in the backend of my database, rather than the front. I have been searching and have not yet found an answer on how to do that (or I am just spacing out what I am looking at).
Arvin Meyer [MVP] wrote: However, if you have the images in a folder(s), the code in PictureMgr 22-Dec-09 However, if you have the images in a folder(s), the code in PictureMgr will collect them all in a few seconds and build the table, inserting all the paths and file names. The paths of thousand images of any filetype, will still take less than 30 seconds. Have a look and try it out. Run it, and if it works the way you require, you can import the table and all or part of the objects. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com Previous Posts In This Thread: On Thursday, December 17, 2009 9:27 PM Tytus wrote: Problem with images in forms I have a problem with Microsoft Access 2010 and 2007: there is a possibility to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. On Thursday, December 17, 2009 10:45 PM Arvin Meyer [MVP] wrote: Instead of an OLE field, store the picture in the file system, and use atext Instead of an OLE field, store the picture in the file system, and use a text field to show the path. Then apply it to an image control. For an example, see: http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com On Friday, December 18, 2009 10:42 AM tighe wrote: also you could use the attachment field type. also you could use the attachment field type. i dont know what image formats will carry over but i have used JPG. hope one of these suggestions helps. "Arvin Meyer [MVP]" wrote: On Friday, December 18, 2009 2:04 PM Arvin Meyer [MVP] wrote: The attachment datatype only works in the ACCDB file type of 2007/2010, notthe The attachment datatype only works in the ACCDB file type of 2007/2010, not the MDB file type. Further, while it does not bloat anywhere near as much as an OLE field, it is still much, much bigger than saving a path in a text field. Further, you cannot sort or index an attachment datatype, and it is non-standard, so you cannot export to another format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com On Tuesday, December 22, 2009 2:06 AM Tytus wrote: The problem is that I have a database, which I started some time ago, The problem is that I have a database, which I started some time ago, on Windows XP. Inserting images in OLE field worked then. I would like to continue this database, so changing it does not work for me. I do not want to reinsert 1000+ images once again. Inserting images in OLE field works in Windows XP, even in XP Mode in Windows 7, but only with bmp files. Unfortunately, I was unable to make it work on Windows 7--so definitively it is the problem with Access 2007/2010 on Windows 7. On Tuesday, December 22, 2009 11:13 AM Arvin Meyer [MVP] wrote: However, if you have the images in a folder(s), the code in PictureMgr However, if you have the images in a folder(s), the code in PictureMgr will collect them all in a few seconds and build the table, inserting all the paths and file names. The paths of thousand images of any filetype, will still take less than 30 seconds. Have a look and try it out. Run it, and if it works the way you require, you can import the table and all or part of the objects. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET Templated UserControls avoid Code Duplication http://www.eggheadcafe.com/tutorials...d-usercon.aspx |
#8
|
|||
|
|||
PctureMgr
I am using your PictureMgr and love it - everything is working fine with it, but I want to create the table in the backend of my database, rather than the front. I have been searching and have not yet found an answer on how to do that (or I am just spacing out what I am looking at). Any help appreciated
Arvin Meyer [MVP] wrote: However, if you have the images in a folder(s), the code in PictureMgr 22-Dec-09 However, if you have the images in a folder(s), the code in PictureMgr will collect them all in a few seconds and build the table, inserting all the paths and file names. The paths of thousand images of any filetype, will still take less than 30 seconds. Have a look and try it out. Run it, and if it works the way you require, you can import the table and all or part of the objects. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com Previous Posts In This Thread: On Thursday, December 17, 2009 9:27 PM Tytus wrote: Problem with images in forms I have a problem with Microsoft Access 2010 and 2007: there is a possibility to insert a picture into OLE Object field into record in form. However, it does not work: whenever I insert an image into OLE field, it does not insert an image, but an icon of it, a Package. I want to have an image visible in record. But I always get an icon. I did not have this problem when I was working on Vista and earlier on XP, right now in all my computers I have this issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The problem occurs in both, 2007 and 2010 version, I tried it on different computers, all with Win 7. On Thursday, December 17, 2009 10:45 PM Arvin Meyer [MVP] wrote: Instead of an OLE field, store the picture in the file system, and use atext Instead of an OLE field, store the picture in the file system, and use a text field to show the path. Then apply it to an image control. For an example, see: http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com On Friday, December 18, 2009 10:42 AM tighe wrote: also you could use the attachment field type. also you could use the attachment field type. i dont know what image formats will carry over but i have used JPG. hope one of these suggestions helps. "Arvin Meyer [MVP]" wrote: On Friday, December 18, 2009 2:04 PM Arvin Meyer [MVP] wrote: The attachment datatype only works in the ACCDB file type of 2007/2010, notthe The attachment datatype only works in the ACCDB file type of 2007/2010, not the MDB file type. Further, while it does not bloat anywhere near as much as an OLE field, it is still much, much bigger than saving a path in a text field. Further, you cannot sort or index an attachment datatype, and it is non-standard, so you cannot export to another format. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com On Tuesday, December 22, 2009 2:06 AM Tytus wrote: The problem is that I have a database, which I started some time ago, The problem is that I have a database, which I started some time ago, on Windows XP. Inserting images in OLE field worked then. I would like to continue this database, so changing it does not work for me. I do not want to reinsert 1000+ images once again. Inserting images in OLE field works in Windows XP, even in XP Mode in Windows 7, but only with bmp files. Unfortunately, I was unable to make it work on Windows 7--so definitively it is the problem with Access 2007/2010 on Windows 7. On Tuesday, December 22, 2009 11:13 AM Arvin Meyer [MVP] wrote: However, if you have the images in a folder(s), the code in PictureMgr However, if you have the images in a folder(s), the code in PictureMgr will collect them all in a few seconds and build the table, inserting all the paths and file names. The paths of thousand images of any filetype, will still take less than 30 seconds. Have a look and try it out. Run it, and if it works the way you require, you can import the table and all or part of the objects. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com On Friday, January 22, 2010 5:19 PM Ron Dorn wrote: PictureMgr and backend db I am using your PictureMgr and love it - everything is working fine with it, but I want to create the table in the backend of my database, rather than the front. I have been searching and have not yet found an answer on how to do that (or I am just spacing out what I am looking at). Submitted via EggHeadCafe - Software Developer Portal of Choice Integrate Windows Live ID Authentication with ASP.NET Membership, Profiles and Roles http://www.eggheadcafe.com/tutorials...s-live-id.aspx |
Thread Tools | |
Display Modes | |
|
|