Too many expressions in ORDER BY Clause

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

George Stevenson - 31 Jul 2005 21:30 GMT

I am getting an error message "Too many expressions in ORDER BY Clause" on
several different macros that I am trying to execute that just open a form
with a Query and display some records. What is odd about this is that I
haven't made any changes to any code or forms. When I execute the
specified Query in the Query tab, they work fine, no error message. The
error message only appears when its in the macro connected with the form.

Can anyone make some suggestions about where to start looking.

Reply to this Message

John Vinson - 31 Jul 2005 21:54 GMT

>I am getting an error message "Too many expressions in ORDER BY Clause" on
>several different macros that I am trying to execute that just open a form
[quoted text clipped - 4 lines]
>
>Can anyone make some suggestions about where to start looking.

Try opening the Form in design view and checking (or blanking out) its
OrderBy property.

Perhaps you could post the text of the Macro - you can see it; we
cannot.

John W. Vinson[MVP]

Reply to this Message

George Stevenson - 31 Jul 2005 22:37 GMT

That did the trick, thanks.

I have never changed the Order By property. Does that property get
modified when a query is run against the form from the Macro?

> >I am getting an error message "Too many expressions in ORDER BY Clause" on
> >several different macros that I am trying to execute that just open a form
[quoted text clipped - 12 lines]
>
> John W. Vinson[MVP]

Reply to this Message

John Vinson - 01 Aug 2005 00:13 GMT

>That did the trick, thanks.
>
> I have never changed the Order By property. Does that property get
>modified when a query is run against the form from the Macro?

I don't use Macros, and I'm not certain! I believe it does get changed
if someone opens the form and uses the menu options (or, if it's a
datasheet form, clicks on the column headers) to change the sorting,
and then saves the form.

John W. Vinson[MVP]

Reply to this Message