Search results

I wouldn't reach down into a child object, pull out its data source, apply a bunch of logic, and then stuff that data source back into the child... Rather, the child object should expose a method, like... Forms!frmDetail!ItemDetail.Form.AddItem ID, Path The object that owns the data should also...

When adding a row to recordset, grab the new ID after an edit, but before the update... Dim newRowID As Long With CurrentDb.OpenRecordset("SELECT RowID, SomeField FROM Table1") .AddNew !SomeField = "Updated" newRowID = !RowID .Update End With

A potential problem with not retaining data model instances--if you are going to create them at all--is that if your user/consumer code requests one, and then requests the same one again--which is very common--now you have two distinct instances representing the same data within your own system...

I think you'd be more likely to use a factory pattern for composition, for instance, if you have a class that contains other classes. Then the factory might take responsibility for creating the parent instance, and injecting collections or related object instances specific to that parent...

If you use a With block... • you don't need a recordset variable Also, when you first open a recordset, if it... • contains no records, .EOF will be true. • contains one or more records, the first record will be current. Therefore, you don't need to... • check .BOF, or • .MoveFirst So you can...

The notes field is bound to the same RecordSource as that which drives the continuous form. If the record selected in the continuous form is on a new record, and you start typing in the notes field, this creates a row. One option to prevent this is as follows... Private Sub Form_Current()...

Do you have code somewhere that adds that null record? If so, I would debug by setting a breakpoint in that code. Then cause the problem. When execution hits your breakpoint, pop open the Call Stack viewer and look at what routines call what other routines such typing in the notes field causes...

If institutions are required to kiss government ass, individuals will be so required in due course. Vote your conscience on this man, but before you do, take a look around the world, and take a look around history, take a look at states where institutions and individuals are required to kiss...

Brilliant. Establish a Department of Truth, and only fund institutions that kiss government ass. Nice "Land of the Free" you got there. Sure would be a shame if something happened to it. And if state-sponsored institutional arm-twisting is valid, why stop there? Why not arm-twist individuals...

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