Search results

Hey @dalski, if you are working with a popup menu or commandbar, and you don't want to handle the click using the OnAction property callback, check out this thread: How to handle a CommandBarButton click event. • This is actually the same pattern as the TextBox right click handler you were...

The indicator IS the history, and it should not be stored in the parent row. Say I have a People table and I want to keep track of their weight over time. Their weight at each measurement should be stored in a related table. tWeight WeightID (PK) PersonID (FK) Weight (data) Date (data) What...

I would not do this at the table level. A table is--and should remain as much as possible--a dumb container. Yes, there are table macros, but these are mostly useful to enforce data integrity within or between dumb containers. If you need to provide or enforce business logic it is way easier...

Cool. :cool: Also, nice to meet you. Welcome to the forum!

Ha, I don't do things properly. Everything I touch needs to be edited, modified, renamed, revised and refactored. • Exactly why, if I want to add a control to a group, I don't like having to ... 1) open the form in design view, 2) leave the IDE, 3) select the control 4) open the property sheet...

No, seriously.

Use a report instead. Resize all the Textboxes so they are tall and narrow and then set them all to TextBox.IsVertical = True. Reverse the column order, print it, and hand it to the customer rotated 90 degrees.

What I dislike about using Control.Tag to group controls is you have to leave the IDE, open the Property Sheet, and poke around with individual controls. What I like more is to explicitly create a control group as a form property, like... Private Property Get MyTextboxGroup() MyTextboxGroup...

Hey @dalski, can you post the Db? • This stuff, as you know, gets tricky right out of the gate. • It's way easier to understand code by running it. Cheers,

Spoiler Alert: One of those is a property of a Recordset. ;)

You can also use Recordset.PercentPosition instead of .AbsolutePosition. • doesn't fail if you remove the last row, • might move the current record pointer up (like if you remove the last row).

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