@Vogel612 Confirming my knowledge sensei: The only time a merge in git will be noted is when a conflict occurs and it must be resolved. Otherwise git will fast-forward and sequentially apply the commits as previously committed.
Why does VBA-Landia have to be so helpful? Implicitly converting a integral numeric Long to a String isn't what I want. I'd rather the compiler barf and yell at me to be explicit aboot it.
@puzzlepiece87 The thing with async/await is that you need some synchronization context running a message loop to come back to in order to really make good use of it.
Btw, you might want to look at NavigationWindow and Pages for your style of application. It kind of sounds like a wizard.
I have the following setup of a class with 2 contained classes:
'ClassA
Private Type TClassAData
myClassB as ClassB
End Type
Private this as TClassAData
Private Sub Class_Initalize()
Set myClassB = New ClassB
End Sub
Public Property Get myClassB() as ClassB
myClassB = this.myClassB
'^ fails with error 91 - Object required
End Property
'ClassB
Private Type TClassBData
myClassC as ClassC
myClassD as ClassD
End Type
Private This as TClassBData
Set myClassC = New ClassC
Set myCladdD = New ClassD
End Sub
I'm getting that error because at the time I'm trying to assign myClassB = this.myClassB, myClassB has not yet finished it's Class_Initialize and therefore doesn't yet exist. Right?
mornin' @Phrancis! How's things in southern IN?
What I really need to do, is instead of using Class_Initialize, I probably need a factory that knows how to create a new ClassA, then once I have an actual, existing object, it can then new up ClassB and ClassC, right?
@FreeMan Isn't the issue simply that it should be SetmyClassB = this.myClassB within the property Get? Also, I think the declaration this As TClassAData results in auto instantiating the myClassB UDT member.
Nope...I take it back. Ran a test -- no auto-instantiation of UDT class members.
@FreeMan It would seem OK (and appropriate) to call Set this.myClassB = new ClassB within Initialize. I'm thinking the trouble is that the Property myClassB is called within Initialize prior to instantiating this.myClassB
Without going deep into math, is there a way to make sure that non-open source programs like WhatsApp, FaceTime, Zoom, etc. are really using end-to-end encryption instead of just 'regular encryption' (i.e. the server has the cryptographic keys)?
Yeah. Like I said, horrible feeling. Unfortunately it's true. The answer to that question is, "Nothing". SE won't let you make a 1-word answer, though.
Having dealt with 25-hour tests for the US military, they will straight up kick you out of the lab space, keep one person "comfortably" on the premise until they finish who knows how it was built and can help them add what they want/need
had a buddy who claimed he was a hostage, because he was the primary engineer; they kept him in the room, and escourted him to the restroom, having confiscated his phone, for roughly 72 hours
mind you, we were working on sensors for glucose, or any attributable contained-in-lymph compound, and worked in a red cross building. the founder worked at georgetown and built it in relation to a few... specific compounds, which were very important that some people not be able to find. yeah, we later sold and that company went under
the electronics were 'tinkered' to fit and we lost our existing materials/product when everyone left
Topic switch: Original design had several classes that held data and procedural code that populated them then built some reports from them. I've now modified that so that for one of the classes, the code that populates the class is now methods on the class instead of stand alone procedural code.
In attempting to report on the data, I'm getting error 91. I think I now also need to incorporate the report generation code into the class as well. That way I can execute class.populateYourself and class.ReportYourself, instead of Class.PopulateYourself and GenerateReport (Class)
I think this is most likely the source of the error, since I'm getting the 91 in the existing GenerateReport (Class) code.
Am I in the general vicinity of the switch yard leading to the right track?
91 is object not found error, i believe; do you pass an object or just data?
i see you using 'class' as the object, from the dot notation, but are you actually passing that into the GenerateReport (class) when you run the code? just making sure you don't have a line in there that isn't qualified
(Class) contains a populated instance of the newly modified class containing the data and the methods for population.
I do know that I'm passing in a populated version of the class. The data that I'm trying to report on is a "sub-class" (see discussion earlier) of Class. Class contains data because some of it is used in generating report headers, and that's working properly. It's Sub-Class that's throwing the 91
gotta go back to the point just before the call and make 100% sure it's populated at that point...
yeah, i'm digging through the rest of the convo and i'm not seeing anything... i feel stupid thinking that the only info i'm not seeing is if the sub-class is referencing the class and the passed class information isn't dimensioned in the sub-class. was there an Implement? I see the example that Ben wrote as the only provided code (i feel like i'm mentally rebuilding the convo, so if i'm f'ing stupid, just say to chill... trying to help, but i don't want to make things worse)
@Cyril no Interfaces. Having a class to hold the data instead of having 10000 local variables to be passed around the universe (or worse, global variable) was my advanced tech at the time I originally wrote this. I'm trying to streamline and refactor for better understanding & code flow.
so i feel a bit stupider now than before... and i don't know how this happened, so stupider yet. i scrolled up and hit the wall, so "load older messages". i didn't check the dates, but apparently i'm getting data from 2017, 2018, 2019, and a few posts from today and some from january. i just hit ctrl+f5 and now i see your code that you wrote. surprisingly, that code ben wrote is from 2017 i'ma just step away for a minute and collect myself
@FreeMan Without knowing all the details (obviously) I'm wondering if working towards a syntax more like reportGenerator.ReportOn(data As ReportDataObject) to keep the reporting generation and the data generation/loading as separate concerns may be easier to work with.
I was thinking, maybe incorrectly, that having an object that held data as properties and had Gather and Report methods would improve the "object oriented designedness" of the whole thing, so that was the direction I was trying to move.
@FreeMan From an 'object oriented designedness' perspective, the approach of including Gather and Report would seem to test the Single Responsibility Principle. But everyone's mileage varies.
Sounds like your data class will nicely replace the GatherDataTypeA sub. Generating the report sounds like a separate responsibility => so a different object/class.
If the report ever changes, you can leave your data object alone (for the most part) and create a new report in the reporting 'class' (or a new reporting class altogether). Or, if the process of Gathering ever changes, you can leave your report generation classes alone.
well, that's kinda where the current problem is. I've modified the data class to contain the code to populate itself, and now, when I'm passing it to the report, it's giving me an error 91 -saying it's empty.
I think for now, at least, I need to leave well enough alone.
I had to make some DB structural changes to normalize data (long overdue), and I've got the changes to deal with that in production. I think I'll let this sit & stew while I get to other, more pressing issues...
I have ClientList which contains a Collection of ClientItems. ?clientList.ClientItems.Count yields 15.
A ClientItem has a Name property and ?clientList.ClientItems.Item(1).Name yields the expected name.
A ClientItem also has a NPSScores property that is not a collection of scores, but it should be. I think that's where the problem is.
rubberducking FTW
carp.
in the need to get the month-end reports completed. I need to make sure what I've already migrated to production is fully ready to go, then I can work on fixing this WIP next week.
welp, here's an interesting code that is totally legitimate but will throw a false positive regarding misuse of IsMissing:
Public Property Get DefaultValue() As Variant
If IsObject(This.DefaultValue) Then
Set DefaultValue = This.DefaultValue
Else
If IsMissing(This.DefaultValue) Then
DefaultValue = Null
Else
DefaultValue = This.DefaultValue
End If
End If
End Property
The This.DefaultValue is a Variant, and thus legitimately could be assigned Missing.
I think it's ok to get a false positive since it's very unusual and needs to be examined closely. I would rather put a @Ignore but just wanted to share.
I just switched branches in git for my Access project. Last I worked on this project was early last week. However, several of the files have today's date stamp. Is this to be expected in Windows?
@IvenBach just outta curiosity, how heavy is that?
worst thing is that I know I migrated my updated code to Prod, but it doesn't seem to be there. Even worse (than the worst thing? Yes.) is that it's not there in Dev, either!!!
Now I've got to figure out what happened to these changes I made late Mar/early Apr.
:(
on the bright side, though. Where importing via OASIS was taking a really long time last week (best part of an hour!), today it's going by in seconds.
I did a boo-boo and tried to import a >10,000 rows table and in other instance a single row that's a blob field worth 2-3 MB of binary data. Both didn't go well.
Without going deep into math, is there a way to make sure that non-open source programs like WhatsApp, FaceTime, Zoom, etc. are really using end-to-end encryption instead of just 'regular encryption' (i.e. the server has the cryptographic keys)?
.JPG){kind=link}
.JPG){kind=link}
VBA Rubberducking
VBA Rubberducking