Functionality error when converting Access 2007 to 2003

  • Thread starter Thread starter New_User
  • Start date Start date
N

New_User

I created a database on Access 2007 with pictures that show on a form for
each record using a table containing the path to each picture. This is
working as it should with Access 2007 but I had to convert the database to
Access 2003 and I get the following error message:
The expression On Current you entered as the event property setting produced
the following error:Object or class does not support the set of events.
Can anyone tell me if this problem is due to my having both 2003 and 2007
versions of Access installed on my computer or is this only a problem of
Windows Vista (my computer is running on Windows XP Pro). What is the problem
and how do I fix it. Thank you.
 
In 2007, an Image control can have a ControlSource -- but not 2003 ...
This is a really nice feature that was added in 2007

In 2003, you have to use code to assign an Image to display a path and
filename

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Thank you. Can anyone tell me where I can find some help on this code to have
an image display from a path and file name in Access 2003.
 
Hi New_User (what is your name?)

show an image specified by a field with path and filename

'~~~~~~~~~~~~~~~~~
Dim strFilename as string
if isNull(me.control_path_filename) then exit sub

strFilename = me.control_path_filename

If Len(Dir(strFilename)) > 0 Then
Me.controlname_image.visible = true
Me.controlname_image.Picture = strFilename
else
Me.controlname_image.visible = false
end if
'~~~~~~~~~~~~~~~~~

WHERE
control_path_filename is the control Name containing a path and filename
controlname_image is the control Name of your Image control

Launch this code on the form Current event and the AfterUpdate event of
the control with path and filename

~~~

if you want to display multiple images from a continuous form, there is
more coding required as you have to give Access 2003 tools to do
something it is not designed to do


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*
 
Back
Top