Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172

    Question Unanswered: Ms Access Query Disapear

    I don't why it happens but somtimes on of my Query loose all his content.
    And my application gives me an error message that looks like that:
    At least on field is require.

    Anybody knows what is the cause of that plz tell me.

    -O

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    not without seeing the code, and the actual error message (as well as where the message is occurring)
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


  3. #3
    Join Date
    Nov 2006
    Location
    Quebec
    Posts
    172
    Here's the code that disapear.
    But this query use like 20 sub queries to get the data.

    Code:
    SELECT uq_INV.*, uq_PRODCROSS.*, 'A' AS tabtravcolors_LETTER, uq_SALESHISTORY.TOT, uq_SALESHISTORY.ASAT, uq_SALESHISTORY.MTD, uq_PRODHISTORY.TOT, uq_PRODHISTORY.ASAT, uq_PRODHISTORY.MTD, uq_STORES.REORD, uq_STORES.RESTOCK, '' AS REORD, '' AS SalProj, RIGHT(uq_INV.Item,2) AS iSIZE, uq_ALLOCATED.ALLOC, uq_STORESQTYSCROSS.*
    FROM (((((uq_INV LEFT JOIN uq_PRODCROSS ON (uq_INV.STYLE=uq_PRODCROSS.STYLE) AND (uq_INV.COLOR=uq_PRODCROSS.COLOR) AND (RIGHT(uq_INV.ITEM,2)=uq_PRODCROSS.SIZE)) LEFT JOIN uq_SALESHISTORY ON uq_INV.Item=uq_SALESHISTORY.ITEM) LEFT JOIN uq_PRODHISTORY ON uq_INV.Item=uq_PRODHISTORY.ITEM) LEFT JOIN uq_STORES ON uq_INV.Item=uq_STORES.ITEM) LEFT JOIN uq_ALLOCATED ON uq_INV.Item=uq_ALLOCATED.ITEM) LEFT JOIN uq_STORESQTYSCROSS ON uq_INV.Item=uq_STORESQTYSCROSS.FLAGBTQS
    ORDER BY uq_INV.Item;
    The message is occuring when I double click on my query or when I use it on my app.
    I don't have the exact error code because my Access is in french.
    You can have the error code running a query like this:
    Code:
    SELECT;
    Or running an empty query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •