Re: Can not open my form or query - invalid argument

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 13:00:24 -0700

On Thu, 20 Jan 2005 10:19:04 -0800, Bessie
<Bessie@discussions.microsoft.com> wrote:

>Hello,
>
>I can not open my Form or Query. I got an error message 3001 Invalid
>argument. What can I do to fix this problem. I was in the form - then an
>errors # popup in every field. I did a compact and repair, and rebooted my
>system, and still can not open the form or query.
>
>This database is on the server.
>
>Bessie

Fix the error in the query. It's got an invalid argument, probably to
some function call.

If you would like help solving the problem, please remember that we
are not telepathic and we cannot see your computer screen. It would
help if you opened the query in SQL view and posted the SQL text here.

                  John W. Vinson[MVP]

Relevant Pages

  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Making dynamic table sortable
    ... The flip side of which results is websites filled with SQL injections ... Which is likely to be invalid SQL. ... error conditions. ... rather than the query ...
    (comp.lang.php)
  • RE: 6gw1u4iu
    ... We provided a fix for you that will be available in IDW14. ... SQL Server Data Mining ... OLEDB source (with the DMX prection query) and throw the result into a SQL ... the package fails with the error in the attached ...
    (microsoft.public.sqlserver.datamining)
  • Re: Strange Prediction behavior
    ... We provided a fix for you that will be available in IDW14. ... SQL Server Data Mining ... OLEDB source (with the DMX prection query) and throw the result into a SQL ... the package fails with the error in the attached ...
    (microsoft.public.sqlserver.datamining)
  • Re: Too many results error
    ... "Simon Sabin" wrote: ... SQL Server MVP ... The query I used was as follows (generic field / table placeholder ... This seems to be contrary to the fix, ...
    (microsoft.public.sqlserver.fulltext)