Recent content by Charlie8585

  1. C

    Trigger Access macro when live table changes?

    All. Excellent, concise responses that answer my question. Thank you. By 'live' table I meant local table(s) linked to DBMS (MySQL, externally hosted). Of course auto-emails (subscription confirmations, order cancellations) will eventually be handled on that platform. However this won't be...
  2. C

    Trigger Access macro when live table changes?

    All, I have a couple of live tables in an MS Access file linked to an online SQL db. I need to have Access automatically send an email (via Outlook) when that table changes. E.g. if a customer creates a subscription on website then customer_subscription table would have a new entry. I'd like...
  3. C

    Solved Best practice: filter on query or on form?

    Noted. Indeed it's latter case. Will follow your advice.
  4. C

    Solved Best practice: filter on query or on form?

    Simple question. I have a query that calculates nutritional values of smoothies based on their ingredients. Lots of calculated queries using (sadly unavoidable) queries on queries. This query is only used in a single form (as form's record source). Is it best practice to: A - leave query itself...
  5. C

    Solved Expand multiple identical items

    This worked perfectly! Lovely solution, thank you @Pat Hartman . Thank you @CJ_London . Pat's solution is fine for me for now as currently only sending out a maximum of 7 x smoothie mixes (they can be all same flavour or all different or in between) so I don't need usysCounter table to be any...
  6. C

    Solved Expand multiple identical items

    Yes it should! Error in my mockup, now corrected, thank you!
  7. C

    Solved Expand multiple identical items

    So I'm building report with recordset based on this query for single order: Problem is I need to print 6 x stickers so need 6 x report entries - i.e. need to expand that NumberOfSmoothies field. Is there functionality in Access reports to do this? Or do I have to adjust query/recordset so it...
  8. C

    Single master table or parent/child - best practice?

    Thank you all for this. Excellent synopsis. Have read all replies in detail. Same place - No. Different prices - Yes. Good suggestion re expiration - will implement. Final recipe goes to normal consumers! However it's a bit different because customer can go online & make their own recipes (or...
  9. C

    Single master table or parent/child - best practice?

    Right - that answers that one! And I suppose that's simply a tblIngredientPrices with field IngredientID and other pricing fields (PricePer100g, retailer etc.) linked one-to-one to tblIngredients on IngredientID?
  10. C

    Single master table or parent/child - best practice?

    I'm fairly new to databases. I'm preparing to start a little (experimental) company packing frozen smoothie mix packs for people. Constructing an Access Database to keep track of recipes & nutritional info. Here's problem I'm not sure on. I have 'master' table tblIngredients containing...
Top Bottom