Recent content by Robotron

Thanks. That works. Phil

Well, I actually want to delete them, not just filter them. Phil

Is there an easy way to delete rows which, when subtotaled, equal zero? Any help appreciated. Phil

Ok. That works. I am not sure why it works because it seems to me to be a bit redundant. Thanks for your help. Phil Edwards

Is that in the OnFormat or in the OnPrint event of the page footer? Here is an interesting bit of info: the OnFormat event occurs 5 times for a 4 page report. Here is the page and pages values: Page Pages 1 0 2 0 3 0 4 0 1 4 The OnPrint event occurs 1 time with the...

In the page footer of a report, I have the following controls: txtPage: ="Page " & [Page] & " of " & [Pages] lblDCApproval (a label) linDCApproval (a line for a signature) lblDate (a label) lblDate (a line for a date of signature) In the OnFormat and in the OnPrint events of the page footer, I...

Actually, the code was failing because after you return to the bookmark, it is necessary to move to the next record to continue the find. Thanks for taking a look at it though. Phil

There is not a 'NoMatch' in ADO. What else do you suggest? Phil

I am using the following code to recursively populate a treeview control. I modified it from the code found at MS's website. '================================================================== 'This procedure populates the TreeView control when the form opens...

This is discussed in the Knowledge Base article 295194 at support.microsoft.com. You will find the solution there. Robotron

Okay. My apologies on not being more descriptive. In the first table I have 25, 80, and 113130 for the Region, District and Account. Since there is no record in the tblDetail for 25, 80, and 113130 for the month '7' and the year '2004', those values should be returned but my current query is...

When I put the Month and Year criteria in is when I don't get the results I want. If I leave them out of the query, I get the proper results. How can I put the criteria on these two fields and still get correct results? Robotron

Ok... SELECT tblAccountMap.ParentRR, tblAccountMap.ParentDD, tblAccountMap.Account FROM tblAccountMap LEFT JOIN tblDetail ON (tblAccountMap.Account = tblDetail.Account) AND (tblAccountMap.ChildDD = tblDetail.District) AND (tblAccountMap.ChildRR = tblDetail.Region) WHERE (((tblDetail.Region) Is...

I have a type of query which finds unmatched records in a table. The problem is there is a month and year field in the other table which I have to put a criteria on for the latest month and year. If I take off the month and year criteria, I get the results I want and if I put them in, I do not...

Omega, Off the top of my head, I would say to have 3 command buttons to the side of the tree view control, "Add", "Delete" and "Edit". Delete and Edit both deal with the selected node. The "Add" button would require the 'parent' node to be selected and would add a child node to it. Robotron