General discussion

  • Creator
    Topic
  • #2298114

    Access 2000 VBA Question

    Locked

    by mra2 ·

    I have a report and I want to set several Form Properties. I can set all of the properties EXCEPT Orderby See my code below:

    Me.Label6.Caption = “New Clients-Holocaust Survivors (Numerical)”
    ‘Me.OrderBy [CLIENT_ID]
    ‘Me.OrderBy = “[CLIENT_ID]”
    Me.OrderByOn = True

    What am I doing wrong???

    Thanks,
    Alan

All Comments

  • Author
    Replies
    • #2742620

      Reply To: Access 2000 VBA Question

      by timfox ·

      In reply to Access 2000 VBA Question

      Me.Label6.Caption = “New Clients-Holocaust Survivors (Numerical)”
      Me.OrderBy = “CLIENT_ID”
      Me.OrderByOn = True

      What you’re actually doing is applying a string expression/value to the OrderBy property of the report’s OrderBy property – which is the name of the value (not the text box) that is being ordered.
      You could also use:
      Me.OrderBy = “CLIENT_ID ASC” (defaulted to ascending anyway)
      or
      Me.OrderBy = “CLIENT_ID DESC”

    • #2744562

      Reply To: Access 2000 VBA Question

      by mra2 ·

      In reply to Access 2000 VBA Question

      This question was closed by the author

Viewing 1 reply thread