Greetings, I've read some great advice on similar topics, just nothing matching exactly what I'm trying
I'm pretty close I think on making this work, but note quite there.
I want to print a report that basically displays photographs. the photographs are located on a web server viewable from my browser. I want to reference the URL and "pull" them into my report at print time
TABLE:
In a Table, I have a field defined as Hyperlink.
A sample piece of data is this URL:
http://www.newberrycou nty.net/animal/aug16nelli3.jpg
When I click on the value in the table, it launches the photo just fine in IE.
REPORT
Recordsource is the table with the Hyperlink defined
On the report, I have an Image with these properties:
NAME = image6
Picture - Value reads (None)
Picture Type - Linked
Size Mod - stretch
Hyperlink Address [empty]
hyperlink subaddress [empty]
The field with the hyperlink from the table is on the field. It is named PICTURELOCATION
CODE
In the report details "On format" event, I have this code (I also tried the 'on print' event with the same results)
Me.Image6.Pictu re = Me.picturelocat ion.Hyperlink.A ddress
When I open the report, I get the error run-time error '2220'
microsoft access can't open the file
'http://www.newberrycou nty.net/animal/aug16nelli3.jpg '
I find it interesting that I can get to it from the table, but not in the report processing.
Any clear missing pieces?
One final hope is that the photo will be 'resized' nicely to fit in the size of the image on the report (in most cases, this would mean the photo has to shrink).
Thanks!!
5 21181 JKing 1,206
Recognized Expert Top Contributor
Not sure if this is possible to be honest.
I know it can be done in a form as shown here at this link by microsoft Displaying images in reports and forms
The last section of the page details using a web browser object to open a URL picture.
Bummer!
I do some volunteer work and the photos of the dogs can come from any one of a variety of shelters with their own websites. Each week its helpful to have one page printed with photos that can originate from as many as 10 different locations.
its easy to get to the photos, and I was hoping to eliminate the need to go through the steps to 'save' the photos to one common location. If I could just cut and paste the URL into my table and then render the report, I could get all the photos for the week on one page for this particular purpose.
Thanks in advance for any other ideas.
MMcCarthy 14,534
Recognized Expert Moderator MVP
Have you tried linking the URL in an OLE Object type field and displaying it in a bound object frame?
Have you tried linking the URL in an OLE Object type field and displaying it in a bound object frame?
Thanks for the response! I appreciate you considering my problem.
Well, I just tried to "link" to the url in an ole object and it doesn't seem to find it. Also, I believe this approach would call for several steps per entry, which i can do easily with my current MS Word approach.
What i was hoping was to just paste append a group of 10 or more URLs to a table as 10 rows and then quickly run my report. Take a 10-15 minute activity and make it about 30 seconds.
It seems thusfar the deal breaker in Access is rendering the report with the link to th URLs.
Thanks for the idea, and please tell me if I misunderstood your approach. I can send more specifics on what I was doing.
Realize this is 3 years later, but you did ever find a solution? I'm trying to do the exact same thing but for 0000s of images.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Nicola |
last post by:
Hi Everyone,
I am new to programming and would like to know how to
open an access Report from within vb 6. I am trying to write a program
to organise cross stitch threads. I have found out how to use a database
table
but all I want to do now is to click a command button to display this access
report.
Any suggestions please ?????
|
by: M P |
last post by:
Hi!
I am currently working on a project that will migrate MS Access DB and Front
End to web-base solution to reduce MS Access installation. Previously, users
are using MS Access as frontend to produce customized report. I am not sure
if in a web based solution, using ASP, I can display the access report as-is
or by converting to pdf (server...
|
by: ellenh |
last post by:
I have read postings on the similar subject including the posting from
2003 shown below. This process works fine to display a single page
snapshot report in PowerPoint. I need to display subsequent pages from
the same snapshot file in subsequent slides in PowerPoint. I realize
that it is possible to add VB code to the Snapshot Viewer...
|
by: emebohw |
last post by:
Hey all, weird problem. I cant seem to get a populated text field that
has a hyperlink to work when I output my access report to MS office
document image writer file. If I stick a 'label' type field on the
report and put a url in there and print as msodiw then the hyperlink
works. Anyone ever see this?
Also, even on the access report, the...
|
by: sonicfun2006 |
last post by:
I have SQL Server Database and MS Access 2003 is connected with ODBC. I have very large amount of records in various tables. The database is very dynamic as it changes every minute. I’m trying to have a live MS Access report which would pull data from SQL Server. I’ll try to explain how I’m trying do this:
The Access report should have two...
| |
by: NewDirections |
last post by:
I have developed a Access 2000 database to run my business. I use it to track products, Sales, Customers, format Newsletters (select products) for mailing, and etc. What I need to do is add photos of my products in my newsletter report. The photo's are stored in a directory on my network under a grouping by type, and a jpg format. I have been...
|
by: ITTrimbleKY |
last post by:
Issue:
I am creating a report that I want running sums in. The problem is that the field I am summing has 3 different entries that I need to sum. I have tried doing the IIF statement, but it doesn't seem to work.
Pertinent information:
Access 2003
Report pulls data from 1 query
data pulled is location, employee, several workstation...
|
by: accessdumbie |
last post by:
We have a small amount of information in a Word Document that I would like to print in an Access Report. We have the location of the document for each individual record stored in a hyperlink field in that record.
The report is the pertinent data for that record.
We are currently pasting the information in the word document into a memo field...
|
by: iheartvba |
last post by:
Hi,
I am trying to link a picture to an access report as follows:
1. The location of the Picure is stored as a hyperlink field in a table
2. The On Load Event of the report triggers the following code"
Private Sub Report_Load()
Set cnn = CurrentProject.Connection
'Table containing Logo Path
rst.Open "tblClientDetails", cnn,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |