Search results

  1. Y

    Running Total Based on Entry No

    Hi everyone, I have little confusion about running total, as i have search online many are showing Sql view and not design view for running total that makes it more complicated. SELECT QryTransactions.TransactionID, QryTransactions.TransactionDate, QryTransactions.EntryNo...
  2. Y

    iif with NZ and Sum in Query Builder

    Hi everyone, I am trying to do some calculated expression in my query with multiple combination of (iif,Sum,NZ) Balance...
  3. Y

    Update fields on tab control after combo box event

    Hi everyone, I have a form for contacts where i have two issues. Issue # 01 I have tblContacts and it has large number of fields which i have divided on frmContactsEntry with tab controls and assign unbound combo box to filter the specific record on form the combo box is PK in tblContacts...
  4. Y

    Args (2) to pass data to unbound combo boxes

    Hi everyone, I hope all safe and healthy during this pandemic. I have following code on form No 1 (Command button) Option Compare Database Option Explicit Private Sub BtnOpen_Click() If Me.EntryType = "Bank Transfer" Then DoCmd.OpenForm "frmBankTransferEntry", acNormal, , , acFormAdd...
Top Bottom