You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser.
-
E
GaP42 i definitely don't want to reset the records in the table to zero. I just need a counter which can be reset to zero without...
-
E
Emma - your form has a recordsource, to which you may be applying a filter to display the required records. The CLEAR button, as...
-
E
My VBA is not good Gasman. I tried the code below but it just turns red as soon as i type it
DSum ( Weight, tbl_MainRecords)
-
E
Use Dsum() with the relevant criteria.
https://support.microsoft.com/en-gb/office/dsum-function-08f8450e-3bf6-45e2-936f-386056e61a32
-
E
Ok i didn't know that gasman. How do i use the DSum() event ?......my VBA is atrocious. Thanks
-
E
You could use Dsum() in the Current even of the form.
The you could set it to zero with your button. Probbaly no need fo a clear button...
-
E
Hi....no i'm not initiating a new set of records i simply want to reset the counter. What code would i need to change to in the OnClick...
-
E
The total weight as Sum(Weight]) is a calculated value summing the weights entered for the records in question. The Clear button would...
-
E
Hi Everyone,
I have a data entry form where one of the fields where info is entered is called Weight. I need to have a text box on...