Search results

What Option Private Module is to a standard module, so the Friend modifier is a procedure. A procedure can have three possible modifiers, Public (default), Private, and Friend. When declared as Friend, a procedure is only visible--and only available to execute--within the same project it is...

Yeah, when I developed that pattern I was pretty happy, because the pattern I was using before was... • Save and expose a temporary public reference to the owner/creator of cPopup • Execute the .OnAction callback • Get the .OnAction method to re-callback to the temp/public cPopup owner with...

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