Search results

HI, thanks for your replies. I am not sure I quite understand. I am not trying to make the report interactive...I don't want the parameter box to appear, if I did, then I would do what your suggesting... What I want to do is have a single line per customer on the report. The user enters the...

Hi, totally frustrated........ I have a report, it creates an invoice summary from a table called invoices. So, if I do an invoice run for the month of April the summary reports displays the customer name and basic details of the invoice raised. The report is based on the invoice table. I...

Hi Arnelgp, Thank you for the quick reply. I did try rs.movefirst as suggested by other threads and have just tried movelast. Both of them give the same error message...."Object doesn't support the method"... I am finding this really strange. This is what I do: Dim rsproducts as new...

Hi, I have a DB and make extensive use of public functions to perform various tasks. Using ADO I have a number of functions that open a recordset and return the associated recordset for subsequent processing....in some instances I can use msgbox rs.recordcount and it works as advertised, in...

HI Jdraw, Thanks for the quick response. It doesn't really give me what I need. It looks like it is just changing the value of one field based on another. The continuous form works perfectly well and does everything I need it to do. I want to have each textbox locked on entry to the form as it...

Hi, I have a continuous form displaying employee hours for each day. On entry the fields are locked so user has to press edit, mainly to prevent inadvertent changes. When edit is clicked, I set locked property to false and I want the color of the fields (textboxes) to change color to indicate...

HI Plog, Thanks for the reply. I have tried cross-tab queries but it is effectively the same as a pivot table in that it only allows summary (Aggregate) values such as Sum, Avg at the intersection, not just text. Lee

HI, I need to be able to create a report that has names as row headings and days as column headings. We are a childcare provider, I need to create a weekly register report. The report should have child names as row headings, days as column headings and at the intersection, should have the...

Thanks Jiri, that is a good set of tips Lee

ok, finally found a workable solution. Using the manual sum of invoice totals, I was then able to update the required form text boxes and all calculations worked properly. The last issue was event handlers interfereing with each other. As the onload and Onactivate handlers effectively had the...

Ok, so after a few more message boxs to extend debug mode, here is the state of play. The calculations within the onload handler now work and the correct amounts are calculated and end up in the right variables. The issue I am now facing is that the form control is not updating to the result of...

HI all, Ok, continuing saga. I decide to try and calculate the sum of invoice totals within the onload handler using me.recordset.movefirst do Until me.recordset.EOF = True IntTotal = intTotal + me.[Inv_total] me.recordset.movenext loop me.Recordset.movefirst I then used a msgbox to...

HI, Quick update. I replaced the onLoad handler and used the oncurrent handler but still the problem persists. I also have an onActivate handler that does exactly the same thing. I use onActivate because the user can navigate away from the invoices form to add a new payment and on returning...

HI Uncle Gizmo, The form is loaded when a user clicks a button on previous form and the two forms are linked by client ID. As suggested by JHB, I have placed the code in the OnCurrent event handler, but this does not seem to address the issue, I am just going to try that again to make sure...

HI, As my first post, please excuse me if this is in the wrong place or I get things wrong. I have a bound form to an invoices table. The form details all invoices raised, all payments made and an outstanding balance. The outstanding balance control is just a basic text box. On form load, I...