Search results

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

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

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