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?
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?