Search results

try with this put these on open form event: Me.AllowAdditions = False '(yor cant make new data) Me.AllowDeletions = False '(you cant delete records) Me.AllowEdits = False '(you cant make changes) this is usefull only for viewing in other hand: Me.AllowAdditions = True (can make new data)...

follow the link: http://www.mvps.org/access/forms/frm0023.htm

I dont now formula for calculating Credit or Debit. you can create Crosstab query with wizard if you click on new query. Even you can create a continous form based on your existing query (egg. create textbox named txtDebit, control source is Debit form query, create textbox named txtCredit...

In query you must create calculated fields (example balance1:Credit-Debit) and then you can create crosstabquery to show columns like balanced sheet. Or you can do this in continous forms (choose continous forms in form properties) and run calculation for Balance (on form put text fields for...

Is is possible to use combox to find records and move forms to selected records or add new data with notinlist event.