Recent content by CadMonkey

B E A U tiful!

You know I think this is impossible! I may have to apply lateral thinking.... :( :eek: :confused:

Hi, I wander if anyone can help with this problem- I've found no solution thus far. This post is linked to http://www.access-programmers.co.uk/forums/showthread.php?t=70645 the issue is as follows: I calculate a summary report from an original report; the data is entered into a table from the...

Hi! I wander if any of you pro's can help a semi- frustrated monkey? But that's not the big question. The big question is: IF one selects multiple records in a datasheet, so say 6 or 7 are higlighted. Could one use the selection set to loop through every query in that code? Basically I need...

Hi! I wander if any of you pro's can help a semi- frustrated monkey? But that's not the big question. The big question is: IF on selects multiple records in a datasheet, so say 6 or 7 are higlighted. Could one use the selection set to loop through every query in that code? Basically I need...

Or is this impossible??!

Surely this must be a fundamental problem, has anyone resolved it? I have a report, which using the MS Support method I create a TOC (Table of contents) by populating a table. However the TOC table doen't populate unless I view every single page of the report and it get's it's chance to format...

You Geniui, you've just saved me hours of time waiting for report to load, just by saving the select statement for data source of report as query and then referencing that, even with calculated *must have* fields! Thankyou!

Hands up, I'm cheating... the story goes as this. I couldn't work out this union query stuff to show all headers and items even headers where no items are stored uder (if you catch my drift). Therefore upon viewing report I crated a null record under each header so that it would show then...

Thankyou RichO but even considering this, the code itself doesn't work- the resultant size of text boxes remain the same. Anyone else any ideas??

Is there any way of resizing a text box from code so that you can handle the height of a textbox for different values? I.E. (But this doesn't change the height at all it seems!!) Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) if [text75] = "HellO" then...

Hi, I have a report with two levels of nested subreports. On the lowest level subreport I have some prices. I need to total these prices right at the end without subtotalling the subreports. Have tried this in main report footer with textbox...

Top Dog, thanku!

Columbo again... Just one more thing... I think it is impossible to have a multipart key in a recursive table and have this same relationship??

Sorted. Thankyou very much! This is an excellent simple illustraion of using the recursive functions