Search results

  1. izen

    Unmatch query

    Thanks guys another question I would like to change the color of text on the feilds that are different i just want it is more easy to find the different one can we do that ? cheers,
  2. izen

    Unmatch query

    alright I did it thanks :)
  3. izen

    Unmatch query

    Ohh yes thanks I got it If I like to find all unmatch fields except ProductID Can i just put critirua in the other fields some thing like <>[ProductName], <><Quantity> Anyway I did do it but It doesnt work do u have any suggestion? thanks
  4. izen

    Unmatch query

    Hi everyone I have a problem about unmatch query wizard I have 2 quries that I want to retrive the records that are different value I used the unmatch wizard but it doesnt list any record my queries are QueryA ProductID ProductName Quantity Unit Cost 1 AAA 1 KG $500 2 BBB 1 Kg $600...
  5. izen

    Recipe Design

    Hi john I have a small problem after I added the recipe to the ingredient table. the focus goes back to the first recipe. for example I have 5 recipes in the recipe table After I added 3th recipe in ingredient table (click IsIgredient checklist) after it was added the focus goes back to the...
  6. izen

    Recipe Design

    Hi John I cannot click Isingredient checkbox on Recipe form It doesnt repond why we have to lock and unenable checkbox ? cheers, Zen
  7. izen

    Recipe Design

    Sorry that I responed your post very late cause my internet didnt work last few day Thank you so much John !!! I will study your sample database :) :) Happy easter and a heap of thanks again
  8. izen

    Recipe Design

    thank you john I am working on it However, do u have a sample database that is similar with this circumstance for me to study ? if not thats fine thank you very much
  9. izen

    Recipe Design

    thank you again John!! do u mind that I am breaking down in small step? "So you enter Napoli sauce into your ingredients table" (Do I have to open ingredient form and actualluy add RecipeID 25, IngredientName Napoli sauce, the Qauntily, the CostUnit manually?) IngredientID (PK) = can be...
  10. izen

    Recipe Design

    thank you for your suggestion Unfortunately I dont still understand could u pls explain abit more details pls? cheers,
  11. izen

    Recipe Design

    Hi there! I have a problem about Recipe database. My database has 3 main tables <Recipe table > RecipeID (PK) RecipeName FoodCategoryID PortionYield PercentFoodCost Instructions Source Picture <Ingredient table > IngredientID (PK) IngredientName IngredientCategoryID Quantity Unit Cost...
Back
Top Bottom