Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Access error message

Discussion in 'Information Technology' started by cdono, Oct 28, 2005.

  1. cdono

    cdono
    Expand Collapse
    Guest

    Hi. I've just had to reload Windows XP and consequently Office 2000.
    My Access database, which was working fine until this has developed an
    error message which reads: "Circular reference caused by alias 'Expr
    1000' in query definition's Select List". I get this everytime I open
    up the main table in the database. The choices for me are OK or Help.
    Clicking Help just gets a blank screen. Clicking OK gets the message
    again. Clicking OK for this second time allows me to edit the database
    table, which seems fine. What's it all about and how can I rectify it?


    --
    cdono
     
  2. Loading...


  3. David Lloyd

    David Lloyd
    Expand Collapse
    Guest

    The error message indicates that the source of the error is a query. One
    cause of this error message is if you use an alias that is also the name of
    a field in the underlying table. For example:

    SELECT CStr([LastName]) AS LastName
    FROM MyTable;

    I would look at your queries for a field aliased as "Expr 1000" and look to
    see how it is referenced in that field.

    --
    David Lloyd
    MCSD .NET
    http://LemingtonConsulting.com

    This response is supplied "as is" without any representations or warranties.


    "cdono" <cdono.1xky5u@news.officefrustration.com> wrote in message
    news:cdono.1xky5u@news.officefrustration.com...

    Hi. I've just had to reload Windows XP and consequently Office 2000.
    My Access database, which was working fine until this has developed an
    error message which reads: "Circular reference caused by alias 'Expr
    1000' in query definition's Select List". I get this everytime I open
    up the main table in the database. The choices for me are OK or Help.
    Clicking Help just gets a blank screen. Clicking OK gets the message
    again. Clicking OK for this second time allows me to edit the database
    table, which seems fine. What's it all about and how can I rectify it?


    --
    cdono
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    cdono <cdono.1xky5u@news.officefrustration.com> wrote:

    >
    >Hi. I've just had to reload Windows XP and consequently Office 2000.
    >My Access database, which was working fine until this has developed an
    >error message which reads: "Circular reference caused by alias 'Expr
    >1000' in query definition's Select List". I get this everytime I open
    >up the main table in the database. The choices for me are OK or Help.
    >Clicking Help just gets a blank screen. Clicking OK gets the message
    >again. Clicking OK for this second time allows me to edit the database
    >table, which seems fine. What's it all about and how can I rectify it?


    I suspect if you have a faulty query in a lookup field in that main
    table? Open the table in design view, click on the Lookup tab and
    click on each field down the table looking for a field with data in
    the Row Source field.

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page