Search results

  1. L

    For Each Record in Table ....?

    Hi, I did it like this, but thanks for reply - it helped :) Dim db As DAO.Database Dim rst As DAO.Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("tbl_GL_LINES_ALL") Do While Not rst.EOF If rst!GL_JOURNAL_ID = Forms!frm_GL_journals.GL_JOURNAL_ID.Value Then db.Execute...
  2. L

    For Each Record in Table ....?

    There is no problem about getting rate I have table - GL_LINES_ALL which have LINE_ID, AMOUNT_CUR and AMOUNT_LOC In FORM -frm_LINES_ALL is only data about LINE_ID and CUR_RATE after pressing button I need that based on added information in Form script is updating all AMOUNT_LOC with AMOUNT_CUR...
  3. L

    For Each Record in Table ....?

    Yes I agree, that in this case it would work. But if ( ok this I will need in future) - I will need change GL_LINES_AMOUNT based on the same record, but depending on GL_LINE_CUR_AMOUNT and CUR_RATE added in form. For example: Update GL_LINES_AMOUNT Where LINE_ID = Me.frm_LINES_ALL.Value with...
  4. L

    For Each Record in Table ....?

    Hi, I never used this function in VBA because I am bit confused how to use it correct. So, I have table GL_LINES with Colums LINE ID, bla bla bla, GL_LINE_FLAG I want that after click on button GL_LINE_FLAG column lines are updated to "1" with specific LINE_ID. I try use For Each //In but...
  5. L

    Dlookup + Date

    Hi, I tried a lot of times, search over internet... but no luck. Table: tbl_CUR_RATES [...] CUR_ID - Num CUR_DATE - date/time Form: frm_RATES with button which get CUR_ID on specific date: 1. frm_CUR_DATE 2. frm_CUR_ID On click for that button is such code in vba... Me.frm_CUR_ID =...
Back
Top Bottom