Search results

I'll tell you all I've done according to your instructions 1- Creating qryProcTypeCount Query 2- Join this query with the first one CurrentProc Query 3- put CountRecs in the report 4- Copy paste the code

1- Yes no splitting 2- I didn't fix the pgNumbers(pgNum) = 8 problem, I closed the report and opened it again!!! done by itself. 3- I have no other Groups

it was giving an error message regarding pgNumbers(pgNum) = 8 but now it didn't and no effect from the code

Hello again I tried too much with the report but without any positives, I think that I've done all what you said. The code seem doesn't exist :confused: !!! when I put the code no effect occurs then removed it and give me the same result : it didn't divide :(. Any way I know that I was like a...

Hello friend How are you ,,, so happy to see you again I've downloaded the file, it's working very well ,, incredible ,,, BUT when I took it to my db : 1- It didn't work as your file, I mean that it didn't divide as it should divide 2- I've error in the code : Private Sub...

Thanks very my much

so what's your idea ??? I can remove the grouping, but what about page footer it doesn't appear in the last page.

hey friend I figured out something : The report as I told you before is grouped by the Procedure Type ** when I select 18 it gives the perfect solution just for the last procedure type but the first still the same. ** Another note : the page footer doesn't appear in the last page. waiting for you

Just I select them

In the DCount() I put the Query name (CurrentProc) The Record Source of the report is a Query (CurrentProc)

Yes friend I did, but it still can I attach the db for you ??

Yes I removed now the report is working but it didn't divide the pages I tested it, I've selected 9 employees : it gives 8 in the first page and 1 in the second page I'm here with you

Hello again my friend vbaInet Thank you for taking care, I'm so much appreciated for your effort to assist me ** regarding the posted code, I've something wrong, I couldn't figure out. It gives error, I'm sure I didn't name all the needed objects correctly I'm still here with you

You're very right. But no way, we're forced to keep 4 records because what we can do ?? for example : the current procedure is for 17 employees !!! it must be kept as it is

Thanks a lot my dear friend, I'll keep that in my mind

I told you that's difficult to imagine, I'm sure you had some confusion 19 - 20 19 employees first page is 8 second is 6 Third is 5 20 employees first page is 8 second is 6 Third is 6 the page should not has less than 5 the second page has 6 to let the third page reach the desired...

You're right, it was my mistake to tell that may be solved in MS Access but because I'm not expert in Database Programming I thought that may be some solution can be. They need maximum 8 records in each page and if exceed 8 then it should be not less than 5 in each page. So if 17 : then 8 will...

may be you're telling the correct, but they were doing this before on MS Word, as you know it's normal in MS word and I'm still new at this firm where I moved to it since 3 months ago ... I told them that's a little bit hard to achieve but no way, their minds more solid than flint. Now they need...

It will be 5 pages with 8 records in each. simply they need maximum 8 records in each page and minimum 5

it will be the same for example: 17 employees first page is 8 second is 5 Third is 4 18 employees first page is 8 second is 5 Third is 5 19 employees first page is 8 second is 6 Third is 5 20 employees first page is 8 second is 6 Third is 6 I know it's very stupid, but according to their...