Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Web hosted photo in report - Challenge

Status
Not open for further replies.

RogueVW

Programmer
Oct 8, 2002
15
US
We have moved an Access DB to a MYSQL DB that is web hosted and uses a Ruby interface.

Creating elegant reports in Ruby is difficult and time consuming, so until then I have a front end Access DB linked to the hosted MYSQL back end for many of the reports.

I am having problems with creating reports with photos that are hosted on the web server. The method used and well documented on Tek-tips does not seem to work for hosted jpgs.

Description of the report would be an info page for each student with a photo of the included. The photos were stored locally but are now hosted on the webserver.

Currently:

Private Sub Group_Format(Cancel As Integer, FormatCount As Integer)
On Error GoTo NoPhoto_Err
Me![Photograph].Properties("Picture") = "c:\data\pictures\" + Me![LastName] + "_" + Me![FirstName] + Me![contactID]+".jpg"
Exit Sub

NoPhoto_Err:
If Err.Number = 2220 Then
Me![Photograph].Properties("Picture") = "c:\data\pictures\NoPhoto.jpg"
Else
MsgBox Err.Description
End If
End Sub

I would like to refer to the photo stored on the web such as:
Me![Photograph].Properties("Picture") = " + Me![LastName] + "_" + Me![FirstName] + Me![contactID]+".jpg"

This does not work.

Any ideas? Does Access even allow this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top