I can only see it as possible if you keep the page break in same place and just hide first page of report... please prove me wrong and upload the previous version of the report.
Does anyone know how to hide the first page of the report?
No all I want is for when there is a new week (sorted by week ending) for this data to go on the next page instead of the same page... as would happen if i delete the page break. It works fine with the page break where it is although the first page is blank and I want to hide this or get rid.
Okay ive copied the basic structure of what i want:
Basically i want to make sure that the week ending on the report is always at the top of the page.
Enter a start date of 01/08/2005 and end date of 31/08/2005 to see what I mean.
No I have the page break in the right place... have experimeted repositioning it but then you don't get the week ending on a new page.
I just need to hide the first page of the report.
Any ideas?
I have a page break at the top of my report so that each week ending is on a new page... however this means that the first page is effectively blank due to the report footer... How do i get rid of the first page so that it is not displayed to user.
Andy
Hiya,
I currently have a query that looks up staff names and then if they click a staff name from the combo box on a form they are then able to preview a report showing their performance. I want the combo box to have the ability to be left blank or the option to select all so that I can preview...
As everyone has helped me here is my effort...
Create a form with two unbound objects or combo box... name one StartDate and the other EndDate.
Create a query with the criteria something along the lines of...
Between [Forms]![Name of form]![StartDate] And [Forms]![Name of form]![EndDate]
Then...
How do you get rid of the security warning when loading my database.. it says that it might contain some code that can harm my computer.
Cheers every1
Andy
I only want my refresh button to work (called command42) to work if there is a value in the hoursworked cell which is in the subform (called timesheet1).
Any ideas?