Search results

In support of Colin's post #4, if you run this query... SELECT MSysObjects.Name, MSysQueries.* FROM MSysObjects INNER JOIN MSysQueries ON MSysObjects.Id = MSysQueries.ObjectId; ...you can then run a Text Filter on the MSysQueries.Expression field, and the MSysObjects.Name column...

Retro??? That sh*t is cutting edge!

I'm on 64 bit.

@murray83 I think this is really cool, thanks for posting. Also, it runs out-of-the-box on my machine. Running version 2507 (Build 19029.20156).

If there is then a duty to act out of that concern, what action are we called to? From discomfort in my own uncertainty, peace is mine when the other agrees. • Thus I seek to change/convince the other. • I have need, the other provides. From peace in my own uncertainty, peace is mine when...

@dalski Not at all. It is a pleasure to find someone as curious and interested as you. I get a huge kick out of coming to understand new code patterns, so having an exchange with someone who shares that pleasure is itself a pleasure. Cheers, Mark

Converted to .accdb

No, your first function does not create an instance. Somewhere you need to use the New keyword to create an instance. Your first function will raise an error because GetStrategy is not an object yet.

Then, if you have a cTaxEngineFederal class, it might look like... Private stg_ As Object Private year_ As Long Private fedTax_ As Currency Private prvTax_ As Currency Sub Init(Year As Long, Province As String) year_ = Year Set stg_ = GetTaxStrategy("Calc" & Province & "Tax") End Sub...

Consider a function like... Function GetTaxStrategy(Name As String) As Object Select Case Name Case "CalcOntarioTax": Set GetTaxStrategy = New cTaxEngineON Case "CalcBCTax": Set GetTaxStrategy = New cTaxEngineBC Case "CalcQuebecTax": Set GetTaxStrategy = New cTaxEngineQC...

Well, your first function will fail because GetStrategy does not exist yet as an instance. In the second function you create an actual instance (using New, which is essential) which is scoped to the function. This returns to the caller, a pointer to the new instance.

Also note the difference between an instance of an object and a pointer to it. Any variable "containing" an object is actually just pointer to an object, not the object itself. As a result, if you do... Dim col As New VBA.Collection Dim tmp As New cSomeClass Dim i As Integer...

Not a feeble mind!!! This is hard. Complicated, and not intuitive! So be patient and persistent. See if this sample helps.

No matter what you believe, as you walk the path of your own narrative you will find it ends in profound mystery. Reasoning from science confronts the unknowable. Belief in God confronts the unknowable. Possibly, the degree to which you think your own view is worth arguing is directly...

Because Form.Parent will raise an error if there is no parent, I commonly write a custom property on a subform as follows... Property Get ParentName() As String On Error Resume Next ParentName = Me.Parent.Name End Property With the presence of such a property, you can now write code on the...

Remember, a class instance is a discrete and unique object. Your clsDalsTxtBox class is designed as a wrapper around--or container for--a single TextBox. As such, you need a new and different container instance for each different TextBox you wish to contain, and this is why you need a user...

Your Frm code needs to create a new instance of clsDalsTxtBox inside the loop. Each TextBox should be loaded into a new unique instance. Your code creates only one instance, and then inside the loop keeps replacing the TextBox it contains with the next one. Consider... Private m_col As...

Colin, my intent is to get more involved, but I blew it this a.m. (I'm GMT -9 so it was 10am), but I grabbed your .ics link so I've got it now in Outlook as a recurring appointment. Hey George, I just joined the Pacific Access User Group.

Hey @Pat Hartman, best wishes on a complete and speedy recovery! Mark

Hey @isladogs, are these events recorded and available after-the-fact? If so, can you point me to where they can be found? Thanks, Mark