Re: Run-time error '2001'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

To rule out a problem with the name of the query, I copied it and gave it a
simple name. It was when I clicked on the query to run it that I realized
this query asks for a parameter. Mystery solved. I appreciate your response
(which led to my discovery).

Thank you,
Judy

"Douglas J. Steele" wrote:

> Check to make sure you haven't mistyped the name of the query. (Yeah, the
> error message is a little misleading, isn't it!)
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
>
>
>
> "Judy Ward" <JudyWard@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:42504611-FB99-4994-8ECC-08A6298F875B@xxxxxxxxxxxxxxxx
> >I am trying to use the DCount function:
> >
> > If DCount("*", "qryName") = 0 Then
> > MsgBox "Query returns no records"
> > End If
> >
> > It works just great for several queries, but when I try to use a
> > particular
> > query I get:
> > Run-time error '2001':
> > You canceled the previous operation
> >
> > Does anyone have any idea why?
> > Thank you, Judy
>
>
>
.

Relevant Pages

  • RE: Import Access query to Excel 2007
    ... The query wil figure out where to put ... Field Headers Grayed- Out ... Judy L ... you wanted in Excel 2003 and found the solution. ...
    (microsoft.public.excel.misc)
  • Re: Getting duplicate names inquery, how do i eliminate?
    ... But it's possible in a query, like this (assumes table Judy, ... >I did a query with name, employee number, and multiple id numbers. ... >employee name field is showing duplicate names and i only want it show once ...
    (microsoft.public.access.gettingstarted)
  • RE: Import Access query to Excel 2007
    ... How do you do that in an Access 2007 query. ... Judy L ... .PreserveFormatting = True ... .AdjustColumnWidth = True ...
    (microsoft.public.excel.misc)
  • Re: How do I merge two tables containing different fields
    ... Teako wrote: ... Judy, Create a new query, and select the tables in question. ... click on the design button to add or ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Record search error
    ... Doug Steele, Microsoft Access MVP ... I assume that the form is open when you're running the query. ... Date is not a good name for a field or a control since it is ... Don't confuse a Control Source with a Row Source. ...
    (microsoft.public.access.forms)