Search results

  1. N

    dlookup in query using month/year as criteria

    Hello, You may try the following FRate: Dlookup("Rate", "ActFuel", "month(FuelDate) = (Month([LoadDate]) AND year([LoadDate])=Year([LoadDate])") Rgds
  2. N

    Default value as lookup depending on another field

    Hello, The above process I believe can be achieved by creating a lookup field in the transaction table, where the Analystid is substitued for Analyst Name. Rgds
  3. N

    Dlookup with Multiple Criteria question

    Hello, You could try DLookup("[ConfirmedLoad]", "[qryDriver4a2]", "[DeliveryDate]=datevalue('" & Me.Controls("cboAllocationDate").Value & "') and [StateID]='" & Trim(Nz(Me.Controls("txtState").Value)) & "'") Rgds
  4. N

    Table headers to access listbox vba

    Hello, To transfer the contents of the selected rows of one list box to another list box on click of a button object we may use the following code List1- The list containing items list2- The list to whcih we wish to transfer these items to command5- button on click of which selected items...
  5. N

    Table headers to access listbox vba

    Hello, To me it appears that on click of a button you wish to poulate a list box with the name of fields of particular table. In case, this is what you are looking for then you may provide the following code on the clisk event of the button object Let the name of the ListBox be list1 name of...
  6. N

    Need help with Nz() or IIf() to get a zero value

    In case you wish to display 0 when the RecordSource property of a form has no records. You may try the following steps Let us say that the name of Textbox that displays the sum function is Text1. You may add the following code in the Form Open event if me.recordsetclone.recordcount=0 Then...
Back
Top Bottom