Recent content by BNoble

I came onto this report well after it was built Unfortunately, I wasn't around when this database and reporting structure was orignally designed. So I kinda had to work with what was there. There are approximately 35 reports with this same structure...so I had to come up with something that...

Correction....It's a Text Box Ooops. Yup it's not a text field, it's a text box... So I have a text box on the report that is populated with a 1....then it is set as a running sum. Oh and I did find a solution....I'm still not happy with it but here it is. Here's the code: Private Sub...

Come on folks ..... anyone ... Ok well, I'm getting ready to go through all these reports and slip the fix that I have posted earlier in this thread. I know that there has to be a better way....I just know it. Is there anyone out there that is doing what I am doing with a better approach?

Nope your not asking too much at all In the Report GUI, there is an icon, that brings up a sorting and grouping dialog. You can create as many groups as you choose by whatever criterion you want sorted any way your heart desires. In addition, for each group, it can have it's own header, or...

Hmmm...no help yet...well here's what I got I found a fix around this...and it's gonna be a major pain, unless I can find something else. I stuck a label on the report in the detail field that keeps track of what has been passed and what hasn't that way when I go to print from print preview it...

Sounds like the sequence is off - Circular Ref Whenever calling a sub....The main has to be settled.... Having a Main that relies on a sub's data will never fly because it doesn't know where to look. Sometimes, it will pop the parameter box, and you can ignore it and it will still populate...

Update Ok, Here's where I'm at on this. I got with one of our developers, and described the problem. He told me the logic and code sounds good. So that leads me to believe that this is an Access Tweaky Weird thingee..... With that in mind I performed a compact/ Repair ...again.... The DB...

Still working on it As I continue to search etc... I figured I would add some more information. It's not really clearing the data so to speak just setting all the detail to not visible. This is as opposed to when rendered in print preview where the report is making only those detail records...

You may want to Create a front-end You may want to give each user their own front-end...with links back to the shared data. There are a plethora of reasons to do this, going forward you won't regret doing so.

I searched the forums before posting this, and found some posts, and answers that came close but did not quite do it. With that in mind, here's the problem I have. I have a report that has a text field [Rank] in it with a value =1. It is set up as a running sum, ultimately I use it to filter...