Search results for query: *

I have tried a grouping query (QryRTUgrouped)that is based on the table which returns correct number, but my problem is that the count is not based on my filtered data in the form. I have put a textbox at report header with control source: =DCount("RTU_GROUP_NO";"QryRTUgrouped") but this...

I am using this code today to return the total records in page header which works fine. The problem I have is that some of my signals are grouped and I want Access to count the group and not all signals in the group. Please, let me know if I misunderstood you. Thanks Stefan

I have a form with a subform. At the form I have checkboxes and comboboxes that filters the data in the subform (query based on at table). At the report I count all the records that has been filtered, which is working fine, but some of the records are grouped together and I only want to count...

Thanks!!!

I have a form with a subform. When form is opened it always starts with the first record. How do I get the form to display the last record when opened? As the form contains monthly bills I have to step thrue all months to come to the last month everytime I will add a month. Regards Stefan

I have a mainform and a subform where I store information about monthly bills and salary of two users. Form holds information about date, month and salary. Subform holds information about monthly bills. How can I lock/ unlock the bills of the month when done with a month ? I have tried to add a...

YES! It worked!!!! First it didn´t but when I changed from "," to ";" (as described in expression builder)it worked. Thanks again!!! :-D:-D:-D

TheAceMan1... Are the codes to be pasted in mainform? I will try it when I get back from work. Thanks a lot!:-)

Hi AceMan ! I am sorry to confuse you but I tried to ask the question by translating my problem from swedish to english. To be able to explain my problem I just wrote the lineitems as articles and explained the db as a invoice db. Actually my database is a db where I put in all my bills. Each...

Hi GingerR! Yes, there is a price in every row and no one is blank/null. I made a query with the price column and sum function, and I got a correct figure.

I changed the function to =Sum([Price]*1) and then I get a correct value in the textbox. But when I close and open the subform again it´s an #Error again. When I add *1 again its still an error, but if I change to a new number, i.e *2 I get a correct value multiplied with 2. Very strange?! Any...

Yes this is correct, Table Name for main form = tblInvoices Table Name for sub form = tbllineitems Primary key for main form = InvoiceID Primary key for sub form = RowID Relationships - Field InvoiceID in tblInvoices is related "one to many" to field InvoiceID in table tbllineitem. Main form...

Thanks a lot you both for taking your time for helping me. I tried to use the calculated field and it calculates correctly, but I can not get the textbox in the footer to sum the field of some strange reason (#Error). Even the Sum of the price that worked fine before just give me an #Error. I...

I have made a invoiceform (main form) with a subform where I fill in articles bought by customer. Each article contains of Item#,Article,Quantity, description and price. Now I want to sum the total of all lineitems (articles). I use the Sum() function in the subform and a reference in the...