Search results

You need to describe the symptoms of this failure. Just to say it fails is not enough info to troubleshoot.

Another trick you can do debugging is change the Error Trapping setting (indicated by MajP in #26) programatically using... SetOption "Error Trapping", < values in 0, 1, or 2 > Or you can write a little routine that saves you typing, and can return the current setting, like... Public Enum...

Thanks, Pat. I do think I have one guy on a runtime, so I'll have to test it out first.

Agreed too, but I thought the thread might lead some to think it's a good idea to do in the first place. It works, it can get you across the finish-line, but its fragile.

A point worth making IMO in respect to working with control references in queries: • Don't put control references in queries. Control names and anything along the path that references them are ... • subject to change without notice, and • not subject to compiler scrutiny. You might as well put...

But you have to be in design view don't you? I assume with the UserForm you can do so while it's open, but I haven't checked it out yet. OK, got it, thanks.

Showing the UserForm toolbar did not enable addition of a UserForm for me, but I was able to export a UserForm.frm file from Excel, and import it directly into the Access IDE. This automatically added an MS Forms 2.0 reference, but the UserForm insert option still doesn't appear. I am...

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