Prev: how to insert CRLF (carrage return/line feed) in report
Next: selective summing in a report
From: Don on 24 Jun 2008 13:12
This is a frustrating issue because it has worked before.

I have a report that has an image control in the "page header". Also in the
page header is a text box that is the path statement to a folder of graphics
on my server. As each record chages on my form, the path statement remains
the same but the file name in the target folder changes (as it should).

What I want to do is display the applicable graphic on each page of my
report. I have the following code in the format section of the
"PageHeaderSection":

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
Integer)

Me![imgGRAPHIC].Properties("Picture") = Me![txtPATH]

End Sub

When I try to display the report, I get the following error message:

Run-time Error '2220':

Food Show 2007 can't open the file 'F:\_DATABASE FILES\Food Show\Food Show
08\Food Show Book Image Files]'.

This report actually worked last year; I can't figure out what has happened.
Any help would be appreciated.

Don

P.S. by the way, I'm using Access 2007



--
Don Rountree
From: Mark A. Sam on 25 Jun 2008 09:43
Hello Don,

My first thought would be to be sure that the path, F:\_DATABASE FILES\Food
Show\Food Show 08\Food Show Book Image Files] exists on the machine you are
using. Open the Windows file explorer and make sure that you have F:\ drive
mapped.

God Bless,

Mark A. Sam


"Don" <Don(a)discussions.microsoft.com> wrote in message
news:08D01F7B-2FA0-4E3A-91AD-2408A2970A4B(a)microsoft.com...
> This is a frustrating issue because it has worked before.
>
> I have a report that has an image control in the "page header". Also in
> the
> page header is a text box that is the path statement to a folder of
> graphics
> on my server. As each record chages on my form, the path statement
> remains
> the same but the file name in the target folder changes (as it should).
>
> What I want to do is display the applicable graphic on each page of my
> report. I have the following code in the format section of the
> "PageHeaderSection":
>
> Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As
> Integer)
>
> Me![imgGRAPHIC].Properties("Picture") = Me![txtPATH]
>
> End Sub
>
> When I try to display the report, I get the following error message:
>
> Run-time Error '2220':
>
> Food Show 2007 can't open the file 'F:\_DATABASE FILES\Food Show\Food Show
> 08\Food Show Book Image Files]'.
>
> This report actually worked last year; I can't figure out what has
> happened.
> Any help would be appreciated.
>
> Don
>
> P.S. by the way, I'm using Access 2007
>
>
>
> --
> Don Rountree


 | 
Pages: 1
Prev: how to insert CRLF (carrage return/line feed) in report
Next: selective summing in a report