Search results

  1. N

    Report records Orderby code

    Sorry! It is my mistake.
  2. N

    Report records Orderby code

    If I orderby 3 fields like this With Me If Nz(!E, "9") = "1" Then .OrderBy = "C Asc, A Desc, B Desc" Else .OrderBy = "C Desc" End If .OrderByOnLoad = True End With the code not work...
  3. N

    Report records Orderby code

    Thank!!
  4. N

    Report records Orderby code

    it work! Thank!!
  5. N

    Report records Orderby code

    after move to Load event, when open report system warning no record!
  6. N

    Report records Orderby code

    Hi, I want to use the following code, to sort the records from a field value, but it not work! Please help to fix it! Private Sub Report_Open(Cancel As Integer) If Me.E = "1" Then DoCmd.SetOrderBy "C ASC, A DESC" Else DoCmd.SetOrderBy "C DESC," End If End Sub
  7. N

    Open different report in a from button, by different value in a table field

    Thank!!
  8. N

    Open different report in a from button, by different value in a table field

    For explame ... field value is "BOOK", open the report name is "BOOK" field value is "CAR", open the report name is "CAR"
  9. N

    Serial No with date

    Left hand side is the query result, but I need right hand side result...
  10. N

    Serial No with date

    Hi, I use your code in a query, but it seem not work...
  11. N

    Serial No with date

    Thanks! Let me try.
  12. N

    Serial No with date

    Can you give me some sample code?
  13. N

    Serial No with date

    Hi, How to auto add a Serial No with date in a form field, like the following sample format... N201911190001 N201911190002 N201911190003 N201911190004 N201911200001 N201911200002 N201911200003 N201911210001 N201911210002 the last four digital can reset everyday Thank !!
  14. N

    How to copy data from another form

    Thank you very much for help!
  15. N

    How to copy data from another form

    How can I open another form can copy two field data ? Please check the picture, Thank you so much!!
  16. N

    Run a query through a form button

    I think use a functon to do it is good, but I don't know how to do...
  17. N

    Run a query through a form button

    Hi, How to filter the query value when I click different button on the form, Please check the picture
  18. N

    Subform to requery Main form field

    Thanks for help!
  19. N

    Subform to requery Main form field

    Please check
  20. N

    Subform to requery Main form field

    One more thing want to ask you... before use the code "me.parent.recalc" in after update, when press the "enter key" it will go to the new record field, but now I need to press the key two time! How can I fix this?
Back
Top Bottom