Search results

  1. C

    Northwind 2.0 fresh template startup errors on Access 365

    Bizarre issue. I'm trying to create a new Northwind 2.0 database (File > New > Northwind 2.0 dev edition (or Starter edition - same behaviour). As soon as it loads & I hit "Enable content", the Public Function Startup() throws a Compile Error with variable OneTimeProcessing not defined. If I get...
  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?

    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...
  4. 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...
  5. 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...
Back
Top Bottom