Mohammad Alsolaiman
asked on
Prevent heading from printing in the last page if no more records.
Hi:
In the second page of this report, as you can see that is the heading is appear at top of page , because the maximum number of records at a the previous page is reached.
How can I prevent heading from appear in this case.
e. g the last page I need to print the tailing only. And at bottom of last page.
Please help.
1.PNG
2.PNG
Report-Q1.mdb
In the second page of this report, as you can see that is the heading is appear at top of page , because the maximum number of records at a the previous page is reached.
How can I prevent heading from appear in this case.
e. g the last page I need to print the tailing only. And at bottom of last page.
Please help.
1.PNG
2.PNG
Report-Q1.mdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you post basic sample of the Database without the ActiveX control?
Active X controls need references installed on each individual target computer.
If not, an error will be generated, and the report will not display.
(see attached screenshot)
Also it is not clear how you are determining the "maximum number of records at a the previous page"
Since there only appear to be 19 records, ...but only 3 are "Full" records...?
JeffCoachman
untitled.JPG
Active X controls need references installed on each individual target computer.
If not, an error will be generated, and the report will not display.
(see attached screenshot)
Also it is not clear how you are determining the "maximum number of records at a the previous page"
Since there only appear to be 19 records, ...but only 3 are "Full" records...?
JeffCoachman
untitled.JPG
ASKER
Hello JeffCoachman
Can you post basic sample of the Database without the ActiveX control?I think this err occur because of my version is Arabic. I notice that this err happen to me when distribute my apps on English versions of windows or office.
But the English version will work appropriate to Arabic version .
Also it is not clear how you are determining the "maximum number of records at a the previous page"Actually I leave MS Access determines the max recs. At a page.
Can you post basic sample of the Database without the ActiveX control?I think this err occur because of my version is Arabic. I notice that this err happen to me when distribute my apps on English versions of windows or office.
But the English version will work appropriate to Arabic version .
Also it is not clear how you are determining the "maximum number of records at a the previous page"Actually I leave MS Access determines the max recs. At a page.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks to all of you
nice information
nice information
ok
ASKER