Problem with images in forms

  • Thread starter Thread starter Tytus
  • Start date Start date
T

Tytus

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.
 
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.
 
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
 
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.
 
Tytus said:
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.
Click to expand...

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.
 
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 wil
collect them all in a few seconds and build the table, inserting all th
paths and file names. The paths of thousand images of any filetype, wil
still take less than 30 seconds. Have a look and try it out. Run it, and i
it works the way you require, you can import the table and all or part o
the objects
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

Previous Posts In This Thread:

Problem with images in forms
I have a problem with Microsoft Access 2010 and 2007: there is a possibilit
to insert a picture into OLE Object field into record in form. However, i
does not work: whenever I insert an image into OLE field, it does not inser
an image, but an icon of it, a Package. I want to have an image visible i
record. But I always get an icon. I did not have this problem when I wa
working on Vista and earlier on XP, right now in all my computers I have thi
issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The proble
occurs in both, 2007 and 2010 version, I tried it on different computers, al
with Win 7.

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
text field to show the path. Then apply it to an image control. For a
example, see

http://www.datastrat.com/Download/Picture2K.zi
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

also you could use the attachment field type.
also you could use the attachment field type. i dont know what image format
will carry over but i have used JPG

hope one of these suggestions helps

:

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, no
the MDB file type. Further, while it does not bloat anywhere near as much a
an OLE field, it is still much, much bigger than saving a path in a tex
field. Further, you cannot sort or index an attachment datatype, and it i
non-standard, so you cannot export to another format
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

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, o
Windows XP. Inserting images in OLE field worked then. I would like t
continue this database, so changing it does not work for me. I do not want t
reinsert 1000+ images once again. Inserting images in OLE field works i
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 i
is the problem with Access 2007/2010 on Windows 7.

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 wil
collect them all in a few seconds and build the table, inserting all th
paths and file names. The paths of thousand images of any filetype, wil
still take less than 30 seconds. Have a look and try it out. Run it, and i
it works the way you require, you can import the table and all or part o
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/tutorial...97-2b1f513d86bc/aspnet-templated-usercon.aspx
 
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 wil
collect them all in a few seconds and build the table, inserting all th
paths and file names. The paths of thousand images of any filetype, wil
still take less than 30 seconds. Have a look and try it out. Run it, and i
it works the way you require, you can import the table and all or part o
the objects
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

Previous Posts In This Thread:

Problem with images in forms
I have a problem with Microsoft Access 2010 and 2007: there is a possibilit
to insert a picture into OLE Object field into record in form. However, i
does not work: whenever I insert an image into OLE field, it does not inser
an image, but an icon of it, a Package. I want to have an image visible i
record. But I always get an icon. I did not have this problem when I wa
working on Vista and earlier on XP, right now in all my computers I have thi
issue. I use Office 2010/2007 on Windows 7 Professional 32-bit. The proble
occurs in both, 2007 and 2010 version, I tried it on different computers, al
with Win 7.

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
text field to show the path. Then apply it to an image control. For a
example, see

http://www.datastrat.com/Download/Picture2K.zi
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

also you could use the attachment field type.
also you could use the attachment field type. i dont know what image format
will carry over but i have used JPG

hope one of these suggestions helps

:

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, no
the MDB file type. Further, while it does not bloat anywhere near as much a
an OLE field, it is still much, much bigger than saving a path in a tex
field. Further, you cannot sort or index an attachment datatype, and it i
non-standard, so you cannot export to another format
-
Arvin Meyer, MCP, MV
http://www.datastrat.co
http://www.mvps.org/acces
http://www.accessmvp.com

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, o
Windows XP. Inserting images in OLE field worked then. I would like t
continue this database, so changing it does not work for me. I do not want t
reinsert 1000+ images once again. Inserting images in OLE field works i
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 i
is the problem with Access 2007/2010 on Windows 7.

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 wil
collect them all in a few seconds and build the table, inserting all th
paths and file names. The paths of thousand images of any filetype, wil
still take less than 30 seconds. Have a look and try it out. Run it, and i
it works the way you require, you can import the table and all or part o
the objects.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

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/tutorial...9-fbcb8e17ef3a/integrate-windows-live-id.aspx
 
Back
Top