Recent content by MarkK

IMO, a far more robust solution looks like... Sub DoInsert() Const SQL_INSERT = _ "INSERT INTO images " & _ "( Genus, SpeciesEpithet, [Image], Collection, Author, sub, infrafamily ) " & _ "SELECT A.Genus, A.SpeciesEpithet, A.[image], 'Collier', 'Barry Collier', "...

My 2c is get the employee to provide a name, and then present--as a subform--the correct UI for the active task for that employee for that time period. Then each UI element is completely focused on its own responsibility and everything gets way simpler. • The MainForm is responsible for 1)...

Here's a quick sample of how some classes might work together to do stuff...

No, this is more a Service Locator pattern, not a factory. A factory is more under-the-hood, and would not have project-global exposure. The intent of a provider or service locator is to make resources more easily available to other code.

You can write a 'provider' class that constructs and exposes other classes. Imagine you have a cMyClassXProvider which you expose from a standard module as a project-global property like... Public Property Get cxp as cMyClassXProvider Static prv as New cMyClassXProvider set cxp = prv...

Check out the date on the post you responded to. More than a decade ago.

• Make sure the scanner is plugged in. • If you have a flatbed scanner, make sure the text you want scan is facing the glass. :ROFLMAO:

Maybe, as a starting point, describe where you are stuck. Otherwise we have to guess what you might find useful.

The HUGE advantage of calculating inventory? If you can calculate it for today, you can also calculate it for next Tuesday. Say right now you are out of ProductA, but you have a Purchase Order for ProductA scheduled to arrive next Monday. A customer calls to place an order for ProductA to...

Flat-Rate is just a product type distinction. You are elevating it to entity status by naming tables after it. You need to be able to quote any quantity. A Quote may contain • 2 (Flat-Rate) Pressure Tests @ $300ea • 3 (Labour) Hours shop time @ $75ea • 12 (Part) 3" x 1/2" Bolt @ $0.75ea I...

IMO, exposing a list of globals like that in a standard module is a very serious design flaw. Like, who produces data for each of those, and who are the consumers? It's like a crime scene. Nothing can be known for certain, and everyone, to be ruled out as a suspect, has to be tirelessly...

What is a "Task?" This object figures prominently in your prose, but not in your schema. Is a quote comprised of many tasks? Is each task, as a member of a quote, subject to different discounts?

What if you coerce the expression TempVars!CarbLimit to CSng(TempVars!CarbLimit)? Does that change anything?

to see the difference on your development machine, just rename your accdb to accdr, and it will open as a runtime version.

If you handle CommandBarButton.Click event, you don't need .OnAction. If you handle Click, your execution remains within your class structure. If you use .OnAction you must call out to a standard module, and then you've lost encapsulation, and to bring execution back to where it started is WAY...