Search results

  1. J

    Search (if not found: add) in a table on a subform

    Thank you! This is very useful. I have always wondered why in the world of MS access users, they like to create autonumber as the only key.
  2. J

    Search (if not found: add) in a table on a subform

    Hi MajP, Appreciate your reply and comments in this thread. I've learned quite a lot from poking inside your example file. One question that I can't get the answer is: how does the participants subform able to limit the input data to only one specific student only? In other words, it won't...
  3. J

    Solved Query with domain aggregate

    I have a simple table "InfoTable" with the following fields: "SetID", "Itemized", "Qty" Try to run a simple query that create to the following statement from the QBE: SELECT InfoTable.SetID, DSum("Qty","InfoTable","SetID=" & [SetID]) AS TotalQty FROM InfoTable; But it produces error: "The...
  4. J

    Query Question (Join)

    This is quite interesting point of view. The way the tables are designed with all the normalization effort and anyone without access background would have thought nothing about this autonumber as PK. I wonder if there is any reading that I can read further about the technique of creating a...
  5. J

    Query Question (Join)

    thanks for the advise and correction
  6. J

    Query Question (Join)

    Hi June, Do you have a recommendation of where should I read regarding building such complex Queries? Was it because of the table schema as well? I am trying to understand the thought processes that you can come up with such solution.. I have been looking at this for quite a while. so my...
  7. J

    Query Question (Join)

    I understand this part now by what it means with B data.
  8. J

    Query Question (Join)

    Thanks June! I've been looking around for this solution but not many documents or discussions talk about nested SQL in access. I've been pulling my hair out to use simply join statements
  9. J

    Query Question (Join)

    The data is all there, not sure what do you mean by B data. Since the data are all over multiple tables, I am trying to query the following records: - tbl_RecipeList.RecipeID, - tbl_IngredientList.IngredientName - tbl_MasterRecipe.Qty_Kg, even when the following records are null or empty...
  10. J

    Query Question (Join)

    Hi June7 and plog Thanks in Advance for your help. I have attached the databe scrubbed from all the confidential data.. Only Tables and the only Query left.. The SQL may have changed from my original posting since I have been playing around with the QDE and unable to get to the statement that...
  11. J

    Query Question (Join)

    I have tables with the following relationship: 1. tbl_RecipeList with recipeID as PK 2. tbl_MasterRecipe with recipeID as PK and ingredientID as PK 3. tbl_PriceList with ingredientID as PK 4. tbl_CostVersion with CostVersionID as PK and ingredientID as PK and costnumber as one of the field My...
  12. J

    Designing Forms Questions

    I got confused from this possibilities, and your ideas are very clear and concise. Thanks!
  13. J

    Designing Forms Questions

    Thanks for all the responses. What Micron said is what's on my mind. Reading from all the responses here, I think there won't be such distinct line. It maybe depends on the original intent of the application, and those itself can change as the application has been built. Maybe the analogy...
  14. J

    Designing Forms Questions

    Just wondering on how a good form is being created.. A bit confused to differentiate a form that will show the result of a query in the subform and how to differentiate a form that would allow edit or new record of the said subform. Looking at northwind databases, one can understand from the...
  15. J

    Solved Regular Expression to detect end of word

    Hi strive4peace! (just a note: I truly enjoy your youtube videos) Now, going to your question.. I am pretty sure you can. I haven't played with regex for quite a while now, but what you are looking for is \w+ should work in your case. Gasman linked to the website, I pasted your sample and it...
  16. J

    Hello World!

    Hoping to learn more of the beauty of MS Access here! (and making friends along the way) I am pretty much a newbie on Access. Have been looking at some videos over youtube this past month(particularly learnAccessbyCrystal and PC Learning Zone -by Rich). Used to learn SQL many years ago, but...
Top Bottom