Search results

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

And your final answer is... I see where your coming from. I think it can be done within the Access window though. Does anybody know a final conclusive answer or maybe even have an example for us to oggle at? An Access Compatible recursive relationship... one man's dream... another mans...

In conclusion...? Hey, just to let anyone know and see if the pooled knowledge is far superior to mine? Can anyone actually create a 1 to many relationship within one table?! I know the theory, tblheadings_1 etc but the fields with which to link just escape me.

I do, that's no problem- it's just the link between the two I can't figure... I join the SectionID to the ParentID of the table and the Schedule ID to the Schedule ID (because the primary table is two part PK), enforce ref.integrity, and apparently I am missing records in the adult table---- But...

Columbo would say... "Just one more thing"... and solve it! Likewise: Hi Pat (or anyone who may answer!) :) Thanks for the tip, although I do have a problem with the appropiate lines bit. I am having sever trouble with the ref. integrity part when I try to do this. To illustrate- this is the...

Thanks to your help Mile I can begin to implement this. I do wander if this one to many relationship within a table can be set up in access or shown in the relationships diagram, i'm very curious as to that the realtionship would look like! Thanks again- hey do you get paid for this?? You should!