only have logo on first page

[colkas]

Hi

We want to have the date, idquote number and page numbers at the top of every sheet of a report. However, we want it to go above our logo rather than below.

So for the date etc.. to show on every page I know it as to go in the Page header If I put it above the logo in Report Header I lose the information on all the other pages. But I dont want the logo on every page, so is there away to put it the logo in the page header but only have it show on the first page.

Thanks

 

[boblarson]

Put the logo in the page header where you want it and then in the page header's ON FORMAT event put this:

Me.YourLogoControlNameHere.Visible = ([Page] = 1)

 

[colkas]

Hi Bob

I have put this in the Pageheader On Format

me.image8.Visible = ([Page] = 1)

but I get a message saying Microsoft Acess cannot find the macro Me

Any ideas please

thanks

 

[boblarson]

Hi Bob

I have put this in the Pageheader On Format

me.image8.Visible = ([Page] = 1)

but I get a message saying Microsoft Acess cannot find the macro Me

Any ideas please

thanks

You have placed it in the event PROPERTY and not in the VBA window. It needs to go in the VBA of the event and not the property. See here for an explanation of what I mean:

http://www.btabdevelopment.com/ts/eventcode

 

[colkas]

Hi bob

I put it in the Event procedure and it works fine.

Thanks for the help