Search results for query: *

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

Roy, I have Access 2002. Perhaps the problem has been corrected. That's good news. Robotron

Just for the next person that comes along trying to do this... I did some more research on this. I found out that a subform that uses data based on an ADO recordset is not updateable. Period. This is coming from Russell Sinclair who wrote "From Access to SQL Server". The workaround is to make...

I was thinking about this last nite. Would the recordset not be updateable because I am closing it in the code? All help is appreciated. Robotron

Ok Roy, I set the CursorType and LockType. Now I get the message 'This recordset is not updateable'. That confuses me because I am pulling records from only one table. Where should I look next? Robotron

Roy, the error does not occur on any line. I get the message when I try to edit the data displayed in the subform. PH, I do not want to do that because that would create more than one connection per user in the ldb file. I am using an existing ADO connection (cnn1) to get the records. I do this...