Search results

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.

You need to describe the symptoms of this failure. Just to say it fails is not enough info to troubleshoot.

Another trick you can do debugging is change the Error Trapping setting (indicated by MajP in #26) programatically using... SetOption "Error Trapping", < values in 0, 1, or 2 > Or you can write a little routine that saves you typing, and can return the current setting, like... Public Enum...

Thanks, Pat. I do think I have one guy on a runtime, so I'll have to test it out first.

Agreed too, but I thought the thread might lead some to think it's a good idea to do in the first place. It works, it can get you across the finish-line, but its fragile.

A point worth making IMO in respect to working with control references in queries: • Don't put control references in queries. Control names and anything along the path that references them are ... • subject to change without notice, and • not subject to compiler scrutiny. You might as well put...

But you have to be in design view don't you? I assume with the UserForm you can do so while it's open, but I haven't checked it out yet. OK, got it, thanks.

Showing the UserForm toolbar did not enable addition of a UserForm for me, but I was able to export a UserForm.frm file from Excel, and import it directly into the Access IDE. This automatically added an MS Forms 2.0 reference, but the UserForm insert option still doesn't appear. I am...

What Option Private Module is to a standard module, so the Friend modifier is a procedure. A procedure can have three possible modifiers, Public (default), Private, and Friend. When declared as Friend, a procedure is only visible--and only available to execute--within the same project it is...

Yeah, when I developed that pattern I was pretty happy, because the pattern I was using before was... • Save and expose a temporary public reference to the owner/creator of cPopup • Execute the .OnAction callback • Get the .OnAction method to re-callback to the temp/public cPopup owner with...