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...
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...
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...
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...
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...
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...
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?
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...