Re: Too many expressions in ORDER BY Clause

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



On Sun, 31 Jul 2005 16:30:33 -0400, "George Stevenson"
<gs50NOSPARM@pcipropertiesDOTcom> wrote:

>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.
>

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]
.



Relevant Pages

  • Re: OutputTo to Excel question
    ... I can't help you with the macro error message as I don't use macros. ... the result from a query. ... Save a query that pulls the same data as the report. ...
    (microsoft.public.access.macros)
  • Re: Copy form fields to related table
    ... figure a macro would be the best approach to solve this problem ... You should be able to do it with a simple append query. ... Now I googled this error message and poked around on the web. ... the folder located in my trusted locations, and the sql server copy is ...
    (microsoft.public.access.macros)
  • RE: filtering table data on a form with combo boxes
    ... get this error message "Microsoft Office Access can't find the macro 'Me'. ... The macro (or its macro group doesn't exist, or the macro is new but hasn't ... Create the subform from the 2nd query and show "all" records in the datasheet ...
    (microsoft.public.access.gettingstarted)
  • RE: Excel query error
    ... Try starting excel with macros disable and then set up a new ... This will prove or disprove that a macro is causing the problem. ... I get an error message whenever I open a file that has data queried from an ... It also occurs every time I create a new query as well. ...
    (microsoft.public.excel.programming)
  • Re: IIf dilemma
    ... John, Here is the SQL..... ... The error message I received is......"You tried to execute a query that did ...
    (microsoft.public.access.queries)