Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Access 2000 VBA Question

Locked

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

Topic

Reply To: Access 2000 VBA Question

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”

Reply To: Access 2000 VBA Question

In reply to Reply To: Access 2000 VBA Question

Thanks for your quick & helpful response! Alan

Reply To: Access 2000 VBA Question

In reply to Access 2000 VBA Question

This question was closed by the author

[Author]

Replies