473,320 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Display dynamic image in MS Access 2007

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
1 24241
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Wally | last post by:
I am trying to display images from an Access 2000 database and I get an error "Invalid Parameter Used" when I execute the code line "picBLOB.Image = Image.FromStream(stmBLOBData)" in my Visual...
27
by: Wayne | last post by:
I've been clicking around Access 2007 Beta 2 and can't see the custom menu bar designer. Is it in the beta? Maybe I'm blind. The question that comes to mind is: Will custom menu bars be the same...
29
by: Paul H | last post by:
Why the heck was this dropped? All my dbs use ULS even the complex ones. It aint perfect, it's too fiddly, but it works. How will I be able to say "These users can run these reports and these...
7
by: dino d. | last post by:
Hi- I want to create a dynamic image with areas so that when the user clicks different areas, the user jumps to those pages. The problem is, I can't seem to figure out how to do this efficiently....
8
by: elias.farah | last post by:
Hello Everyone, I'm having some very weird behavior on a couple of Access forms. (Not all forms, just some of them). The forms have been working for years, under Access XP/2003 etc, and last...
0
by: bobdydd | last post by:
Hi All I am using the common dialog routine to insert a pathway to a jpeg To display on a form that worked perfectly well in Access 2000. Now using the same setup everything works as before...
9
by: prakashwadhwani | last post by:
Hi !! I'm about to develop a new project for a client. Should I go about it in Access 2003 or 2007 ? Purchasing it either for me or for my client is not a major consideration here ... what I'd...
2
by: sphinney | last post by:
Hi everyone. I have a form in my Access 2007 database with a Microsoft Office Document Imaging Viewer Control 12.0 object on it. The object is named "GRAPHIC_mdv". When the form opens I want to...
5
by: mturner64 | last post by:
I am developing an application using asp.net where a user can enter first name, last name, donation amount, date, et cetera. After the user enters the information and clicks submit, the information...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.