Search results

I've experienced this MANY times & it has always been as per @RonPaii's suggestion - a circular reference caused by my bad code not terminating a circular reference. When studying basic C# & C++ (very basic courses) I & the article refer to them as memory leaks. But I've been informed by someone...

Thanks, sure I was not aware of the Get type needed to be defined as the default VBA insert procedure uses variant so that made me completely unaware that when not using the Variant type. But I cannot see how one came to the assumption it being a String datatype when it was defined as long & I...

I don't think they update 2010 now so what I'm saying should be redundant. Is one a 32-Bit machine the other 64-bit?

Thanks all, appreciate that guidance that's not how to use properties. I don't think that's correct, that's been taken out of context; you've removed the apostrophe & also removed FAILS ALSO. Which was to show I had experimented so this line is not even in execution. You have no way of knowing...

No @cheekybuddha solved it, that was the issue here. Maybe when there's more going on than a basic assignment. I've gotten away with just using a basic Get most places but he's right.

Thanks cheekybuddha, you're dead right. I'm perplexed as i have a near identical property that's working fine. Just can't spot what the issue is. I'm not enjoying superflating the Properties with methods & may prefer a call, but in the interest of trying to learn; can't help but play around.

Thanks, yeah I had it as a sub/ function but seemed more intrinsic & seems clearer as a property. "how do you supposed to assign Value from..." unsure what you mean here. Originally I had it as a function, would call it where needed & store it in the module var. But thought between calls...

Could be Microsoft Office Update problem; which there have been a few lately. But more sounds like the class is setting a property from the AfterUpdate event, and there is no object variable WithEvents in there. Stick an object variable in there WithEvents as below which should remove this...

I have some Properties (around 30; most are typical assignment format). Some values are assigned by procedures/ routines inside the Property/ or called. I'm probably going to get told off but these are quite intrinsic values to the class object. I would prefer to call a function to keep the...

I think you can run almost anything you want in VBA. It's a matter of going to the IDE (Alt+F11) then referencing said namespace/ DLL (Dynamic Link Library), you then have access to it's procedures... You are then behest to the documentation/ info available to that namespace/ DLL (application)...

I spent quite some time searching, in the end I found a solution by the honourable @Richard Rost has it; needs to be assigned to the click event. Private Sub TxtBoxName_GotFocus() Me.TxtBoxName.SelStart = (Len(Me.Description.Text) + 1) Me.TxtBoxName.SelLength = 0 End Sub

MajP Thankyou This is where I was going wrong. I went through the Object Browser more times I could count & I see it now. I fear I'll make this mistake again in the future as I really would have thought it was a more friendly reference by just accessing the subform; & the table/ recordset was...

Thanks for all contributions. @MarkK I'll look at yours once I get my head around this. I know it's not good design but for now I need to understand scope. Attached is a poor e.g. I know but the goal is to get a deeper understanding of scope & visibility of classes & variables...

Thanks Tom, there will be multiple instances of Class-A & B later, was unaware of static class so thanks for future. I failed to mention that Class-A was in a different subform (call it subform-A) when it instantiated the public Class-B object variable. So it seems that because subform-A has...

Thanks @MajP, understood. That's worrying, hopefully this will change your opinion. Class-A & Class-B's methods & properties are accessed elsewhere. They decouple the current subforms & allow these methods... to be used for other purposes elsewhere in different instantiations of different...

Class-A instantiates Class-B. I need a subform (outside of Class-A & Class-B) to gain access to the instance of Class-B. How do I get a pointer to the instance of Class-B? I could create an object variable of Class-B inside the subform but this would create a new instance of Class-B (undesired)...

Of course, this is what RAM (Random Access Memory) is, & goes without saying for every application ever written. :ROFLMAO: :ROFLMAO: You're comparing apples with oranges, complete different topic in itself which results would be subject to how they were implemented. This thread's solution was...

In this case it was not about events, or forms. It was that Access protects wiping out user class-instantiation unnecessarily with this prompt; which is the same prompt as provided when code has not fully completed between called procedures. You're getting a little hung-up on standard Access...

Thanks, sorry I did not clarify in the OP I was talking handling user-declared bespoke Events with the Event-Handlers in different classes (not a basic Form Event like current) & we're a bit beyond instructions on how to set a breakpoint. The reference to Access objects was a very basic e.g. to...

Modern websites (last 20 years or so) use Cascading Stylesheets (CCS), & the media rule to test device size & apply appropriate designs for each/ type of device viewing/ processing the content. Think you can apply different stylesheets entirely.