Search results for query: *

Hi Gus I have written validation rules for the balancing of the total debits and credits and it works OK, just thought I could open up the form and have 2 blank lines just to be sure the user understands 2 entries are required. It won't matter if it can't be done. Thanks for your help Steve

Hi Gus Sorry the question was a bit vague. The subform is to be used for data entry and the user must enter two records for each entry (is a journal entry form, line = debits, line 2 = credits). I know when they enter the 1st line the next line will automatically appear but want to make it...

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

Thanks very much. I managed to get it working

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 just figured it out. Was #@x*** simply have been at this for 6 hours as well. Cheers

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...

Dan Much appreciated will try that Steve

Thanks for that guys. Will give that a go. Daniel not sure how the Me.Recalc works could you explain a bit more please. Cheers Steve

Not sure if I'm understanding this correct but the checkbox needs to be enabled before the Onclick event can be used I think it should read If IsNull(Me![Route_To]) Then Me.Check158.Enabled = False Else:Me.Check158.Enabled = True Me.Check158.SetFocus Endif This would be placed in the...

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...

Dan Thanks for that will give that a go. Do you know where I can get samples of databases that have been developed for ledgers e.g Nominal Ledger, Sales Ledger etc? Thanks

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...