Display dynamic image in MS Access 2007

[Eugene]

Hello All,

I need a report in Access 2007 to show a dynamic image on every page.
I have a table, and I store image's path in a cell in each of the
rows.

In 2003, I was able to do that using VB, the following code worked:

Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Me![Image17].Picture = Me![imagepath]
End Sub

where Image17 is the name of the field of a picture type and
[imagepath] is the name of the column that stores the path to image on
the disk.

I upgraded my Office to 2007 and now I get the following error every
time I start that app:

"missing or broken reference to the file 'MDIVWCTL.DLL' version 11.0"

Can anyone think of any other way to fix my problem?

Thank you.

[Allen Browne]

Re: Display dynamic image in MS Access 2007

In Access 2007, the image control has a Control Source property, so you
don't need any code.

Open the report in design view.
Right-click the image control, and choose Properties.
In the Properties sheet, on the Data tab, set the Control Source to:
imagepath
You're done.

You will still have the broken reference problem though. To solve that, open
a code window (e.g. press Ctrl+G), and choose References on the Tools menu.
Try unchecking the box beside the MDIWCTL.DLL library. Then see if the code
compiles (Compile on Debug menu.) If it does, the libarary may not have been
needed, and you're home free.

If the code did need the library, you will need to track the library down
(e.g. by going back to your old system), work out where it came from, and
install it onto your new system. Once you have it installed, check that the
code compiles. Depending on the library, you may be able to install it by
copying to your hard disk, and using regsvr32.

More info:
Solving Problems with Library References
at:

http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eugene" <alsu50@gmail.c omwrote in message
news:1174008503 .943061.68560@e 65g2000hsc.goog legroups.com...

Hello All,
>
I need a report in Access 2007 to show a dynamic image on every page.
I have a table, and I store image's path in a cell in each of the
rows.
>
In 2003, I was able to do that using VB, the following code worked:
>
Private Sub Detail_Format(C ancel As Integer, FormatCount As Integer)
Me![Image17].Picture = Me![imagepath]
End Sub
>
where Image17 is the name of the field of a picture type and
[imagepath] is the name of the column that stores the path to image on
the disk.
>
I upgraded my Office to 2007 and now I get the following error every
time I start that app:
>
"missing or broken reference to the file 'MDIVWCTL.DLL' version 11.0"
>
Can anyone think of any other way to fix my problem?
>
Thank you.
>