Too many expressions in ORDER BY Clause

  • Thread starter Thread starter George Stevenson
  • Start date Start date
G

George Stevenson

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.
 
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.
Click to expand...

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]
 
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?
 
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?
Click to expand...

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]
 
Back
Top