Search results for query: *

Could someone please tell me how I can get a subform on a main form to open with a minimum of 2 rows showing. Still need the subform to add more lines after the 1st two rows have been completed. Many thanks

Really need help on this one have went through previous solutions but can't seem to find one I need. I have two currency fields [AnnualPrem] and [DepositPrem] the on exit event for [AnnualPrem] is Me![DepositPrem] = Me[AnnualPrem] *1.1 However I need to round the [DepositPrem] to the nearest...

Sorry this is a bit complex to explain. I have the following tables. TbltNtype = [Nttype],[ntdesc],[ntclass] TblNsubt =[nstype],[nsubt],[nsdesc] TblNAct = [naact],[natype],[nasub],[nadesc] TblNtran = [ntact],[ntdebit],[ntcredit] The type,subtype and ac fields of the subordinate...

Have tried everything but can't seem to get this to work I have a subform with two fields = debits and credits there is two calcualted controls on the subform footer totaling debits and credits (called TotalCredits and TotalDebits. On the main form is a save button. Since the debits and credits...

I need to develop a form that processes journal entry transactions. The subform contains two columns debits & credits but both these columns should only write to a field called nt_amount in the table. I have based the form on a query and given nt_amount the aliases of debit & credit. However...