Search results

When you create an entity in a database you should add a single row to a single table. If you want to add a Contact, your SQL should be "SELECT * FROM Contacts." To add one contact, you add one row. Notice that the schema for a contact contains no category data. A Contact entity has zero...

If your report module supports class-global variables, these are not automatically reset between PrintPreview and Print. If, for instance, you show and hide Detail sections of your report based on some criteria your RecordSource is not aware of, and you have a ... Private m_sum As Currency '...

I find this a hard problem. Like, I've committed to a pattern, but it's not quite right, so making it work is painful and laborious. So do I stop, back up and get the pattern right, or push on and get the job done? Getting the job done will be way easier if I get the underlying pattern right...

Is that a real estate database?

I don't know much about how memory works, but my machine has 12GB of RAM. Task Manager says I've occupied 61%, so I've got 7.3GB of wiggle-room, and the max size for an Access file is 2GB. I think it'll be fine.

It's hard to deal with hierarchies in recordsets, but it's way easier if you use classes. Imagine a class that stores its Field.Values in a Scripting.Dictionary keyed by Field.Name... Private fields_ As New Scripting.Dictionary Private children_ As New Scripting.Dictionary Function...

You might be over-focused on this single method call as "the problem." What is the code for gbl_SH? How is it created and exposed? Under what circumstances is RegKeyRead() called? You've only shown the entry point.

When smart people leave India, India is not a beneficiary, https://www.cbc.ca/news/business/us-h1b-visa-canada-benefits-1.7640068 Trump's move is a gift, but not to America.

A link makes sense if a child entity is multi-dimensional, but if the child only has one dimension, just store that single data-point directly in the parent. You can put a combo on the field, and look up a finite list of data if you want, but when you link to a single field, the complexity of...

This might be a data error, for instance, a field you expect to contain a value is actually null. When processing the report (so only some reports for only some sets of data) the null causes an unhandled error, which bubbles up the call stack, and manifests as a failure in a higher level...

I did a bit of work in MS Project a couple of years ago, and my impression was it was wide open for integration. It exposes tons of open text and numeric fields you can push data into. I thought the object model was superficially simple, with Tasks and Resources as the two main info silos, and...

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