Search results

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

Not to your problem, but I would distribute the .accde. If a user only has an Access runtime version installed, then .accde, .accdb, .accdr, .accda it doesn't matter, a runtime runs all files as runtime files. But if a user has the full version of Access, and you distribute an .accdr, then you...

We have a Zebra ZT-410 and we had to add a custom paper size to the print server, and then select that paper size, but I forget where, maybe in the printer driver, maybe in the Page Setup dialog for the printer. Also, if your 4-page screenshot is a print preview, obviously the paper size is wrong.

Is the Access runtime running on a different machine? Does the different machine have different regional settings for date formats? Can you enter a date directly that works? On the machine that works, rename the working file extension to .accdr. Run it. It will open in runtime mode. Does it work?

What data type is "Status" declared as? What data type does UnpauseSQL return? Are you sure UnpauseSQL returns a value? I routinely write functions and then forget to return the value. The upshot is: it's possible that Status, due to some other factor, will never evaluate to True. Then it...

Seems sloppy how? Like, since we can't see--and you haven't described--the specific sloppiness in question, how do we suggest useful de-slopification ideas? Describe what "sloppy" means to you in greater detail.