By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,745 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,745 IT Pros & Developers. It's quick & easy.

Display dynamic image in MS Access 2007

P: n/a
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(Cancel 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.

Mar 16 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <al****@gmail.comwrote in message
news:11*********************@e65g2000hsc.googlegro ups.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(Cancel 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.
Mar 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.