Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

image in report.

Discussion in 'Information Technology' started by Stefan, Jul 28, 2006.

Tags:
  1. Stefan

    Stefan
    Expand Collapse
    Guest

    Hi,

    Private Sub Report_Page()
    Me.Afbeelding.Picture = Me.Foto
    End Sub

    With this code i can put an image on every page of my report. It works
    accept on the first page. I get no picture on page one.

    If i use the following code i can monitor the code; this code stops, even
    on the first page, but i get everytime (on every page) a wrong fotolink, if i
    continue the code the wright picture does appear.

    Private Sub Report_Page()
    linkfoto = me.Foto
    Stop
    Me.Afbeelding.Picture = Me.Foto
    End Sub


    So, how can i put the picture on my first page.
    --
    groeten,
    Stefan
     
  2. Loading...


  3. bob

    bob
    Expand Collapse
    Guest

    Is your image control in the Detail section (i.e. 1 image per record) ?

    If yes, use the Detail Format event, rather than the Report Page event, eg:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Afbeelding.Picture = Me.Foto
    End Sub

    --
    _______________________________________________________
    DBPix 2.0: Add pictures to Access, Easily & Efficiently
    http://www.ammara.com/dbpix/access.html





    =?Utf-8?B?U3RlZmFu?= <123@abc> wrote:
    >Hi,
    >
    >Private Sub Report_Page()
    > Me.Afbeelding.Picture = Me.Foto
    >End Sub
    >
    >With this code i can put an image on every page of my report. It works
    >accept on the first page. I get no picture on page one.
    >
    >If i use the following code i can monitor the code; this code stops, even
    >on the first page, but i get everytime (on every page) a wrong fotolink, if i
    >continue the code the wright picture does appear.
    >
    >Private Sub Report_Page()
    > linkfoto = me.Foto
    > Stop
    > Me.Afbeelding.Picture = Me.Foto
    >End Sub
    >
    >
    >So, how can i put the picture on my first page.
    >--
    >groeten,
    >Stefan
     
  4. Stefan

    Stefan
    Expand Collapse
    Guest

    Bob,

    Thanks, it works fine

    --
    Stefan


    "bob" wrote:

    >
    >
    > Is your image control in the Detail section (i.e. 1 image per record) ?
    >
    > If yes, use the Detail Format event, rather than the Report Page event, eg:
    >
    > Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    > Me.Afbeelding.Picture = Me.Foto
    > End Sub
    >
    > --
    > _______________________________________________________
    > DBPix 2.0: Add pictures to Access, Easily & Efficiently
    > http://www.ammara.com/dbpix/access.html
    >
    >
    >
    >
    >
    > =?Utf-8?B?U3RlZmFu?= <123@abc> wrote:
    > >Hi,
    > >
    > >Private Sub Report_Page()
    > > Me.Afbeelding.Picture = Me.Foto
    > >End Sub
    > >
    > >With this code i can put an image on every page of my report. It works
    > >accept on the first page. I get no picture on page one.
    > >
    > >If i use the following code i can monitor the code; this code stops, even
    > >on the first page, but i get everytime (on every page) a wrong fotolink, if i
    > >continue the code the wright picture does appear.
    > >
    > >Private Sub Report_Page()
    > > linkfoto = me.Foto
    > > Stop
    > > Me.Afbeelding.Picture = Me.Foto
    > >End Sub
    > >
    > >
    > >So, how can i put the picture on my first page.
    > >--
    > >groeten,
    > >Stefan

    >
    >
     

Share This Page