Search results

What a legend, didnt even know about this funtion. Now will be using it all the time Cheers Ears Alex

As you can see above, i have a form, with the subform which is the table 'Members' The field 'printw' is the field i want to clear (un tick all the boxes) using command button 4, but just dont know how or what VBA/macro to use. Many Thanks Alex

Thank you bith for the reply. I am not to worried about long term data at the moment. And some of the field in the query do use 'Group by' but there is no other Total that would do the job so am stumped for what to do to get this to work Alex

Thanks for the quick reply. That solution is exactly what i was looking for apart from i get an error saying the Recordset is not Updateable, i think that is because it is a form based on a query. How would i get this to work? Alex

I have a form as you can see above. The TotalAmountPaid is a field in a table. When the member pays in some more money they type it in the AmountPaid text box. I would like to be able to then add the AmountPaid to the TotalAmountPaid at the press of a button. How would i do this (what code...

Cheers, have had a look at that database, is very well done but dont think my Access skill is quite that gd. Any Alternatives? Thanks Again

Thank you again. i have got the relationships set up now and a Date form with the members details in a subform. The only problem is to add a memeber u have type thier member id. Would it be possible to have a list of memebrs on each date and a yes/no field to record whether they have attended...

Hi, thanks for your quick reply. I have had a look at those sites but am still struggling to set it up to look like an attendance registers. What fields and relationships would you use? Thanks Alex

Hi, i have set up an attendance register system and want to work out the number of sessions each memeber has attended (total ticks in one row), i have managed to calculate the number of members in each session but not the other way round. Alex