N
Ngan Bui
I have a table that has location information. and a
subtable that holds information of pictures for the
location. The subtable has pic desc and a text field
called PictureName that holds the pathname of the pic.
In the location form, when I click on the preview report,
it should preview that one location record and any pics
associated with it.
In my report, in the GroupHeader2_Format (the PictureName
header), I have the following function:
Dim R as report
Set R = Reports!rptLocEvalPic
strPath = "O\databases\Pictures\"
With R
If IsNull(R!PictureName) Then
.pic.Picture = strPath & "color\none.jpg"
Else
.pic.Picture = strPath & R!PictureName
End If
End With
If my location record doesn't have a pic and I run this
report, I get an error:
Run-Time Error '2427':
You entered an expression that has no value.
What to do?
Ngan
subtable that holds information of pictures for the
location. The subtable has pic desc and a text field
called PictureName that holds the pathname of the pic.
In the location form, when I click on the preview report,
it should preview that one location record and any pics
associated with it.
In my report, in the GroupHeader2_Format (the PictureName
header), I have the following function:
Dim R as report
Set R = Reports!rptLocEvalPic
strPath = "O\databases\Pictures\"
With R
If IsNull(R!PictureName) Then
.pic.Picture = strPath & "color\none.jpg"
Else
.pic.Picture = strPath & R!PictureName
End If
End With
If my location record doesn't have a pic and I run this
report, I get an error:
Run-Time Error '2427':
You entered an expression that has no value.
What to do?
Ngan